Login Page - Create Account

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