I'm amazed to see how this video saved so much of my time and how easily it provides the data.. thanks to the creator for their efforts & for this video..
Glad you liked it. I would highly recommend you to watch this video as well - th-cam.com/video/FJS--M6sV30/w-d-xo.html. This will help you fetch data in similar template for any company into one excel and will update as new data comes. Also you will not be required to download multiple excel files for multiple companies.
how do we get such market data and fundamental analysis data of all the companies under my portfolio (xls), so as it can be updated by refresh/automatically, and thereby become available as "consolidated info" in my xls. Please comment/guide me in achieving this. thank you
Excellent , need more such useful videos , will need excel which will give profitability trend of selected sector companies to help investment decision . Thanks for all the efforts u put in .Shailesh Saraf also does excellent analysis but we do not get the excel file , pl check bro if you pull something helpful out of it.
brother...how to make excel for my stocks portfolio to check yearly and quarterly improvement in fundamentas which i hold ....like top line and bottom line improving or not
hey, I'm doing it...but the exported excel sheet is empty...tried on 2-3 companies...all empty files are being downloaded. where am I going wrong? pls, help.... need the analysis data urgently
It is indeed a great method to analyse companies or stocks. But they don't allow to download the excel template v5.0 . I think it's for paid subscription.
![How to Read Annual Report of any Company [+Worksheet] | Learn & Understand Annual Report Analysis](http://i.ytimg.com/vi/V28LpTApAww/mqdefault.jpg)
![How to Read Annual Report of any Company [+Worksheet] | Learn & Understand Annual Report Analysis](/img/tr.png)
After seeing many other useless videos, found it very useful. Thanks
Glad you liked it 😃 Please like and share to support and subscribe the channel for more such content on excel and finance 🙏
I'm amazed to see how this video saved so much of my time and how easily it provides the data.. thanks to the creator for their efforts & for this video..
Glad you liked the efforts 😃 Please like and share to support and subscribe the channel for more such content on excel and finance 🙏
this was crazy u just helped me save atleast a months time of setting up this excel template alone.... this just made it a cake walk..
Glad you liked it. I would highly recommend you to watch this video as well - th-cam.com/video/FJS--M6sV30/w-d-xo.html. This will help you fetch data in similar template for any company into one excel and will update as new data comes. Also you will not be required to download multiple excel files for multiple companies.
Ohhhhh myyyyy goooodddd YOu are a lifesaver. God you are the best Thank you so much for this video.
Hi bro...
last two days i was look for this type of data analysis sheet, thanks your video help me a lot, hope you'll reach great heights in Ur life.
You are the best bosss
Great Job sir, How to download NSE & BSE IPO Historical data with stock code, Listing price, OHLC, Listing Date. Thank you
Thank you :) I have made it shall upload soon 👍
it's not working for tata motors financial statement, mostly all cells have no
value
greate
Very nice
Is it possible to download the stocks under 500rs and analysis with macro with some parameters
how do we get such market data and fundamental analysis data of all the companies under my portfolio (xls), so as it can be updated by refresh/automatically, and thereby become available as "consolidated info" in my xls. Please comment/guide me in achieving this. thank you
Is it possible to download foreign companies data too using my excel template?
VERY USEFUL VIDEO ..THANK YOU
Great analysis 👌
Thanks a lot 😀
Can be aviable Mutul fund scaneer in excel?
Any option to download screener made by us on screener
sir i am not able to download the file in customize way i am getting error Reset Excel customization and Template Error!
Great. Feel proud.
Thanks a lot
Excellent , need more such useful videos , will need excel which will give profitability trend of selected sector companies to help investment decision . Thanks for all the efforts u put in .Shailesh Saraf also does excellent analysis but we do not get the excel file , pl check bro if you pull something helpful out of it.
Thanks for your feedback. Will certainly make more such videos.
brother...how to make excel for my stocks portfolio to check yearly and quarterly improvement in fundamentas which i hold ....like top line and bottom line improving or not
Sir how we can make this database sheet dynamic with VBA code if we change stock code directly from sheet.
Excellent
Can i copy paste this one?
GREAT WORK 🌳👌🌺
Thank you so much sir.
Where we get manual entry data please make one vedio on that
Hi Sir, Here you said that we by typing in the company name in excel and we get the required financial data of the stock. how do we do that?
Wonderful video. Please grant access Sir. Request for link to google sheet sent to you.
Common Size P&L Showing to 2017 but updated year did nopt showing this excel
hey,
I'm doing it...but the exported excel sheet is empty...tried on 2-3 companies...all empty files are being downloaded.
where am I going wrong?
pls, help....
need the analysis data urgently
It may be the issue with company. Try with RELIANCE INDUSTRIES.
Good ✌
Thank You so much
Is it possible, to download, in 1 excel sheet, last 10 Years of fundamental data of all NSE companies, to compare & RANK them on different parameters?
Yes it is possible. Will post a video on it soon. Make sure you subscribe to the channel to stay updated and support :)
@@BhavyaGupta thanks, awaiting.
thanks
It is indeed a great method to analyse companies or stocks. But they don't allow to download the excel template v5.0 . I think it's for paid subscription.
Yes
Can we see real time changes like fundamental changes after quarterly result so it automatically change or not ?
How can download file
HI Bahavya how to download this or share the link.
Plz follow whole process as has been discussed in the video. You will be able to do it :)
Damm cool
Thanks a lot
Hi Bhavya, pls share your contact details. I am having some issues in excel model
this is for their PAID subscription for free they don't allow u to download it
They allow, it's free :)
perfect ❤ shareacademy
Thank you so much
Kya galat dekha raha hai bakwas
Is it possible, to download, in 1 excel sheet, last 10 Years of fundamental data of all NSE companies, to compare & RANK them on different parameters?
Same qus Is it possible to download the stocks under 500rs and analysis with macro with some parameters