Saturday, December 12, 2009

S&P 500 Constituents - GICS Sector, Industry Group, and Industry Classification

I could not find a free table listing the GICS Sector, Industry Group, and Industry Classifications for the S&P 500 constituents. I therefore spent a few hours scraping it from web sources. The constituent list reflects S&P's index changes that are scheduled to go into effect on December 18, 2009.

Download it here 2009-12-18-SP500Constituents-SectorAndIndustry.csv

Enjoy.

15 comments:

  1. Good job! Saves me a lot of time. Thanks

    ReplyDelete
  2. very good to have - thanks for helping

    ReplyDelete
  3. do you happen to have a list of historical index addtions and deletions for SP 500?

    ReplyDelete
  4. Historical index additions and deletions are in a new post: http://dareminator.blogspot.com/2010/02/s-500-constituent-change-history.html

    ReplyDelete
  5. thank you soooo much.....u saved my day!!!

    ReplyDelete
  6. Terrific... thank you! The S&P people used to include the top level GICS codes in their downloadable files, but chose to make their tables LESS useful instead for some reason.

    I have the S&P/TSX Composite Index stocks (Canadian) broken out by GICS groups in my Data&Charts workbook at http://TSX.ProfiTrend.com. This has also been a manual exercise for me recently for the same reason I mention above.

    ReplyDelete
  7. hey would you mind sharing the websites you used to piece together the GICS classifications for the S&P500? With the help of a couple good websites I could update it pretty easily on a weekly basis.

    ReplyDelete
  8. Thanks a lot.Do you have any idea how to get these companies sorted by market capitalization?

    ReplyDelete
  9. Looks like you put this together a year ago. Do you happen to have something more recent or were there no changes in the past year?

    ReplyDelete
  10. Excellent job & Thanks a lot for finding the stocks for us dareminator.

    I wander if you have the Index or ETF ticker for each of the Industries (Aerospace & Defense
    , Air Freight & Logistics, Airlines, Auto Components, Automobiles, Beverages...)included the GICS classification system?.

    If not could You give me an aproach of how to get them.

    Thanks a lot in advance for the help You can provide.

    Best regards,
    Miguel

    ReplyDelete
  11. Awesome!! You saved me a lot of time. Thanks!!!

    ReplyDelete
  12. Any possibility of getting an update of this for today ;) ?

    ReplyDelete