Support Board
Date/Time: Thu, 23 Jan 2025 03:34:46 +0000
Spreadsheet Formula enquiry
View Count: 667
| [2018-10-28 23:42:48] |
| nus1 - Posts: 39 |
|
Hi, How to represent value in a formula from a study? Ex: ID:7 is a study overlay that extracts specifically the close price value and I need that value in a following formula "=(ID:7 * 0.000001)*C" I referred to Spreadsheet Example Formulas and Usage but no success Thank you |
| [2018-10-29 21:30:39] |
| ForgivingComputers.com - Posts: 990 |
|
You need the subgraph and which row you want to read from: =(ID7.SG1@3 * 0.000001)*C3 |
| [2018-10-29 22:21:00] |
| |
|
This is explained here: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 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: