Login Page - Create Account

Support Board


Date/Time: Fri, 14 Mar 2025 10:12:52 +0000



SCSS and Excel calculating differently

View Count: 825

[2022-05-28 19:54:56]
User773081 - Posts: 26
https://cdn.discordapp.com/attachments/830419275097047062/980195362973294633/unknown.png

Hello, I am porting over logic from SC to excel and they appear to be calculating the same values differently. I understand that sometimes log and lin are used, Im wondering if this is a glitch or if its that I need to change calculation parameters or what else I might be able to do?

PROBLEM : Excel and Sierra chart spreadsheet appear to calculate differently
QUESTION : Is there a way to fix this?

Thank you
[2022-05-28 20:45:15]
User773081 - Posts: 26
To add information, these specific operators inside use :

st.dev

Square Root

Sum
[2022-05-29 09:46:05]
Sierra Chart Engineering - Posts: 104368
There could not be any differences with Square Root or Sum. Those are done in a very standardized way and cannot be any difference.

We can provide the formula for standard deviation and then you have to make your own determination as to where the problem is.
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-05-29 09:46:26
[2022-05-29 12:20:36]
User773081 - Posts: 26
Yes thank you I'll take a look at the formula when you have a moment. I'm figuring it's just the difference in st.dev
[2022-06-02 10:07:35]
Sierra Chart Engineering - Posts: 104368
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

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

Login

Login Page - Create Account