Support Board
Date/Time: Thu, 13 Feb 2025 22:51:51 +0000
Skew, kurtosis statistical functions in spreadsheet
View Count: 1342
| [2019-01-25 18:52:03] |
| Chad - Posts: 234 |
|
I'm looking for functions to calculate the skew and kurtosis of a range of values in a spreadsheet study. From review of the 'Available Functions' section on SC's Spreadsheet Functions page, I do not see either, but they are available in Excel, as shown in the page which your reference links to: https://support.office.com/en-US/article/skew-function-bdf49d86-b1ef-4804-a046-28eaea69c9fa https://support.office.com/en-US/article/kurt-function-bc3a265c-5da4-4dcb-b7fd-c237789095ab What would be the most expedient way to gain access to such calculations, as it stands now with a SC spreadsheet? |
| [2019-01-28 17:27:49] |
| Chad - Posts: 234 |
|
bump (?)
|
| [2019-01-28 22:00:53] |
| |
|
The only thing we can say is there is a kurtosis study that Sierra Chart has: Kurtosis Which can be based on other studies. Although it is going to be changed in the next release because the prior math it was using was not correct. So you will want to wait before using it. 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: 2019-01-28 22:02:27
|
| [2019-01-28 22:07:39] |
| Chad - Posts: 234 |
|
SCE, Thank you. So regarding skew (and kurtosis until the next release), is it appropriate to deploy a calculation within ASCIL instead? |
| [2019-01-29 16:14:34] |
| John - SC Support - Posts: 37947 |
|
Yes. Absolutely. This is why ACSIL exists, to allow users to create studies to perform functions that may not exist inherently within Sierra Chart. You will find the start of the documentation for ACSIL here: Advanced Custom Study Interface and Language (ACSIL) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-01-02 12:45:16] |
| Matt NL - Posts: 91 |
|
Hi Chad, did you ever manage to get Skewness in a study? I would really appreciate know the ACSIL code if you could share? Thanks Matt |
To post a message in this thread, you need to log in with your Sierra Chart account: