Rajandran R FollowTelecom 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 and Co-Creator of Algomojo (Algorithmic Trading Platform for DIY Traders)

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.

[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 FollowTelecom 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 and Co-Creator of Algomojo (Algorithmic Trading Platform for DIY Traders)

Youtube Thumbnail Indicator is a modern-day contrary indicator and alternative to magazine cover indicator as the masses are shifting the consumption of content in...

Last Thursday Elon Musk (Tesla CEO) urged his Twitter followers to use Signal App instead of Whatsapp over privacy issues. Elon Musk tweeted after...

10 Replies to “Correlation Study on Nifty Stocks”

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

Are you facing any problem with your sms service for new subscription

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

@SS… Yeah Most of the sectoral stocks are highly correlated

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

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.

CoIntergration – The term is very new for me i think its time to digg more about it

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.

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 ?

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

Are you facing any problem with your sms service for new subscription

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

@SS… Yeah Most of the sectoral stocks are highly correlated

Hello,

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

Thank you

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.

CoIntergration – The term is very new for me i think its time to digg more about it

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.

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 for sharing.