Support Board

Date/Time: Sun, 05 May 2024 13:04:30 +0000

Post From: Color bar using Swing High and Low Indicator

[2017-03-28 00:34:36] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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