Support Board
Date/Time: Fri, 14 Mar 2025 07:37:01 +0000
SCSS and Excel calculating differently
View Count: 824
| [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] |
| |
|
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] |
| |
|
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: