This is a bug workaround update for the automated stock price analyzer.
Update: The Aug 11th 2016 version is:
The Jun 30th 2016 version is
The automated stock analyzer
- pulls annual (standalone/consolidated) and quarterly financials from Value Research online
- pulls financials from morningstar and analyzes them,adjusted
- pulls adjusted stock price history from money control, and
- calculates intrinsic value five different ways!
Many users have complained that the Moneycontrol stock price download page either pulls the wrong price history or draws a blank.
The source of the problem is Moneycontrol. For many stocks, the id they use for financials differs from the one used for price history. Unfortunately, I could tabulate stock ids for financials only.
I have now provided a set of instructions by which the user can check the stock id before downloading the data.
The user will have to enter the desired stock name here
generate some random price history, copy the url and paste it in the sheet (detailed instructions in the sheet) to check the stock id.
This will ensure the right stock price is downloaded. Let me know if there is some way to automate this workaround.
Here is a screenshot
Update: Automated Return on Equity Analysis with the Dupont Formula (version 10, 27th Apr 2016)
Subscribe to get posts via email
|You Can Be Rich Too With Goal-based Investing A book that can help you ask the right questions about money and find simple solutions. Comes with nine online calculator modules. Read more about the book and order now!|
GameChanger - Forget Startups, Join Corporate & Still Live The Rich Live You want Take that international trip at 50% lower costs! Optimise credit card usage! Set money management on auto-pilot! Read more about the book and order now!