Dear all, I have an academic interest in stock analysis and valuation. I have made an excel sheet based analyzer which pulls financials from morning star, value research and price history from money control and has 5 valuation methods.
I was pleasantly surprised to see someone refer to it, in this forum. Mine being a mf-centric blog, the sheet has not been evaluated by a community of stock investors interested in analysis and valuation
If It does not break any rule of this forum, I would appreciate if members can provide feedback on the analyzer. How can I make it better, what can be added etc.
NB: I do not invest in direct equity and hence would require ELI5 like simple explanations.
Also I do not intend to profit in any way from this sheet or your comments except to learn from them.
The latest version of the analyzer can be found [here]
@pattu Thank you for sharing your sheet its wonderful. your skill with excel is commendable and it would be great if you could briefly explain how to automatically get the data downloaded from these sites as it happens in your sheet.
Thank you. Data downloading from Excel is trivial. You only need the url to based on a formula. That is a code for each stock and rest of the url elements should be constant. In such a case, all you need is a database of stock codes
Sometimes you can get it from the sitemap and sometimes you will have to use a link extractor on a listing of stocks, get the urls, extract the code from the urls with word of excel (simpler than I make it sound) and then tabulate them and use it like I did.
If you need help downloading stuff, let me know and I could help if possible,
Thank you pattu for the swift reply. It is something that i have been wanting to learn. My lack of knowledge on the subject is not helping me to understand how to go about it. do you know any links to a video or an article which would explain it in a more detailed fashion. Thanks in advance
I have downloaded your sheet. Thanks a lot for this. I was trying to make some modifications but unable to grasp you excel code. It would be helpful if you have some video sessions showing how you pulled the data from webpages.