Support Board
Date/Time: Sat, 12 Jul 2025 19:39:50 +0000
Post From: Mark the most recent pair
| [2025-06-25 14:43:37] |
| Sawtooth - Posts: 4238 |
|
How to use a spreadsheet formula to plot markers on each of only the most recent pair of higher high closes?
Try this:- Add the Spreadsheet Study study, set the Chart Region to 1, and give it a name in the Spreadsheet Name field. - Use these formulas in these cells: K3: =IF(E3>K4,E3,K4) [this returns a persistent higher close] L3: =K3<>K4 [this finds each higher close] M3: =IF(L3=1,K3,M4) [this returns the most recent higher close] N3: =IF(L3=1,M4,N4) [this returns the second most recent higher close] O3: =OR(AND(L3=1,M3=M$3),AND(L3=1,M3=N$3)) [this isolates only the two most recent higher closes] - Set all Draw Styles to Ignore, except set O(SG5) to Color Bar, or Point On High. This uses an modification of this example: Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values |