I currently have a color bar based alert setup that paints a bar using
=CROSSFROMBELOW(ID7.SG1, ID1.SG5)

I would like to add another condition in so the alert only paints the bar IF price exceeds the highs of the prior 3 bars before crossing back below CROSSFROMABOVE(ID7.SG1, ID1.SG5)

Any help would be appreciated.

Cheers

If you want to 'store' the crossover event until/if price exceeds the previous 3 highs, you'll need to use a spreadsheet study, as this exceeds the capability of Simple Alerts.

If the crossover occurs concurrently with price exceeding the previous 3 highs, you could use this:
=AND(CROSSFROMBELOW(ID7.SG1, ID1.SG5),C>MAX(H[-1],H[-2],H[-3]))

tomgilb 

If you want to 'store' the crossover event until/if price exceeds the previous 3 highs, you'll need to use a spreadsheet study, as this exceeds the capability of Simple Alerts. If the crossover occurs concurrently with price exceeding the previous 3 highs, you could use this: =AND(CROSSFROMBELOW(ID7.SG1, ID1.SG5),C>MAX(H[-1],H[-2],H[-3]))

Thanks Tom, I thought that might be the case. Occurring concurrently is still useful though, so really appreciate that.

Aside from what's provided on the SC website, is there any other good resources for learning how to use the spreadsheet studies? I'm not familiar with them at all.