Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 02:02:58 +0000

How to Post a Message for Support

Post From: [User Discussion] help to highlight candle based on certain study conditions

[2021-08-20 15:35:08]
[Go To First Post]
tuanluu20902 - Posts: 24
1. Add the Spreadsheet Formula study, and Hide this study.
Use a formula like this in its Formula field:
=IF(ID5.SG1>-100,0,IF(ID5.SG1<-200,1,ID6.SG1[-1]))
where ID5 is the CCI study, and ID6 is the Spreadsheet Formula study.
This creates a persistent 1 when the CCI goes <-200, and releases it to 0 when the CCI goes >-100.

2. Add the Color Bar Based On Alert Condition study.
Use a formula like this on its Alerts tab:
=AND(ID6.SG1[-1]=1,ID6.SG1=0)
where ID6 is the Spreadsheet Formula study.
This finds the bar where the persistent 1 was released.
Thank you so much for your detailed instructions! It worked, very much appreciated for the help!