Login Page - Create Account

Support Board


Date/Time: Fri, 28 Feb 2025 22:34:55 +0000



Post From: Zig Zag Reversal Price

[2021-08-30 04:25:45]
User195924 - Posts: 68
Thanks, but I don't believe that's what I'm looking for:

I would like most recent high reversal when it's HH/HL and most recent low reversal when it's LL/LH. I just need to be able to incorporate additional condition into these formulas where text labels OR(ID1.SG2=1, ID1.SG2=2) return most recent High Reversal Price.... :

Cell O3: =IF(ID1.SG3@3 > 0, ID1.SG1@3, O4)
This sets cell O3 to the Price of the most recent Zig Zag reversal point.
Cell P3: =IF(ID1.SG3@3 > 0, O4, P4)
This sets cell P3 to the Price of the second most recent Zig Zag reversal point.
Cell Q3: =IF(ID1.SG3@3 > 0, P4, Q4)
Date Time Of Last Edit: 2021-08-30 04:26:02