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!
- Stock price data is available from Jan 1st 2000.
- Stock prices as listed in NSE or BSE can be chosen.
Here is a screenshot
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.
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
If you type, 'col', you will notice a drop-down list. If you chose Colgate Pamolive, you will be directed to
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
Notice the two sharp drops in prices.They correspond to stock splits.
|Year||Bonus share issue||Stock split ratio||Effective Date|
|2006||1:1||2 for 1||August 9, 2006|
|2009||1:1||2 for 1||June 18, 2009|
Using the MoneyControl Downloader, you will get,
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.
This is the screenshot of the 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.
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.
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!