Support Board
Date/Time: Sat, 18 Jan 2025 18:21:28 +0000
Reference Value in Spreadsheet
View Count: 1048
| [2018-02-20 18:58:04] |
| User852663 - Posts: 21 |
|
What's a quick way to reference a value from a chart, to a spreadsheet? I don't want to have to use the Spreadsheet Study if I can just reference the values I need. For example, on the spreadsheet I would pull a value for the Open price. I just can't figure out the exact syntax to reference the chart #, study id, and SG value. When I say spreadsheet I mean the built in one, not an Excel file. Date Time Of Last Edit: 2018-02-20 20:28:31
|
| [2018-02-22 02:41:11] |
| |
|
To begin with, if you are using the Spreadsheet Study, then any other studies that have been added to the chart are directly available within the spreadsheet. This information begins in column AA, assuming you have not changed the Input setting for Number of Formula Columns. As such, you can just reference the cell number if you want to make things simple (for example "=AA3 * 5" to multiply the most recent value of the first study on the chart by 5). It is also possible to reference the data directly using the ID of the study and the subgraph. To do this, follow the information here: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study If you want to be able to access information from a different chart in the spreadsheet, then follow the instructions here: Referencing Other Charts in Spreadsheet Study Formulas: Referencing Other Charts in Spreadsheet Study Formulas Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to 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: