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.
Connect with us on social media
- Twitter @freefincal
- Subscribe to our Youtube Videos
- Posts feed via: Feedburner
- We are also on Google Plus and Pinterest
Do check out my books
Get it now. The Kindle edition is only Rs. 199.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantMy second book is now only Rs 199 (Kindle Rs. 99) Get it or gift it to a young earner
The ultimate guide to travel by Pranav SuryaThis is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for ₹199 (instant download)
Free Apps for your Android PhoneAll calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)