Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

Correlation Study on Nifty Stocks

1 min read

The correlation between any two stocks (or sets of variables) summarizes a relationship, whether or not there is any real-world connection between the two stocks. The correlation coefficient will always be between -1 and +1. These two extremes are considered perfect correlations. A negative coefficient means that the two stocks,, will move in opposite directions (if one stock increases, the other will decrease); a positive coefficient will mean that the two will move in the same direction (as one increases, the other will increase). And if Correlation is zero(perfectly uncorrelated) or almost zero then both the stock will behave independently

About Correlation Table

Correlation table is a two-dimensional matrix that shows correlation coefficient between pairs of securities. The cells in the table are color-coded to highlight significantly positive and negative relationships.

correlation-table
[wp_ad_camp_5]

 

(Click on the Picture for Big Table)

Here i had taken randomly some 15 stocks from the Nifty 50 Pack with the sample duration between 1st Jan 2009 – 14 Dec 2009 and the correlation table is presented above. Also Highly correlated pairs (Both Positive & Negative ) and Zero Correlated Pairs are identified from the above table
An Investopedia article explains how USD is correlated with the US Indices

If we compare the US Dollar Index (USDX), an index that tracks the value of the U.S. dollar against six other major currencies, and the value of the Dow Jones Industrial Average (DJIA), Nasdaq and S&P 500 over a 20-year period, the correlation coefficient calculated for the USDX versus the DJIA, Nasdaq and S&P 500, is 0.35, 0.39 and 0.38, respectively. Note that all of the coefficients are positive, which means that as the value of the U.S. dollar increases, so do the stock indexes, but only by a certain amount. Notice also that each coefficient is below 0.4, which means that only about 35% to 40% of the stock indexes’ movements are associated with the movement of the U.S. dollar.

List of High Positive Correlated Pairs

List of High Negative Correlated Pairs

Zero Correlation Stocks

Correlation can also be used for Portfolio Diversification. An investor can reduce portfolio risk simply by holding instruments which are not perfectly correlated. In other words, investors can reduce their exposure to individual asset risk by holding a diversified portfolio of assets.

Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

How Nifty Performed in the Last 4 Days of…

Traders often use statistical methods to identify and confirm seasonal patterns, looking at historical data to determine if there is a statistically significant trend...
Rajandran R
1 min read

Get to Know about GIFT City Nifty Futures, Timings…

GIFT Nifty is a new index derivative contract that has been launched on the NSE International Exchange (NSE IX) in GIFT City, Gujarat. It...
Rajandran R
42 sec read

What is Index Mangement and How it is Performed?

In the case of Nifty 50, when a big heavy-weight stock opens with a big gap up or gap down, index managers will buy...
Rajandran R
1 min read

10 Replies to “Correlation Study on Nifty Stocks”

  1. Usually, it is seen that stocks from the same industry are highly correlated. Maruti and Hero Honda are highly correlated at around 0.95. Another example can be say Bharti, RCOM.ss

  2. Nope Its working…. I just removed that gupshupwidget from my blog just to make it light weight

  3. Hello,
    Kindly share the code of “Correlation Study on Nifty Stocks” and guide us how to use this.
    Thank you

  4. Dear Mr. Rajandran

    That “table” is cooooool.

    I have one idea.
    Do you have any interst in “cointegration”?

    Cointegration seems to be better than correlation in some tradings.
    Could it transfer to “cointegration”?

    Thanks.

  5. Hi Rajandran ,

    Could you please guide me on how to create that table above? What data do you use to calculate it? Can I use the EXCEL corr() function to do it? What timeframe is most useful ?

    Thanks.

  6. Could you please guide me on how to create that table above? What data do you use to calculate it? Can I use the EXCEL corr() function to do it? What timeframe is most useful ?

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More