Historical Stock Price Downloader

Last month I had posted a stock price downloader from the BSE website.  Jatin Visaria pointed out that if the price is not adjusted for corporate actions bonuses, splits and dividends, the data is not useful for analysis.

Krishna Kishore pointed out that Moneycontrol lists historical prices adjusted for bonuses and splits.  I thank Krishna for this suggestion and for testing the MoneyControl downloader.

So here two historical stock price downloaders

  • From MoneyControl . Close price adjusted for bonus and stock splits, but not for dividends (according to this old link. Not sure if things have changed now )
  • From Yahoo Finance. Close price adjusted for dividends and splits, but not for bonuses! 

MoneyControl Downloader

  • Stock price data is available from Jan 1st 2000.
  • Stock prices as listed in NSE or BSE can be chosen.

Here is a screenshot

moneycontrol-1

 

To use the sheet, you will need to know the stock id as listed by moneycontol. I have compiled some stock ids in the sheet for use.

For example,

Tata Consultancy Services = TCS

Bharat Heavy Electricals = BHE

Gruh Finance = GRE

If you cannot find the stock id you need,

  • go to moneycontrol.com and choose the stock in the Stock quote entry bar

 

moneycontrol-2

If you type, 'col', you will notice a drop-down list. If you chose Colgate Pamolive, you will be directed to

http://www.moneycontrol.com/india/stockpricequote/personalcare/colgatepalmoliveindia/CPI

CPI is the stock id you will need to use the stock price downloader.

Here is the historical price chart of TCS as obtained from BSE stock price downloader

moneycontrol-3

 

Notice the two sharp drops in prices.They correspond to stock splits.

YearBonus share issueStock split ratioEffective Date
20061:12 for 1August 9, 2006
20091:12 for 1June 18, 2009

Source: tcs.com

Using the MoneyControl Downloader, you will get,

moneycontrol-4

 

Notice that the stock price has been adjusted according to the stock splits.

I am however not sure if dividends are accounted for in the stock price adjustment. Can somebody please confirm this? I have written to MoneyControl in this regard.

Yahoo Finance Downloader

In the case of yahoo finance, the bonuses do not seem to be accounted for as evident from the chart for TCS.

moneycontrol-5

 

This is the screenshot of the downloader

Excel-historical-stock-price-downloader

 

In this the case, the stock id will be automatically retrieved for you. The list is not exhaustive. If you cannot find the stock you want, let me know.

Download the MoneyControl Historical Stock price downloader

Note: Krishna tested the above sheet and found some data missing. I did not face this issue and hence do not know the reason why he faced this problem.  So I decided to go ahead and publish the sheet. If some data is missing for you too, please let me know.

Download the Yahoo Finance Historical Stock price downloader

 

 

 

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete  the entire comment or remove the links before approving them.

21 thoughts on “Historical Stock Price Downloader

  1. P.krishnan

    Please throw me by simple do yourself how to better stock picking than professional mutual fund manager

    Reply
  2. P.krishnan

    Please throw me by simple do yourself how to better stock picking than professional mutual fund manager

    Reply
  3. rohan

    Sir...downloaded data is not coming in excel ...i mean blank colums r there in excel file after finishing download....

    Reply
  4. rohan

    Sir...downloaded data is not coming in excel ...i mean blank colums r there in excel file after finishing download....

    Reply
  5. kaalaiyumkaradiyum

    Hi Pattu,
    You've asked for if the moneycontrol's stock quotes are adjusted for dividends. The answer iexcs negative. On these sites, what you see is the price traded in the exchanges. And dividends aren't taken into account. Stock splits and bonus issues affect the price directly hence need to be adjusted. In case of dividends, though the ex-dividend price drops according to the extend of dividend pay-out, these pay outs aren't adjusted.for in the quotes

    So, when you download stock quotes from sites like BSE, you need to manually adjust for stock splits and bonus issues. Even, the NSE historical data isn't adjusted for splits & bonus. By default, the exchanges want to keep the original data as they were traded. Hence, the adjustments should be done by us.

    Historical NSE indices http://www.nseindia.com/products/content/equities/indices/historical_index_data.htm

    But from moneycontrol, it is adjusted for us by them.

    Here is an article on how the market adjusts the dividend payouts by a drop in price. http://www.moneycontrol.com/news/buzzing-stocks/oracle-financial-falls-12-stock-quotes-exdividend_1187341.html

    Regards,
    BK

    P.S. Volume (number of shares traded) is also adjusted in the same ratio as Price for splits/Bonus

    Reply
  6. kaalaiyumkaradiyum

    Hi Pattu,
    You've asked for if the moneycontrol's stock quotes are adjusted for dividends. The answer iexcs negative. On these sites, what you see is the price traded in the exchanges. And dividends aren't taken into account. Stock splits and bonus issues affect the price directly hence need to be adjusted. In case of dividends, though the ex-dividend price drops according to the extend of dividend pay-out, these pay outs aren't adjusted.for in the quotes

    So, when you download stock quotes from sites like BSE, you need to manually adjust for stock splits and bonus issues. Even, the NSE historical data isn't adjusted for splits & bonus. By default, the exchanges want to keep the original data as they were traded. Hence, the adjustments should be done by us.

    Historical NSE indices http://www.nseindia.com/products/content/equities/indices/historical_index_data.htm

    But from moneycontrol, it is adjusted for us by them.

    Here is an article on how the market adjusts the dividend payouts by a drop in price. http://www.moneycontrol.com/news/buzzing-stocks/oracle-financial-falls-12-stock-quotes-exdividend_1187341.html

    Regards,
    BK

    P.S. Volume (number of shares traded) is also adjusted in the same ratio as Price for splits/Bonus

    Reply
  7. sourav samanta

    sourav samnata vck share stock & business address- ramngar batala
    pin code 712410 west bengal dist - hooghly p.s - tarakeswar
    national stock exchange bombay stock exchange sensex bse nse equttity commditty

    Reply
  8. Saumya

    Sir
    MoneyControl Historical Stock price downloader is not working. Please do something.
    Though Yahoo downloader is working fine, but the problem is Yahoo dowloader downloads values on a holiday (not weekends) as well, which appears as a "-" (dash) in the chart.

    Reply
  9. Pingback: Bombay Stock Exchange Holiday List 2015 | BuySaleStock

Do let us know what you think about the article