Dear reader, I write this to make two requests: (a) help beta test an Excel sheet that automatically downloads standalone or consolidated financials data (in new format or old) from MoneyControl, and (b) provide your feedback on how to improve the freefincal stock analysis spreadsheet.
MoneyControl Financials Downloader
The aim behind making this sheet is to integrate it with the stock analyzer and derive valuation inputs from it. However, before doing that it would be great if a few users can test the sheet with your fav. stocks and check if it is working fine.
There may be cases instances be instances where financial data (or just consolidate data) is not available at MoneyCOntrol. In such cases, not much can be done.
If the data is present at the website (a link is auto-generated to check this) but is not being downloaded, it is a red flag. If some stocks are missing, it is a red flag. I would greatly appreciate if a few of you can test the sheet this weekend.
Please send me an email: freefincal [at] gmail.com to get the download link. Thank you.
Please note: freefincal sheets are free for personal or professional use*, but no part of any sheet can be used in a commercial product.
* sheet inputs can be used for financial advise or professional portfolio management.
Stock Analysis Spreadsheet
The freefincal stock analysis spreadsheet has evolved to its 9th version. I would like the stock investing community to help me improve it in two ways
a) suggest new features
b) suggest ways in the information from the sheet can be presented in a better and easy-to-understand way.
Current features of the sheet:
The automated stock analysis sheet
- pulls financials from morningstar and analyzes them
- pulls adjusted stock price history from money control, and
- calculates intrinsic value six different ways!
It also pulls annual (standalone/consolidated) and quarterly financials from Value Research online.
Valuation models available:
1) Price Multiple Model
2) Sustainable Growth Rate
3) Book Value Growth Rate (Buffett’s approach to valuation)
8) Earnings Growth Estimate
Download : Automated Stock Analysis V9
You can also check out more stock analysis tools, including a stock screener.
Look forward to your support and feedback.
Register for the New Delhi DIY Investor meet: April 23rd 2017Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email
Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Read more about the book and pre-order now!