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.
|