Last Updated on June 19, 2019 at 12:14 pm
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.
🔥Secure your future with our Robo-advisory tool trusted by over 3,500 investors and advisors. From effortless retirement planning to funding your children’s biggest dreams, turn your financial goals into reality. 🔥
Subscribe for money management solutions via email! (Link takes you to our email sign-up form) Join 32,000+ readers in our community.
👉 New Tool Alert! NaviPlan: A Privacy-Focused Multi-asset Tracker and Goal Planner 👈
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)
4) Discounted Cash FlowOpens in a new windowOpens in a new window (DCF)
6) Graham formula and Graham number
7) Piotroski Score for the last 9 financial yearsOpens in a new window
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.