StockFetcher Forums · General Discussion · Filter expression for trying to find high price in last 4 weeks not counting the immediate last week<< >>Post Follow-up
rudeStock
3 posts
msg #160869
Ignore rudeStock
modified
2/14/2024 9:46:48 PM

Assuming today is 2/14/2024 and following weekly high prices:

2/14/2024 => 14
2/7/2024 => 10
1/31/2024 => 12
1/24/2024 => 13
1/17/2024 => 10

I want to write a filter expression for getting the high price between 2/7/2024 (not counting the current week) and 4 weeks before 2/7/2024 which is 1/17/2024. I want the expression to return a value of 13.

How do I do this?


xarlor
578 posts
msg #160872
Ignore xarlor
2/15/2024 2:52:41 PM

Fetcher[
draw price line at high 4-week high 1 week ago
add column high 4-week high 1 week ago
]



rudeStock
3 posts
msg #160874
Ignore rudeStock
2/15/2024 10:05:34 PM

That simple! Thank you.

StockFetcher Forums · General Discussion · Filter expression for trying to find high price in last 4 weeks not counting the immediate last week<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.