Commodity Channel Index (CCI) Trading System

By | June 2, 2012

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

1. Range Bound Market :When Index/Stock gets stuck up in a particular Range

  • Go long if the CCI turns up from below -100.

  • 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.

To Initiate trades using CCI follow the Rule

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

2. Trending Market:Looks for Divergence Both positive and negative to trade on a positional basis .

  • Go Long on Positive Divergence.

  • Go Short on Negative Divergence.

Above Chart is Self Explanatory where we can see a Negative Divergence ie. Prices are trending up but indicators are showing a downtrend .

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

Related Readings

Trading with MACD

Trading with RSI

Trading with Pivots

A/D Ratio

33 thoughts on “Commodity Channel Index (CCI) Trading System

  1. Willem Duyvesteyn

    Very interesting and compelling piece! Please send me your Excel spread sheet. Thanks WD

  2. rohit

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

  3. K.S.N.RAO

    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

  4. Muhammad

    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.

  5. vasudevan

    Dear Sir

    Please send the Excel Sheet to calculate CCI. commodities trading

  6. anand

    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

  7. Matt

    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

  8. Richard

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

    Regards

  9. dashrath

    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

  10. Manish

    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

  11. TekkieSuresh

    Dear Mr.Ramesh,

    Your article was good.I

  12. Pranesh

    Hi,

    please send me too the excel sheet.

    Thanks

  13. R.S.Ananda

    can you kindly send me the excel sheet of cci calculation

  14. pranesh

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

  15. harish

    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.

  16. ravinder

    pls send me the excel sheet for cci calculation

  17. Jyothsna

    Please send me the excel sheet too. Thanks in advance.

  18. kshitiz

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

  19. Rahul chajjed

    Dear sir,

    Kindly send me the excel sheet. Thanks

  20. ramanna bengaluru

    I particularly liked this article on Commodity Channel Index.
    Will the “constant” be 0.015 for CCIs of 5-period, 14-period etc. also ?
    Kindly mail me your Excel file on CCI calculation.
    thanking you in advance.

  21. Bramesh Post author

    Yes Sir CCI can be used for commodities also.

    Rgds,
    Bramesh

  22. praneet

    hello ,

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

  23. Rahul

    Sir,

    Please send the Excel Sheet to calculate CCI.

  24. karrgk

    Hello,

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

Leave a Reply