Support Board
Date/Time: Thu, 22 Jan 2026 22:04:07 +0000
alert spreadsheet #SYNTAX! error
View Count: 16
| [2026-01-22 18:34:23] |
| rondawes - Posts: 41 |
|
I'm trying to use this as a Buy alert in K3 of an alert spreadsheet and getting the syntax error. All the IDx:SGx$3 references reference valid values that update every bar. Thanks =AND(ID9:SG9$3 < -250, ID1:SG4$3 > 1, ID4:SG4$3 > 1, ID5:SG4$3 > 1, ID6:SG4$3 > 1, ID2:SG4$3 > 1) |
| [2026-01-22 19:17:07] |
| John - SC Support - Posts: 44161 |
|
You need to use an @ sign not a $ sign. Such as ID9.SG9@3. Refer to the following: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study If you want an absolute reference to specific data, then you would need to use both, such as: ID9.SG9@$3 For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-01-22 19:57:35] |
| rondawes - Posts: 41 |
|
I was using a colon instead of a period between the ID and SG. Woops.... Thanks.
|
To post a message in this thread, you need to log in with your Sierra Chart account: