Support Board
Date/Time: Tue, 26 Nov 2024 15:39:23 +0000
Post From: MOBO Bands
| [2023-11-20 14:58:22] |
| Sawtooth - Posts: 4120 |
|
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
|