Support Board
Date/Time: Sat, 12 Jul 2025 00:24:32 +0000
Spreadsheet Cell Showing #Name? Instead of Formula Result
View Count: 216
| [2025-05-23 11:45:59] |
| User546613 - Posts: 10 |
|
Hello Sierra Chart Support, I'm using the Spreadsheet System for Trading study and have entered a formula in cell CB3 to detect a specific candle pattern. However, instead of showing TRUE or FALSE, the cell just displays #Name?. The formula I'm using is: =AND(ID1.SG1@4 > ID1.SG4@4, ID1.SG4@4 = ID1.SG1@3, ID1.SG4@3 > ID1.SG1@3 + AB1 * 3) Study ID ID1 is my main price graph (e.g., candlestick bars) Cell AB1 contains the Tick Size (e.g., 0.25) Auto-trading is not active yet – this is just for logic checking I’m using Service Package 12 What could be causing the #Name? error in this context? Thank you in advance for your help! Best regards, Markus Hirsbrunner |
| [2025-05-23 13:59:02] |
| John - SC Support - Posts: 40857 |
|
The Main Price Graph is not ID1, it is ID0. So you are referencing a study that does not exist, or perhaps the Spreadsheet Study itself. In the end, one of those subgraphs does not exist which is why you are getting that error. If you want to reference the Main Price Graph, you need to use ID0, so the Open would be ID0.SG1 and the Close would be ID0.SG4. 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: