Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 13:52:52 +0000

How to Post a Message for Support

How to get values from “Extend Bar Value Until Future Intersection” in Spreadsheet System

View Count: 97

[2024-03-20 19:33:11] #1 [Go To First Post]
PeaceFrog - Posts: 102
Hello, Thank you for taking the time to answer my question. I’m using the study “Extend Bar Value Until Future Intersection” but when I open the Study “Spreadsheet System for Trading”, the values for “Extend Bar Value Until Future Intersection” are all “0”. I’m wondering how I can have the Spreadsheet System for Trading contain the values? While trying to resolve this issue myself I found: https://www.sierrachart.com/index.php?page=doc/StudiesReference.php&ID=396#:~:text=This%20study%20will%20draw%20an,with%20a%20future%20price%20bar. But I’m not sure what to do now with: sc.GetStudyLineUntilFutureIntersection or how to programmatically access it through ACSIL: Thank you very much for your help. It’s greatly appreciated.

[2024-03-20 22:26:12] #2 [Go To First Post]
John - SC Support - Posts: 31159
Lines that are extended until a Future Intersection are special lines. These are not accessible through the standard interface. You would have to use ACSIL to access the lines. Refer to the following for a start: sc.GetStudyLineUntilFutureIntersection() For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-03-20 23:37:04] #3 [Go To First Post]
PeaceFrog - Posts: 102
Hi John, Thank you for replying. To clarify, I had found webpage: https://www.sierrachart.com/index.php?page=doc/StudiesReference.php&ID=396#:~:text=This%20study%20will%20draw%20an,with%20a%20future%20price%20bar. Which brought me to: sc.GetStudyLineUntilFutureIntersection I’m just not sure what I do with it? Or where I go from there. In your sentence “These are not accessible through the standard interface”, what does “standard interface” mean? I see the webpage says “The sc.GetStudyLineUntilFutureIntersection function is used to get the details of a line until future intersection from a study which has added one of these lines using the function sc.AddLineUntilFutureIntersection().” Which is great, those are the details I’m looking for, but I don’t see instructions on how to get them. (For context, I don’t understand the second part of the sentence “from a study which has added one of these lines using the function sc.AddLineUntilFutureIntersection().”) I’m looking for the Spreadsheet System for Trading to produce the Price value of the lines created by “Extend Bar Value Until Future Intersection”. I see that the webpage says “Return Value: If the line is found, 1 is returned. If the line is not found, 0 is returned.” – I’m not looking for a “1” or “0” return value, I’m looking for the Price of the extended line to be returned. I hope this helps clarify what I’m looking to achieve. Is it achievable? I’m fairly unfamiliar with this kind of thing. Thank you again for your help. It’s very much appreciated.

[2024-03-21 14:48:18] #4 [Go To First Post]
John - SC Support - Posts: 31159
What we mean by "These are not accessible through the standard interface” is that you can not access the extension lines using any of the tools that are accessible through the program interface. In other words, the Spreadsheet Studies will not work or any other study that is supplied with the system. You need to create a custom study to do what you want and the function sc.GetStudyLineUntilFutureIntersection is used within the program that you create to get the lines. Refer to the following: sc.GetStudyLineUntilFutureIntersection() If you need someone to create a custom study for you, there is a list of programmers at the following link: List of Third Party Sierra Chart Study and System Programmers For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-03-22 12:27:54] #5 [Go To First Post]
PeaceFrog - Posts: 102
Ok. Thank you John. Appreciate your time and the clarification.

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