Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 04:17:52 +0000



CCI / Commodity Channel Index formula for spreadsheets.

View Count: 1165

[2020-02-07 05:27:17]
GoldSquirrel - Posts: 18
I found this page referencing an .scss spreadsheet file containing the CCI formulas used with Sierra Charts.

Commodity Channel Index

I downloaded the file and opened per the instructions. The file appears to only contain static list of data with no formulas in the columns 3rd row. Am I missing something here? I would like to see the formulas in spreadsheet format.
[2020-02-07 18:38:41]
Sierra_Chart Engineering - Posts: 14076
We will check on this.
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
[2020-02-07 18:38:42]
Sierra_Chart Engineering - Posts: 14076
We will check on this.
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
[2020-02-07 18:51:24]
SC Support Tom - Posts: 450
The spreadsheet contains 3 sheets:

1) Data - This is indeed a static list of data.
2) Test - This is where Sierra Chart's calculations are compared with the spreadsheet calculations.
3) Intermediate Calculations - This is where the formulas are.
[2020-02-08 15:16:52]
GoldSquirrel - Posts: 18
Thank you for clarifying. I didn't realize there were more sheets in the file and was thinking that all the calculations needed to be on sheet 1. This information has been really helpful.

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

Login

Login Page - Create Account