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