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)
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)