Login Page - Create Account

Support Board


Date/Time: Tue, 07 May 2024 05:47:58 +0000



Post From: Zig Zag Study Question

[2021-07-23 18:04:38]
Sawtooth - Posts: 3993
It can't be done with the Zigzag study.

It can be done with two instances of the Spreadsheet Formula study:

1. Add the Spreadsheet Formula study:
- Set the Chart Region to 1.
- Set the Value Format to 1.
- Set 'Draw Zero Values' to No.
- Use a formula like this in the Formula field:
=IF(AND(ID1.SG9[-1]>0,ID1.SG9<0),ID1.SG5,0)
where ID1 is the ZZ study.
- Set the Draw Style to 'Value On High' and set the Width/Size to 10.
- Set the Auto-Coloring to 'Based on +/-'

2. Duplicate the above study.
- Reverse the operators in the formula in the Formula field:
=IF(AND(ID1.SG9[-1]<0,ID1.SG9>0),ID1.SG5,0)
- Set the Draw Style to 'Value On Low'

3. In the ZZ study, 'Display Zigzag Volume' needs to be No, or you can Hide the study.

Note: The formula only plots SG5 where SG9 changes polarity.
Date Time Of Last Edit: 2021-07-31 17:53:39