Login Page - Create Account

Support Board


Date/Time: Thu, 26 Jun 2025 03:29:49 +0000



Post From: Study to refer to the value

[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