“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.
How to update the current Price? I am using Excel 2007? Is this compatible with it?
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.
Pratyush, and the Mittal family
First of all, thanks for these efforts.
As for the excel, can you somehow build it to ‘automatically grab the data for 2009 and 2010 as well?
Awesome job!
Suvikas
Hi Suvikas,
Thanks for the feedback.
I have sent you an email regarding updates.
Regards,
Pratyush
How to update the results for 2009 & 2010?
Regards
Prakash
How to update the results for 2009 & 2010?
Regards
Prakash
Hi Pratush,
Firstly Thanks for making this wonderful sheet!!!
Can you please tell me how to update all the ratios .. 2008 ownwards in this sheet….
The prices are updated using Bhav Copy…. but where to find a collated excel list of all the other fundamentals and earnings.
Regards
Akshay
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?
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.
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
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
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
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.
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…
It is an excellent work…… Can you Upload the updated Excel sheet with 2009 data for all the companies…
Really great effort thank you very much
Hi Pratyush,
Just wanted to understand how this was created… how do you query for financial information?
Data entry operations by company is likely to be very time consuming
I had created a bot using iMacros for Firefox, that grabbed the data.
hello pratyush.may i get this software from you
hey..this pe and eps is as of 2009……..how do i get the same for 2008,2007and 2006
I had a look at the new web based screener and it rocks! what a concept and the amout of filtering is amazing. It only allows to download first 1000 records. I am excel person, so getting a extract in excel and then playing on it is much more flexible. Is there a way to get a complete extract (more than 1000) based on the filters I choose? Great work on the screener and the blog.
Thanks Aakash. Do keep an eye on updates. The new version we are working on will have even more variables, more alert options, better interface.
The web version is a bit complicated, in sense you have to type in the query, but we feel it is surely worth the efforts.
Thanks again for the feedback and appreciation,
Pratyush
Hi Pratush,
Firstly Thanks for making this wonderful sheet!!!
Can you please tell me how to update all the ratios .. 2008 ownwards in this sheet….
The prices are updated using Bhav Copy…. but where to find a collated excel list of all the other fundamentals and earnings.
This is great tool!! May be need to check the accuracy of the data..e.g. the market cap for Container Corporation Ltd at Rs. 868 appears very high…may be you can add the outstanding no. of shares as another column to ascertain more accuracy!!
Please update the data on all companies.Thanks for your past work done.
Hi, Is there a way that I can get the daily delivery % in an automated fashion? Essentially, I want to track the traded volume and the % delivery.
Is there a latest version of this sheet available? I mean with 2012 data + 3yrs history
Salute you guys…. i was looking for the screener and such an excel for a long time. thanks a lot. 🙂
Can u update and publish this Xcel sheet? It will be very helpfull for us.
Hi Ranjit,
Can you please give Screener a try: http://www.screener.in
It includes all the functionalities of the above excel sheet along with many other features including automatic updates and email alerts.
I am sure it will fill the missing void.
Introduction to Screener: https://dalal-street.in/introducing-screener/
Is there a spreadsheet where I can download daily stock prices for certain number of stocks from BSE and NSE?
HOW TO GET THIS EXCEL SHEET NOW ?
I there a latest updated sheet for year 2016
Is there a latest updated sheet for year 2016 ??
Clean UI & Simple navigation Fantastic work guys, Do you offer API integration or services ?