Support Board
Date/Time: Tue, 26 Aug 2025 11:52:54 +0000
Obtaining Input data on Spreasheet Study:Swing High and Low
View Count: 934
| [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 - 230 views Attachment Deleted. sierra.png / V - Attached On 2022-10-25 19:08:54 UTC - Size: 67.32 KB - 237 views |
| [2022-10-25 21:11:34] |
| John - SC Support - Posts: 41464 |
|
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: 4261 |
|
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: 373 |
|
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. |
| [2025-07-04 16:30:43] |
| User811487 - Posts: 15 |
|
Hello, was anyone able to figure this out, I am trying to output the nearest 5 support and nearest 5 resistance levels at every single data point, any clue how this can be done. any help on the matter would be greatly appreciated. |
| [2025-07-04 17:07:53] |
| Sawtooth - Posts: 4261 |
|
...but instead are trying to stay behind the swing low prior to the most recent, you would need another group of formula columns.
I am trying to output the nearest 5 support and nearest 5 resistance levels at every single data point
You can do it with a spreadsheet study using a variation of this example:Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values |
| [2025-07-05 15:44:05] |
| User811487 - Posts: 15 |
|
this shows the most recent levels, I'm looking for the most recent (and closest proximity to close) levels that Haven't been invalidated for each row
|
| [2025-07-05 16:36:32] |
| Sawtooth - Posts: 4261 |
|
I'm looking for the most recent (and closest proximity to close) levels that Haven't been invalidated for each row
This would require a custom ACSIL study.
|
| [2025-07-05 22:06:23] |
| User811487 - Posts: 15 |
|
Is there any way to manipulate the data by using formulas within the spreadsheet to take care of this , I just want to create a condition that 1) finds when the swing high was created and the checks the highs of the Row(SwingHighBar - 1)until Row 3 . If the Swing high is > than all of those prices in between I want it to be plotted. Whereas if the Price(SWingHighx) < Any of the highs between(Row3-and Row(X-1))to please return a 0 it sounds fairly simple, 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 Let me know if anybody has any ideas on how to do with within the spreadsheet study, would be very useful |
| [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. |
To post a message in this thread, you need to log in with your Sierra Chart account: