Support Board
Date/Time: Sun, 11 Jan 2026 20:10:40 +0000
spreadsheet help
View Count: 32
| [2026-01-09 21:58:53] |
| User411320 - Posts: 365 |
|
Hello, I'm trying to set up alerts ( triangle up/down) but I'm having the following issues. the subgraph is showing NaN and when I do and the chart is getting compressed. my formula is =IF(E3>Y4, 1, IF(E3<Z4, 0, " ")). |
 Screenshot 2026-01-09 165219.png / V - Attached On 2026-01-09 21:57:24 UTC - Size: 7.76 KB - 7 views Screenshot 2026-01-09 165408.png / V - Attached On 2026-01-09 21:57:30 UTC - Size: 2.46 KB - 4 views |
| [2026-01-09 21:59:12] |
| User411320 - Posts: 365 |
|
File attached
|
| Screenshot 2026-01-09 165843.png / V - Attached On 2026-01-09 21:59:06 UTC - Size: 14.26 KB - 5 views |
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: