Support Board
Date/Time: Tue, 26 Aug 2025 13:23:30 +0000
Post From: Obtaining Input data on Spreasheet Study:Swing High and Low
| [2025-07-05 22:57:55] |
| Sawtooth - Posts: 4261 |
|
the only thing that seems like would be needed is some kind of Swing High Storage system to store all the values along with the time which it happened at
The link in post #7 shows how to make previous events persistent to row 3. It uses a Formula Column for each prior event, and the max Formula Columns is 60.A spreadsheet study might also be able to release the persistent value at another event, but it could get complicated. With the limitations of Formula Columns, the previous Swing Highs would necessarily need to be FIFO. And it gets more complex to only display the Swing Highs n ticks from the current price. What the spreadsheet study cannot do is repaint something in the past based on a current event. |