Support Board
Date/Time: Sat, 18 Jan 2025 23:15:49 +0000
Post From: Reference Value in Spreadsheet
| [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 |