Support Board
Date/Time: Mon, 17 Mar 2025 17:32:59 +0000
Post From: Trying to paint the area between two Candles if there is a Gap between Low and High
| [2022-09-10 16:50:02] |
| Sawtooth - Posts: 4185 |
|
Yes please, will appreciate further details.
Add the Spreadsheet System/Alert study.- Give it a name in the Spreadsheet Name field. - Set the Draw Style of SG5 to Box Top Center - Set the Draw Style of SG6 to Box Bottom Center - Formulas on the spreadsheet: Cell O3: =IF(D3>C5,D3,0) Cell P3: =IF(D3>C5,C5,0) Column D is the Low Column C is the High The current bar is in row 3, previous bars in rows below. You can duplicate this for the down direction using another two adjacent columns. Columns K-N are for reserved for alerts. Any non-zero is a TRUE. Alert settings in spreadsheet studies are managed on the Settings and Inputs tab, not on the Alerts tab. You should be able to combine all of your Region 1 alerts into this spreadsheet study, if you want to. |