Light Mode

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Latest commit

History

History
10 lines (7 loc) * 539 Bytes

CommodityChannelIndex.md

File metadata and controls

10 lines (7 loc) * 539 Bytes

Commodity Channel Index (CCI)

The Commodity Channel Index (CCI) is a versatile indicator that can be used to identify a new trend or warn of extreme conditions. It is primarily used to identify cyclical trends in commodities, but it can also be used in stocks. The CCI is calculated using the following formula:

CCI = (Typical Price - 20-period SMA of TP) / (0.015 x Mean Deviation)

How to calculate Commodity Channel Index (CCI) in excel spreadsheet?

Download excel sample