Support Board
Date/Time: Sun, 15 Jun 2025 15:55:24 +0000
Obtaining Input data on Spreasheet Study:Swing High and Low
View Count: 741
| [2022-10-25 19:15:19] |
| User140688 - Posts: 13 |
|
Background: I got to know about Swing High and Low, This study has an input "Extend Swings until further intersection", I mostly work around using spreadsheets for alerts and trading, however, I could not find a way to export these lines to a spreadsheet, Query: Kindly help me export these lines ( Roughly S/R lines ) or an alternative to this, which would help me create an alert around these lines, price touching the line etc. or exporting these lines into the spreadsheet, I am attaching the images to give reference about the lines and input I am talking about and the spreadsheet column (Line Properties ) What I have tried so far: Tried changing the drawing type of Line Properties subgraph (which was default - Subgraph Name) to Line, dash, etc ; yet no change in spreadsheet column Any help would be appreciated |
 spreadsheet.png / V - Attached On 2022-10-25 19:08:17 UTC - Size: 42.76 KB - 188 views Attachment Deleted. sierra.png / V - Attached On 2022-10-25 19:08:54 UTC - Size: 67.32 KB - 189 views |
| [2022-10-25 21:11:34] |
| John - SC Support - Posts: 40422 |
|
The Extended Lines until Future Intersection are specialized items that are not directly accessible. The only way to access them is by creating a custom study. But, the extension lines are based on where the swing occurs. That information is located in the Spreadsheet for the Swing High and Swing Low. Depending on what you want to do with the information, you should be able to manipulate the data in the spreadsheet to get what you want. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-10-26 02:27:31] |
| Sawtooth - Posts: 4226 |
|
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. |
| [2022-10-26 19:37:04] |
| User140688 - Posts: 13 |
|
tomgilb
Thanks alot, I have been trying it using 3 formula columns but wasn't quite there, This helps alot
|
| [2025-05-20 12:54:47] |
| User98657 - Posts: 372 |
|
I happened to be playing around with something similar. The Trade Management by Study study does not work with the Swing High Low study. The extension lines on the SHL study are not true lines, so the study sees zero at the bar. So for purposes of giving the TMbS a value, this process works because you only need the last value created. If, for instance, you're in a long and you want to use the TMbS to follow behind the swing lows that are created on the way up, you only need the most recent swing low. As a new swing low is created, your stop would move up to that newly created level. The levels beneath you don't matter. However, if you're not wanting to keep your stop behind the most previous swing low (in a long), but instead are trying to stay behind the swing low prior to the most recent, you would need another group of formula columns. If you're looking for anything more complex however, I agree with Tom, would be better served by ACSIL. |
To post a message in this thread, you need to log in with your Sierra Chart account: