Home >> Support Board

Support Board

Date/Time: Thu, 12 Jun 2025 08:14:20 +0000

How to Post a Message for Support

Error when working with Standard Deviation in Spreadsheet

View Count: 615

[2022-11-07 11:23:03] #1 [Go To First Post]
User718690 - Posts: 18
Hello, I am trying to learn and work with the spreadsheet. When I use the standard deviation function I get the same result for every row no matter what parameters I enter. Please review the attached files. I would greatly appreciate some help on this case.


SC1.JPG / V - Attached On 2022-11-07 11:21:29 UTC - Size: 101.02 KB - 133 views SC2.JPG / V - Attached On 2022-11-07 11:21:36 UTC - Size: 51.59 KB - 113 views SC3.JPG / V - Attached On 2022-11-07 11:22:33 UTC - Size: 136.22 KB - 112 views

[2022-11-07 16:05:58] #2 [Go To First Post]
Sierra_Chart Engineering - Posts: 19895
The formula does not look correct to us. Use a range reference to all of the values you want to calculate the standard deviation for: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#STDEVS_Function Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation 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: