Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 18:12:06 +0000

How to Post a Message for Support

Obtaining Input data on Spreasheet Study:Swing High and Low

View Count: 342

[2022-10-25 19:15:19] #1 [Go To First Post]
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 - 61 views Attachment Deleted. sierra.png / V - Attached On 2022-10-25 19:08:54 UTC - Size: 67.32 KB - 63 views

[2022-10-25 21:11:34] #2 [Go To First Post]
John - SC Support - Posts: 31355
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] #3 [Go To First Post]
Sawtooth - Posts: 3992
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] #4 [Go To First Post]
User140688 - Posts: 13
tomgilb Thanks alot, I have been trying it using 3 formula columns but wasn't quite there, This helps alot

To post a message in this thread, you need to log in with your Sierra Chart account: