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

awesome bse

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)