Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 16 May 2024 09:00:57 +0000
Post From: Spreadsheet Study - Referencing a spreadsheet cell vs Study Name and Subgraph
| [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. |