Support Board

Date/Time: Sat, 27 Jul 2024 02:20:16 +0000

Post From: MOBO Bands

[2023-11-20 14:58:22] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4051
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