Support Board
Date/Time: Fri, 28 Feb 2025 21:51:43 +0000
Post From: Zig Zag Reversal Price
| [2021-09-01 00:43:22] |
| Sawtooth - Posts: 4177 |
|
I simply want one cell to have current LH/HH reversal price and another cell with current LL/HL reversal price.
O3 is the current reversal price and P3 is the previous reversal price. These are the two values you want, except that they alternate columns at each reversal. To find the LH/HH in either O3 or P3, use this in Q3: =MAX(O3,P3) To find the LL/HL in either O3 or P3, use this in R3: =MIN(O3,P3) This works because the LH/HH pair is always greater than the LL/HL pair. If you paired them differently, it becomes more complicated. |