Support Board
Date/Time: Tue, 22 Sep 2026 12:36:54 +0000
Spreadsheet Study- Use of Subgraphs cells
View Count: 248
| [2026-08-07 22:19:56] |
| User841161 - Posts: 348 |
|
Can a spreadsheet formulas use something conceptually like: =ID3.SG2 + ID7.SG1 instead of relying on columns such as AD3 and AP3? I am trying to use something in spreadsheet formulas that will change when subgraph columns get added and subtracted inside of Sierra Chart Spreadsheet.. |
| [2026-08-09 18:05:37] |
| ForgivingComputers.com - Posts: 1238 |
|
You need to add the row of the spreadsheet with the @ symbol and the row, like this. =ID3.SG2@3 + ID7.SG1@3
If you put this in a cell, it will propagate down and increment the row number automatically. |
| [2026-08-14 07:26:25] |
| Sierra_Chart Engineering - Posts: 24929 |
|
Refer to: 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, 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: