Support Board
Date/Time: Sat, 12 Jul 2025 03:54:08 +0000
Post From: Spreadsheet Cell Showing #Name? Instead of Formula Result
| [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 |