Awesome BSEXL – One Excel sheet for everything

Posted at May 16, 2009 written by Pratyush

“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:

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:

Tools

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.

  • Siva
    It is an excellent work...... Can you Upload the updated Excel sheet with 2009 data for all the companies...
  • Rajendra Kamat
    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.
  • Niten
    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
  • Siddharth
    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
  • Naveen
    Any updates on more advanced tool?

    Thanks Naveen
  • 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.
  • Pankaj
    Its very good tool to analysis of stocks & comparison. But many of blue chip shares are missing from this list why?
  • 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.
  • How to update the current Price? I am using Excel 2007? Is this compatible with it?
blog comments powered by Disqus