1995issue C011-2
Building the commodity channel index from typical price
Rebuild the commodity channel index as successive series: a typical price from high, low, and close, a simple moving average over a chosen lookback, and a mean-deviation denominator scaled by 0.015.
- The first series is a typical price formed by adding the period high, low, and close and dividing by 3.
- A simple moving average of those typical prices uses any lookback the user selects; an 11-period window is one illustration.
- Mean deviation averages the absolute differences between the current moving average and each typical price inside that same window.
- The index is a ratio: latest typical price minus latest moving average, divided by mean deviation multiplied by 0.015.
Assembling the index in order
Editorial framing: this note treats the commodity channel index as a classroom assembly problem. Rebuild the typical price series, the lookback average, and the scaled mean-deviation denominator so the constant 0.015 is a visible design choice rather than a black-box setting. That framing is a TradersWeek interpretation of the construction, not a statement from the archive workflow.
The archive workflow builds the commodity channel index as a ratio from those intermediate series. The lookback period may be any length the user selects, and the same window is used for both the moving average and the mean deviation.
Typical price as the first series
The first constructed series is a typical price. A typical price is a single period value formed by averaging that period's high, low, and close. In this workflow the average is formed by adding the period high, low, and close and dividing by 3.
A lookback average of typical prices
The next series is a simple moving average of those typical prices over the chosen lookback. The simple moving average is the unweighted average of typical prices inside that window. The archive workflow illustrates the step with an 11-period window.
Mean deviation in the same window
Mean deviation is taken over the same lookback period as the moving average. It averages the absolute differences between the current moving average and each of the typical prices inside that window.
The finished ratio
The commodity channel index is a ratio that compares how far the latest typical price sits from its lookback average, scaled by mean deviation. The numerator is the latest typical price minus the latest moving average. The denominator is the current mean deviation multiplied by the constant 0.015. That constant is the scaling factor applied to mean deviation.
Spreadsheet columns for each series
Each intermediate series can be stored in successive spreadsheet columns so the finished ratio is recomputed from those cells. The typical price, the simple moving average, and the mean deviation stay available as inputs to the ratio.
11-period CCI on the Dow Jones Industrial Average

Lookback is 11 sessions. CCI uses (typical price minus the 11-day SMA) divided by 0.015 times the 11-day mean deviation. Columns F–H start on the 11th row because the window is not yet full.
All readings on this track · 39 readings
- 1982Three gates on a 1982 pork-belly short
- 1982Scale-free Commodity Channel Index construction
- 1986Constructing a commodity channel index and a regression price channel
- 1987Constructing scaled OHLC matrices for study overlays
- 1987Constructing the commodity channel, average directional, and relative strength indexes on a shared cycle scale
- 1992Eleven-bar commodity channel index from typical price and mean deviation
- 1992Evaluating Commodity Channel Index breakout versus range rules
- 1992Evaluating breakout and CCI rules as complete mechanical procedures
- 1993Constructing stochastic, RSI and CCI inputs for forecasts
- 1993Nested centered channels with a commodity channel index confirmation gate
- 1993Listed-option timing as three separable clocks
- 1994Constructing an eleven-period commodity channel index
- 1994Confirming Elliott wave turns with channels and the commodity channel index
- 1995Commodity Channel Index band rules lag zero-line timing
- 1995Building the commodity channel index from typical price
- 1995Staged reversal rules with commodity channel index and average channels
- 1995Commodity channel index construction from typical price to a smoothed zero line
- 2001Reader tests for unfinished lookback oscillators
- 2002Constructing the commodity channel index from typical price
- 2003Breadth-filtered commodity channel index entry and exit rules
- 2003Constructing the Commodity Channel Index from typical price and scaled deviation
- 2003A shallow, poorly participated advance is an unconfirmed trend
- 2003CCI and RSI parameter defaults as scaling conventions
- 2003A cost and capital audit of a Commodity Channel Index trade engine
- 2003Commodity channel index peak divergence as an exit after twin patterns
- 2004Constructing the Commodity Channel Index from typical price
- 2004Constructing the Commodity Channel Index from typical price and mean deviation
- 2006Building custom indicators from the Commodity Channel Index, a least squares moving average and a rule-based entry
- 2012Confirming breakouts and retracements with CCI, ADX, and averages
- 2012Stacking oscillator lookbacks into a heatmap mosaic
- 2013Constructing a consensus and volatility-normalized value oscillator
- 2013Walk-forward system evaluation with a commodity channel index and chandelier exits
- 2014Dual detrended oscillators and dual Bollinger Band channels
- 2014RSI, CCI, and moving-average trend-filter construction
- 2014Dual RSI, a moving average, and CCI as a confirmation stack
- 2017Constructing dual-average cross and channel-index filters
- 2018Treat CAM as a classification layer before confirmation becomes an entry
- 2018Four-state slope labels gated by a moving average and a commodity channel index
- 2018Deviation-Scaled Moving Average construction from a two-bar difference