StockFetcher Forums · Filter Exchange · Identify date of event<< >>Post Follow-up
1 posts
msg #123983
Ignore nj20
6/7/2015 10:33:52 PM

I am trying to find value of an indicator on a particular day withinin a look-back period.

ex: Find the money flow index (10) value on the day when the stock hit a highest high in the last 6 months
So, this would involve these steps
1) Find the date when the stock was highest in the last six months
2) Find the value of money flow index (10) or any other indicator on that specific date.

Needless to say, my attempts have not been successful.


4,599 posts
msg #124325
Ignore Kevin_in_GA
7/10/2015 8:47:02 AM

I know that Stratasearch can do this using a function called ValueWhen() but there is currently no such capability in SF.

4,388 posts
msg #124333
Ignore four
7/10/2015 11:35:52 AM

Perhaps this helps (a little) [does not give a value]


x = 1 , event occurred 1 day ago
x = 0 , event occurred today
x = -1 , event did not occur within the last 2 days [see the 2 in the set command, looking at last 2 days]


set{x, days(RSI(5) crossed below 50,2)}
add column x

draw rsi(5) line at 50
draw rsi(5) line at 70
low between 11 and 33
volume > 5321432

StockFetcher Forums · Filter Exchange · Identify date of event<< >>Post Follow-up

*** Disclaimer *** 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. does not recommend particular securities., 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 2018 - 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