#### Home >> (Table of Contents) Studies and Indicators >> Technical Studies Reference >> Commodity Channel Index

# Technical Studies Reference

- Technical Studies Reference
- Common Study Inputs (Opens a new page)
- Using Studies (Opens a new page)

### Commodity Channel Index

The Commodity Channel Index (CCI) measures the variation of a symbols price from its statistical mean. High values show that prices are unusually high compared to average prices, whereas low values indicate that prices are unusually low. It can be used with any type of symbol, not just commodities.

Let \(X\) be a random variable denoting the **Input Data**, and let \(X_i\) be the value of the **Input Data** at Index \(i\). Let the Inputs **Length** and **Multiplier** be denoted as \(n\) and \(v\), respectively. Then we denote the **Commodity Channel Index** at Index \(t\) for the given Inputs as \(CCI_t(X,n,v)\), and we compute it for \(t \geq n\) in terms of Simple Moving Averages as follows.

**Note**: Depending on the setting of the Input **Moving Average Type**, the Simple Moving Averages in the above formula could be replaced with Exponential Moving Averages, Linear Regression Moving Averages, Weighted Moving Averages, Wilders Moving Averages, Simple Moving Averages - Skip Zeros, or Smoothed Moving Averages. The types of all three Moving Averages in the calculation are determined by this one Input.

This study also displays horizontal lines whose levels are determined by the **Line2 Value** and **Line3 Value** Inputs.

#### Inputs

#### Spreadsheet

The spreadsheet below contains the formulas for this study in Spreadsheet format. Save this Spreadsheet to the Data Files Folder.

Open it through **File >> Open Spreadsheet**.

*Last modified Friday, 02nd February, 2018.