Home >> Support Board

Support Board

Date/Time: Mon, 29 Dec 2025 15:33:54 +0000

How to Post a Message for Support

spreadsheet values

View Count: 181

[2025-11-11 22:49:46] #1 [Go To First Post]
User411320 - Posts: 359
Hello, I'm taking the STDEV.S of price changes but the values are exploding. attached is a photo


Screenshot 2025-11-11 174652.png / V - Attached On 2025-11-11 22:49:34 UTC - Size: 24.58 KB - 30 views

[2025-11-12 14:51:10] #2 [Go To First Post]
John - SC Support - Posts: 43619
What exactly is the formula in L3? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-11-13 13:51:35] #3 [Go To First Post]
User411320 - Posts: 359
=STDEV.S(K3:K102)

[2025-11-13 17:03:08] #4 [Go To First Post]
John - SC Support - Posts: 43619
Without being able to see all the data, we just do not know. Please get us that chart and the Spreadsheet itself. Follow these instructions to get us the Chart: Support Board Posting Information: Providing Chartbook with Only a Single Chart And follow these instructions to get us the spreadsheet associated with that chart. The spreadsheets have a file extension of .scss: Support Board Posting Information: Attaching a File (Optional) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-11-13 21:11:15] #5 [Go To First Post]
User411320 - Posts: 359
Attached is what you asked for


Chartbook6.Cht - Attached On 2025-11-13 21:10:48 UTC - Size: 4.18 KB - 18 views Private File

[2025-11-13 22:22:22] #6 [Go To First Post]
John - SC Support - Posts: 43619
We are not seeing any issue with the Standard Deviation calculation until you get towards the bottom of the data. In this case, the data in the K column jumps to large values since there is no further data in the B column, so you end up with the value of the E Column. If this is not what you are seeing, then what is the row at which the data starts to change? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2025-11-15 20:08:53] #7 [Go To First Post]
User411320 - Posts: 359
I'm seeing that, is that normal? and would that affect the signals I'm trying to produce?

[2025-11-18 17:58:18] #8 [Go To First Post]
John - SC Support - Posts: 43619
If what you are seeing is due to the lack of data in the source column, then this is normal. You are asking the system to take a Standard Deviation that does not include all the data. This will only affect your signals if you are looking that far back in time. If you need to go that far back, then you need to have more Rows in your spreadsheet to make sure you have enough data going back as far as you need. 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: