I would like to create a formula that finds all monthly securities whose high for the current monthly period  is less than the low of the previous 21 day period.

The formula I have entered below does not work. It brings up zero stocks. WHY? Can you tell me what is wrong?

MAXH21 < MINL21.21

Try this

MAXH21<MAXH21.21

Yours tested against the low.

Thanks

Whoops I just saw you wanted the low from your post.

I don&rsquo;t think your PCF ever returns true.

I would guess because the lookback is the same
length as the lookback period.

Thanks

The ranges do not overlap, but it is still a relatively unlikely scenario. There must have been a gap down between 21-bars ago and 20-bars ago where the high was not only lower than the prior low, but lower than the 21-prior lows. Then the high needs to stay below that low threshold for the next 21-bars.

That said, it currently returns true for me for 16 symbols in the All Items in System WatchList in TC2000 version 7 (when I include things like Pink Sheets and Bulletin Board stocks in TC2000 version 12.3, I get 107 symbols): ACH, ARAY, CHA, DBA, DOIL, EEHB, GSGO, INXX, PSMI, RBCN, RDS.A, RDS.B, SJL, SLT, SWM & XIDE.