Support Board
Date/Time: Wed, 19 Mar 2025 18:07:14 +0000
Post From: Obtaining Input data on Spreasheet Study:Swing High and Low
| [2022-10-26 02:27:31] |
| Sawtooth - Posts: 4186 |
|
Extending lines until future intersection is not a strength of a spreadsheet study, because you'd need a Formula Column for each line displayed. It should be possible to create a limited number of lines, staying within the 60 Formula Columns max, where the oldest line would be replaced when a new Swing H/L occurs. I think you'd need 3 Formula Columns for each line, using this example as a basis: https://www.sawtoothtrade.com/free-stuff-14.html And use this example to find previous Swing Highs and Swing Lows: Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values So you've used 3 Formula Columns for each line, plus another to find each previous value. And possibly a couple of other columns for various things, so you'd only be able to display about 7 pairs of FIFO lines in a single Spreadsheet Study study. The usefulness of this is dubious at best. This is best done with ACSIL. |