Home >> Support Board

Support Board

Date/Time: Fri, 12 Jun 2026 16:33:46 +0000

How to Post a Message for Support

Spreadsheet

View Count: 135

[2026-04-27 22:18:03] #1 [Go To First Post]
User841161 - Posts: 327
I have a formula I’m using in a Sierra Chart Spreadsheet Study. The value in the cell keeps flipping back and forth between blank and the number returned by the formula. I have not seen this behavior before. I attached a short video clip showing what is happening, along with a screenshot of the formula I’m using. Could you please let me know what might be causing this? Thank you.


Formla 2026-04-27 .png / V - Attached On 2026-04-27 22:14:21 UTC - Size: 1.91 KB - 31 views 2026-04-27.mp4 - Attached On 2026-04-27 22:16:34 UTC - Size: 145.88 KB - 24 views

[2026-04-28 14:46:58] #2 [Go To First Post]
John - SC Support - Posts: 46661
Your formula specifically states that if $AA$3 is not equal to 'QuoteBoard-CL'!a3, then return a value of "" (nothing). So what you are seeing is the direct result of your formula. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2026-04-28 15:24:32] #3 [Go To First Post]
User841161 - Posts: 327
But $AA$3 does equal to 'QuoteBoard-CL'!a3, hence why it is giving me 'QuoteBoard-CL'!R3 which is equal to 22. It gives me 22, but flips from blank to 22 every few seconds? Shown in mp4 file I sent..

[2026-04-28 17:57:43] #4 [Go To First Post]
John - SC Support - Posts: 46661
The implication is that it is NOT equal at the times when the field goes blank. If the value in AA3 always equals 'QuoteBoard-CL'!a3, then what is the reason for the IF statement in that location? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2026-04-30 14:12:50] #5 [Go To First Post]
User841161 - Posts: 327
ok, in asking your question, made me think about my formula. I rewrote it, in simpler version, to do the same thing- =INDEX('QuoteBoard-Cl'!R2:R15, MATCH(AA3, 'QuoteBoard-Cl'!A2:A15, 0)). It still lists correct data for few seconds and then flips to #N/A- back and forth.


Private File

[2026-04-30 15:06:11] #6 [Go To First Post]
John - SC Support - Posts: 46661
There is something wrong with your formula that it is giving the #N/A sometimes. Most likely it is when the result of the MATCH is not found, which gives a result of #N/A, which will then give a problem for the INDEX() function. 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: