Support Board
Date/Time: Thu, 05 Dec 2024 18:20:01 +0000
Post From: MOBO Bands
[2023-11-20 14:58:22] |
Sawtooth - Posts: 4133 |
You need to create a persistent TRUE in each direction, then find the transitions. 1. Add the Spreadsheet Formula study, and use a formula like this in its Formula field: =IF(CROSSFROMBELOW(C,ID1.SG1),1,IF(CROSSFROMABOVE(C,ID1.SG3),-1,ID2.SG1[-1])) where ID1 is the BB study, and ID2 is this Spreadsheet Formula study. Hide this study. 2. Add the Color Bar Based On Alert Condition study, - Set 'Output When Condition True' to Use Input Data - Set 'Input Data' to High - Set the DrawStyle to Arrow Up - Use a formula like this on its Alerts tab: =AND(ID2.SG1[-1]=-1,ID2.SG1=1) 3. Duplicate the color bar study. - Set 'Input Data' to Low - Set the DrawStyle to Arrow Down - Use a formula like this on its Alerts tab: =AND(ID2.SG1[-1]=1,ID2.SG1=-1) Date Time Of Last Edit: 2023-11-20 15:07:42
|