nj20
1 posts
msg #123983
- Ignore nj20 |
6/7/2015 10:33:52 PM
Hello
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.
thanks!
|
Kevin_in_GA
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.
|
four
5,087 posts
msg #124333
- Ignore four
modified |
7/10/2015 11:35:52 AM
Perhaps this helps (a little) [does not give a value]
http://www.stockfetcher.com/forums/Announcements/New-Feature-Days-Since/29428
/*
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]
*/
|