Support Board
Date/Time: Sun, 11 Jan 2026 20:10:41 +0000
Post From: spreadsheet help
| [2026-01-09 23:04:11] |
| John - SC Support - Posts: 43903 |
|
A space is not a valid number. Your formula does not make any sense, as you are doing an initial test, but in your second test you are giving a value of "0" if true, but then nothing if not true. Sierra Chart (and most programs) use a value of 1 (or non-zero) for True and a value of 0 for False. We are not certain what exactly you are wanting to do with the formula you are using. Also, if you want a triangle at a specific level, then you need to return the level at which you want the triangle. A zero value means do not display. Since you are in a spreadsheet, you can reference the Open/High/Low/Close of a candle for the result. For instance, you can have the following: =IF(E3>Y4, ID0.SG2@3, IF(E3<Z4, ID0.SG3@3, 0)) Where ID0.SG2 is the High of the bar and ID0.SG3 is the Low of the bar. The @3 signifies to return the value at row 3 of the spreadsheet. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |