StockFetcher Forums · Filter Exchange · Days since a Recent High/Low<< >>Post Follow-up
jeremytimko
4 posts
msg #105944
Ignore jeremytimko
4/19/2012 1:36:18 AM

Greetings, I'm trying to create a very simple filter that will return the number of days since the most recent range high close over a given time period and the number of days since the most recent range low close over a given time period. I think the "DAYS" function is the command I need to use. I am trying to apply this to a specific set of stocks, so, for example, I'm basically looking for a filter that will tell me how many days it's been since $XOM closed at a 21 day high /low. In the case of $XOM, as of today (4/18/12) the filter should return "12" and "7" respectively (if today counts as day 1).

Here is my pathetic attempt: SET{DAYSSINCE,DAYS(close reached a new 21 day high,21) is above -1}. I apply that to a list of stocks and get 0 results. I have started manually entering this data into Excel and it's taking FOREVER. Therefore being able to have this data at the ready via a filter would be a huge help.

Thanks so much for any help you can provide.

StockFetcher Forums · Filter Exchange · Days since a Recent High/Low<< >>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 2016 - 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