Support Board
Date/Time: Fri, 14 Mar 2025 13:23:08 +0000
Post From: SCSS and Excel calculating differently
| [2022-06-02 10:07:35] |
| |
|
We looked into this, and the formula that Sierra Chart uses for the spreadsheet standard deviation function is the same as what is documented here: https://support.microsoft.com/en-us/office/stdev-function-51fecaaa-231e-4bbb-9230-33650a72c9b0 There is also an example there, which lists a series of numbers and the result. You can use those same numbers with the Sierra Chart standard deviation spreadsheet function and you should get the same result. So you can verify it is the same. 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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2022-06-02 10:07:40
|