Support Board
Date/Time: Mon, 25 Nov 2024 04:34:23 +0000
Spreadsheet Study - Referencing a spreadsheet cell vs Study Name and Subgraph
View Count: 283
| [2024-04-02 15:44:33] |
| User337568 - Posts: 60 |
|
Using Spreadsheet Study Goal Replacing cell references with Study references. This formula works: =IF(E3>AD3,1,IF(E3<AE3,-1,0)) This generates a #Name Error. =IF(ID0.SG4>ID3.SG4,1,IF(ID0.SG4<ID3.SG5,-1,0)) Troubleshooting: ID0.SG4 - Close - good ID3.SG4 - Study in chart & valid Id3.SG5 - Study in Chart and Valid I asked CoPilot to check, and it said the Sierra Chart Syntax is okay and go check if the references are valid and in the chart. However, cell references work, while study references do not. |
| [2024-04-02 18:42:11] |
| ForgivingComputers.com - Posts: 960 |
|
You are missing the reference to row 3: =IF(ID0.SG4@3>ID3.SG4@3,1,IF(ID0.SG4@3<ID3.SG5@3,-1,0))
|
| [2024-04-02 19:39:11] |
| Sierra_Chart Engineering - Posts: 17169 |
|
For the proper format for this, 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: