Optuma Forums › Optuma Scripting › CountMatch() vs BarsTrue() › Reply To: CountMatch() vs BarsTrue()
February 9, 2021 at 10:22 pm
#62393
- Topics: 70
- Replies: 832
- Posts: 902
Hi Andrew,
For timecounts use the TIMESINCESIGNAL function (click here for examples). In your case you want to count how long it has been since your condition (RSI > 50) was false. Or – to frame it another way – how long has it been since RSI was below 50? This opposite condition is what you want to use:
1 2 3 |
TIMESINCESIGNAL(RSI(BARS=14)<50) |
In this example of the Dow 30 stocks, $WBA has had an RSI above 50 the longest at 25 days, with $KO, $IBM, and $HON crossing yesterday. Obviously, those with 0 are currently below 50. Workbook attached (green areas show where RSI>50).