# Commodity Channel Index (CCI) Trading System

The Commodity Channel Index (CCI) is an oscillator originally developed by Donald Lambert, The assumption behind the indicator is that commodities (or stocks or bonds) move in cycles, with highs and lows coming at periodic intervals. The indicator is similar in concept to Bollinger Bands

## CCI Calculation

There are 4 steps involved in the calculation of the CCI:

1. Calculate the last period’s Typical Price (TP) = (H+L+C)/3 where H = high, L = low, and C = close.
2. Calculate the 20-period Simple Moving Average of the Typical Price (SMATP).
3. Calculate the Mean Deviation. First, calculate the absolute value of the difference between the last period’s SMATP and the typical price for each of the past 20 periods. Add all of these absolute values together and divide by 20 to find the Mean Deviation.
4. The final step is to apply the Typical Price (TP), the Simple Moving Average of the Typical Price (SMATP), the Mean Deviation and a Constant (.015) to the following formula:

## How to trade with CCI

• ### Go short if the CCI turns down from above 100.

Example:

As seen from RELIANCE chart when combined with CCI.We get a prior indication from CCI when the Stock is bottoming out and when it is topping Out. As i have marked in the Chart when CCI turns down and touches -180 Stock make a low in coming few trading seesions,So CCI can be used to see stock is going to make low and capture the opportunity to initiate longs.

Similarly on Upside after CCI make a high of 200 Reliance hit the top and started its downward journey.

So we can use CCI for getting an idea when the stock is going to Top and Bottom.

Go long if the CCI turns up from below -100 Now again refer to the above chart CCI turned up from -100 when Reliance was trading near 975 and within 2 trading sessions we got 100 points move on reliance. So we can use to initiatetrades when CCI is turning up from -100

### An Chart explanation with a Positive Divergence on Nifty when CCI is applied.

But nothing should betakes for granted as a Trader we cannot rely on any one indicator and it is extremely important to Use CCI in conjunction with other indicators,Moving Averages,Support and Resistance levels so that we are not carried away by a Whip saw.

## Conclusion

The Commodity Channel Index/CCI indicator is an extremely useful tool for traders to determine cyclical buying and selling points. Traders can utilize this tool most effectively by (a) calculating an exact time interval and (b) using it in conjunction with several other forms of technical.

If any of the Reader wants the Excel Sheet to calculate CCI Please write your mail in comments I will send the same

A/D Ratio

### 34 thoughts on “Commodity Channel Index (CCI) Trading System”

3. Kindly send me excel sheet for CCI calculation FOR NIFTY STOCKS.

4. Respected Sir,
Good Evening I just gone through your post on cci published in the year 2012 as u said in the ending of the post please send the link of excel to calculate cci

Regards,
Rao
04/03/2016

NOTE: If any of the Reader wants the Excel Sheet to calculate CCI Please write your mail in comments I will send the same

5. Hello Bramesh how are you.. By the way I’m Muhammad. I seen your Explanation About the CCI Indicator. Really it’s a Perfect Explanation nobody can do like this before. Thank you so much for wonderful And very Useful Message. Kindly send me the Excel Sheet For Commodities Market. And Give the Explanation Too. Thanks once again and waiting for your Valuable Reply.

6. Great article please send me excel

7. Please send xls to calculate CCI

8. Dear Sir

9. pls send me

10. Great page.

11. Hi Bramesh,

Your articles are very good , I have become a regular reader of your analysis and blogs.

Could you please send me the excel file calculation for CCI-commodity channel index

Many Thanks
anand

12. Dear Mr. Ramesh,

interesting article, please could you send me the sheet the calculate the cci.

I am looking for a formula where I can quick change the time period e.g. 20 to 14 etc.

regards

13. Very interesting article. Could you kindly send me the Excel sheet to calculate the CCI?

Regards

14. Thanks for the article. I am new to trading. i would like to have such good tools. Please send me an excel sheet.
Can u please suggest some free software for charting nifty.

the information you r giving is very usefull.

Regards

15. Hi

Thanks for a very nice article. I regularly read your articles. I am looking RSI/ADX with CCI to confirm a trend line. Which trend line is the most effective one apart from CCI. I am new into technical and trying to learn.

Keep up the good work and posting the such articles.

Regards

16. Dear Mr.Ramesh,

17. Hi,

please send me too the excel sheet.

Thanks

18. can you kindly send me the excel sheet of cci calculation

19. Please send me the excel sheet.

20. Sir please sent me the same.

21. sir,
It is intresting and educative,please mail cci excel sheet and oblige
pranesh

22. resp. sir,
send me cci excel calculate sheet in excel.
during the divergence, how to calculate the divergence when it starts run either +ve or -ve side? if possible plz. give your valuable advice.
thank for your very very useful tech. analysis & teaching.

23. Kindly send me excel sheet for CCI calculation.

Thanks and regards

CM Gupta

24. pls send me the excel sheet for cci calculation

26. Nice topic, I do want this excel sheet,pls send me a copy.

27. Dear sir,

Kindly send me the excel sheet. Thanks

28. Please send me the. CC index sheet

Will the “constant” be 0.015 for CCIs of 5-period, 14-period etc. also ?
Kindly mail me your Excel file on CCI calculation.

30. Yes Sir CCI can be used for commodities also.

Rgds,
Bramesh

31. hello ,

can we use c.c.i for strategic cyclical buying and selling points for commodities like gold silver and base metal and crude.

32. Sir,

Please send the Excel Sheet to calculate CCI.

33. Hello,

Is it possible to set this in amibroker as afl. Or is there any other work around for amibroker…..

34. pls snd me exl sheet for cci calculation.