Home >> Support Board

Support Board

Date/Time: Thu, 26 Feb 2026 08:03:43 +0000

How to Post a Message for Support

spreadsheet help

View Count: 115

[2026-01-09 21:58:53] #1 [Go To First Post]
User411320 - Posts: 369
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 - 31 views Screenshot 2026-01-09 165408.png / V - Attached On 2026-01-09 21:57:30 UTC - Size: 2.46 KB - 28 views

[2026-01-09 21:59:12] #2 [Go To First Post]
User411320 - Posts: 369
File attached


Screenshot 2026-01-09 165843.png / V - Attached On 2026-01-09 21:59:06 UTC - Size: 14.26 KB - 31 views

[2026-01-09 23:04:11] #3 [Go To First Post]
John - SC Support - Posts: 44806
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

[2026-01-11 21:05:56] #4 [Go To First Post]
User411320 - Posts: 369
I'm trying to get buy and sell signals. so if the close is greater than the value of Y column , triangle up. If the close is less than value of z, triangle down. If neither condition is met, no signal

[2026-01-12 13:44:02] #5 [Go To First Post]
Sawtooth - Posts: 4313
Try this: Use two Formula Columns, one for each direction. Triangle Up formula: =IF(E3>Y4, C3, 0) Then set the Draw Style to Triangle Up. This will place the triangle at the bar High. Triangle Down formula: =IF(E3<Z4, D3, 0) Then set the Draw Style to Triangle Down. This will place the triangle at the bar Low.

[2026-01-12 17:34:35] #6 [Go To First Post]
User411320 - Posts: 369
that worked thank you

To post a message in this thread, you need to log in with your Sierra Chart account: