Support Board
Date/Time: Sat, 13 Dec 2025 09:07:22 +0000
Post From: Color bar using Swing High and Low Indicator
| [2017-03-28 00:34:36] |
| Sawtooth - Posts: 4299 |
|
Try this: Add the Spreadsheet System/Alert study. -give it a name in the Spreadsheet Name field -set the Draw Style of SG1 and SG2 to Color Bar -set the Draw Style of SG3 and SG4 to Ignore Use these formulas on the spreadsheet: cell K3: =O3<O4 cell L3: =P3>P4 cell O3: =IF(ID1.SG1@3>0,ID1.SG1@3,O4) cell P3: =IF(ID1.SG2@3>0,ID1.SG2@3,P4) where ID1 is the Swing High and Low study; edit as necessary. If you also want audible alerts, they are set on the Settings and Inputs tab of the spreadsheet study, at Column K Alert and Columns L Alert |