Reply To: CountMatch() vs BarsTrue()

[Darren]

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:

TIMESINCESIGNAL(RSI(BARS=14)<50)

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

Attachments:

You must be logged in to access attached files.