DEUSHARVEST
Commodity Channel Index (CCI)
The Commodity Channel Index (CCI) measures the current price level relative to an average price level over a given period of time. CCI is relatively high when prices are far above their average, and relatively low when prices are far below their average. It is commonly used to identify overbought and oversold conditions and potential trend reversals.
CCI
=CCI(data, period) Example Usage
=CCI(A2:F500, 20)
Parameters
| Parameter | Type | Description | Status |
|---|---|---|---|
data | Range | The input range of columns containing the Date, Open, High, Low, Close, and Volume data. CCI uses High, Low, and Close to calculate the Typical Price. | Required |
period | Number | The lookback period. Default is 20. | Optional |
Returns
A two-column array of dates and their corresponding CCI values.
