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.
Download it here 2009-12-18-SP500Constituents-SectorAndIndustry.csv
Enjoy.
Good job! Saves me a lot of time. Thanks
ReplyDeleteThanks! Much appreciated.
ReplyDeletevery good to have - thanks for helping
ReplyDeletedo you happen to have a list of historical index addtions and deletions for SP 500?
ReplyDeleteHistorical index additions and deletions are in a new post: http://dareminator.blogspot.com/2010/02/s-500-constituent-change-history.html
ReplyDeleteAwesome, thanks!
ReplyDeletethank you soooo much.....u saved my day!!!
ReplyDeleteTerrific... 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.
ReplyDeleteI 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.
Thanks!!
ReplyDeletehey 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.
ReplyDeleteThanks a lot.Do you have any idea how to get these companies sorted by market capitalization?
ReplyDeleteLooks 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?
ReplyDeleteExcellent job & Thanks a lot for finding the stocks for us dareminator.
ReplyDeleteI 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
Awesome!! You saved me a lot of time. Thanks!!!
ReplyDeleteAny possibility of getting an update of this for today ;) ?
ReplyDelete