Support Board
Date/Time: Fri, 07 Feb 2025 14:47:30 +0000
Post From: [User Discussion] help to highlight candle based on certain study conditions
| [2021-08-20 15:35:08] |
| tuanluu20902 - Posts: 24 |
|
1. Add the Spreadsheet Formula study, and Hide this study.
Thank you so much for your detailed instructions! It worked, very much appreciated for the help!
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. |