Support Board
Date/Time: Fri, 28 Feb 2025 05:08:31 +0000
Post From: Zig Zag Study Question
[2021-07-23 18:04:38] |
Sawtooth - Posts: 4177 |
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
|