Support Board
Date/Time: Wed, 25 Jun 2025 21:56:04 +0000
Study to refer to the value
View Count: 707
| [2021-12-08 02:32:22] |
| User558455 - Posts: 70 |
|
Hello, I need to create a reference to a values of a study from prior bar closes. Currently it displays current value, I would like to refer to the value just before the new ones from the chart. What is the best and easy way to do do this? Thank you as always for your time. |
| [2021-12-08 15:28:40] |
| John - SC Support - Posts: 40605 |
|
We need to know where you are wanting to make this reference. Is it another study, or part of an alert or part of a custom study, etc.?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-12-10 22:40:47] |
| User558455 - Posts: 70 |
|
Pardon the vague post. So my goal is to extract the value of a study in sierra chart for example if we take a 200 day moving average on a daily chart or even say a 30 min chart. In the the case of a 30 min chart how could one get the value for the SG value of a study of a the prior bar close or 5th prior bar closed values to be used as a value that i can just have it as a line or using text study. I hope this helps, thank you! |
| [2021-12-10 22:57:53] |
| John - SC Support - Posts: 40605 |
|
There is not a single way to do what you are asking. It really depends on what the final outcome is you are looking for. For example, in order to take the value of another study and turn it into a line, you would really need to use the Spreadsheet Study. Then in cell K3 you would put the following: =ID1.SG1@$7 This will take the subgraph that is defined by ID1.SG1 (ID1 being the study ID and SG1 being the first Subgraph of that study) at the 7th cell in the Spreadsheet, which is 5 bars prior to the current bar (current bar is always at row 3 of the spreadsheet study). The $ before the 7 forces an absolute reference so you get the same value in all rows, hence a straight line. Refer to the documentation for the Spreadsheet Study here: Using the Spreadsheet Study In particular, the information on referencing a subgraph here: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study ----------- Whereas, if you want to just display the value as text, then you would use the Text Display For Studyand enter the appropriate information, in particular a value in the Subgraph Columns Back input to get the data from a bar other than the most recent (i.e. you would put in 4 to get the same bar as we referenced above in the Spreadsheet Study). Refer to the information for this study here: Text Display For Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: