Thursday, December 17, 2009

F***ing Ba***rds

I am talking about BSE. I have maintained my own excel sheet of BSE500 and BSE SMALL CAP indices where I keep every company's book value, its debt, its profits and sales of last 20 years, etc... I have a practice of visiting their SMALL CAP and BSE 500 scrip watch page, copying the daily quotes, pasting them in an excel and copying the price column and pasting it to my own maintained excel sheet every day. But these guys keep changing the order of the scrip every day. Sometimes RIL is represented as Reliance Industries, sometimes Reliance Inds and sometimes RIL. When I paste the newly ordered prices into my excel sheet, price of Reliance Power appears against RIL and price of RIL against Reliance Infrastructure. Can somebody please lay off these guys at BSE and hire some professionals?
at

4 comments:

  1. Value ArchitectsDecember 18, 2009 at 11:03 AM

    u should rather do it on yahoo finance. I am using that since almost for a decade and it works beautifully!

    ReplyDelete
  2. ChinmayDecember 18, 2009 at 11:04 AM

    Thanks for your advice.

    ReplyDelete
  3. Nirav Shah,CA,CPADecember 20, 2009 at 7:22 AM

    first copy and paste it to some temp excel sheet and run vlookup command into your excel sheet so it will exact match the name and populate price against the matched names

    hope this would work for you

    Kind Regards,

    Nirav Shah

    ReplyDelete
  4. rajamaniDecember 22, 2009 at 3:59 PM

    hi chinmay ji,

    could you post your fundamental views on austral coke fii holding has increased in the past qtr

    http://www.bseindia.com/bseplus/StockReach/AdvanceStockReach.aspx?scripcode=533016

    regards
    rajamani

    ReplyDelete