Home >> Support Board

Support Board

Date/Time: Thu, 13 Nov 2025 23:32:41 +0000

How to Post a Message for Support

spreadsheet values

View Count: 56

[2025-11-11 22:49:46] #1 [Go To First Post]
User411320 - Posts: 358
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 - 14 views

[2025-11-12 14:51:10] #2 [Go To First Post]
John - SC Support - Posts: 43003
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: 358
=STDEV.S(K3:K102)

[2025-11-13 17:03:08] #4 [Go To First Post]
John - SC Support - Posts: 43003
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: 358
Attached is what you asked for


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

[2025-11-13 22:22:22] #6 [Go To First Post]
John - SC Support - Posts: 43003
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

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