Awesome BSEXL – One Excel sheet for everything
“I fear not the man who has practiced 10,000 kicks once, but I fear the man who has practiced one kick 10,000 times.” – Bruce Lee
Excel is one tool which we all have used more times than the calculators itself. Then why not get all the data of the companies on an excel sheet ? Awesome BSEXL is an attempt towards that.
Awesome BSEXL is not any hard-to-understand software, but just an excel workbook with the data of currently 1500 BSE listed companies on one sheet. It is like the regular columns found in the newspapers or the Capital Market magazine. However, we have tried to include many other details into it, including following:
- Script Code and Script Name
- Last Trade Price
- Book Value
- P/E ratio
- Discount (Book Value – LTP)
- Sales of last four quarters
- Profits of last four quarters
- Sales of past three years
- Profits of past three years
Using excel filters and advanced filters, you can create queries as you like and make the reverse processing possible (search companies which perform as YOU want them to perform).
We have included the basic advanced filter by default (you can learn more about it at Microsoft site). Thus your capabilities are unlimited.
The data currently in the sheet is only for past 3 years (however you can get data about the companies for more than 10 years here manually). Your comments are more than welcome for future developments.
Download Awesome BSEXL (966kb)
Similar Posts:
- 10 (or even more) Years financial data of Indian companies
- Post Demerger impact of Asian Hotels – Unlocking the hidden value
- Google Finance – The best stock summarizer
- Poly Medicure
- Free Stock Screeners for Indian Stocks
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
How to update the current Price? I am using Excel 2007? Is this compatible with it?
Hi Harsh, yes it is compatible with Excel 2007.
To update the prices, download the BHAV copy from bseindia.com and paste the data in the worksheet of Awesome BSEXL. Also the instructions are given in the worksheet itself (you might need to enable the macros security for the macros to function.)
Hope this helps.
Its very good tool to analysis of stocks & comparison. But many of blue chip shares are missing from this list why?
Hi Pankaj, as it was the first try thus only around 1500 companies were selected. However, now we are working on a bigger web-based stock screener. It will cover more number of companies.
Any updates on more advanced tool?
Thanks Naveen
this is BY FAR the best thing that ever happened to me. Thank you !!
BTW, when I run it in Excel 07, I get the “macros disabled” message. Do I need to do anything about that?
Cheers
Awesome Dude
this is the Best Data of Indian Companies i have found on net
And its free too while others charge thousands For it
Hats off to you
You are just great
Great effort. Truly awesome. Waiting eagerly for web based screener.
I downloaded bahv copy from bseindia.com & pasted it in update prices sheet. However some scripts show #N/A under price cell for some companies. I guess this is because new companies have been added since you have created bsexl. Can you advise how to get over this problem.
Many thanks in advance.
It is an excellent work…… Can you Upload the updated Excel sheet with 2009 data for all the companies…