CCl

CCI (Commodity Channel Index) is a timing tool that works best with seasonal or cyclical contracts. It keeps trades neutral in a sideways moving market, and helps get in the market whena breakout occurs.

CCI is calculated by first determining the difference between the mean price of a commodity and the average of the means over the time period chosen. This difference is then compared to the average difference over the time period (this factors in the commodity's own inherent volatility). The result is then multiplied by a constant that is designed to adjust the CCI so that it fits into a "normal" tradingrange of +/-100.

Syntax:

CCI
CCI()
CCI(“Method”)
CCI(“Period”, ”Method”)
CCI(“OutPutStartCell”, ”Period”, ”Method”)

Inputs:

'High', 'Low', and 'Close' columns values

Parameters:

• Period (default=14)
• Method (default=MvAvg)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

CCI
CCI()
CCI(“MvAvg”)
CCI(MvAvg)
CCI(“LinWgtMvAvg”)
CCI(LinWgtMvAvg)
CCI(“ExpMvAvg”)
CCI(ExpMvAvg)
CCI(“14”,“MvAvg”)
CCI(14,MvAvg)
CCI(“14”, “LinWgtMvAvg”)
CCI(14,LinWgtMvAvg)
CCI(“14”,“ExpMvAvg”)
CCI(14,ExpMvAvg)
CCI(“G2”, “14”,“MvAvg”)
CCI(G2,14,MvAvg)
CCI(“G2”, “14”, “LinWgtMvAvg”)
CCI(G2,14,LinWgtMvAvg)
CCI(“G2”, “14”,“ExpMvAvg”)
CCI(G2,14,ExpMvAvg)