Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 12:47:33 +0000



Post From: Zig Zag Study Oscillator and Spreadsheet Trading

[2020-07-18 19:21:36]
Sawtooth - Posts: 4000
If you only want a +1/-1 for the pos/neg slope of the ZZ Osc, try something like this in a Formula Column:
=IF(ID1.SG9@3>0,1,IF(ID1.SG9@3<0,-1,0))
where the ZZ study is ID1.

And there is this example that outputs +1/-1 of a subgraph line's upslope/downslope:
Spreadsheet Example Formulas and Usage: Formula that Matches the Slope Coloring of a Study Subgraph Line