{"id":1095,"date":"2007-09-18T01:38:55","date_gmt":"2007-09-18T01:38:55","guid":{"rendered":"http:\/\/www.amibroker.org\/userkb\/2007\/09\/18\/indexes-standard-poors\/"},"modified":"2008-03-03T12:15:51","modified_gmt":"2008-03-03T12:15:51","slug":"indexes-standard-poors","status":"publish","type":"post","link":"http:\/\/www.amibroker.org\/editable_userkb\/2007\/09\/18\/indexes-standard-poors\/","title":{"rendered":"Indexes – Standard and Poor’s"},"content":{"rendered":"

Standard & Poor’s<\/em> (S&P) manage a range of U.S. and global indexes including ‘headline’ equity indices for the U.S., Canadian and Australian markets.<\/p>\n

The http:\/\/www2.standardandpoors.com<\/a> site is a portal to international S&P sites. Index lists and information on indices and investment related matters is available from the  various sites.<\/p>\n

This article solely references the U.S. site to download a current S&P500 constituent list.<\/p>\n

To download an S&P500 constituents list:<\/strong><\/p>\n

1) Go to U.S. Homepage  >> Indices >> Equity Indices >> United States<\/strong> <\/em>and <\/em>select S&P500<\/strong> from the Major Indices <\/em>HTML list. (This opens an S&P500 information panel with Overview<\/em> as the default) or take the shortcut:<\/p>\n

http:\/\/www2.standardandpoors.com\/portal\/site\/sp\/en\/us\/page.topic\/indices_500\/2,3,2,2,0,0,0,0,0,1,3,0,0,0,0,0.html<\/a><\/p>\n

Note: Additional information on the S&P500, including Index Changes<\/em>, can be obtained by clicking on the alternative tabs.<\/p>\n

2) Click on Constituents List<\/strong> in the Overview<\/em> sub-panel.<\/p>\n

\"SandP001\"<\/p>\n

3) Click on the Download Table<\/strong> link in the header of the list that opens.<\/p>\n

\"SandP001\"<\/p>\n

A Download File window will open.<\/p>\n

\"SandP002\"<\/p>\n

4) Save<\/strong> the file to a local drive.<\/p>\n

An example AmiBroker <\/em>application that uses an S&P download will be included in future posts.<\/p>\n

ATTACHED FILE:<\/p>\n

S&P500 Constituent List: sandp500sept2007.xls<\/a> <\/p>\n

Note: The file was uploaded as an Excel file as the CSV file-type used, in this case, did not pass the site upload security filter.<\/p>\n

Written using Windows XPHome, Internet Explorer v7 and Excel 2002.<\/em><\/sup><\/sub><\/p>\n","protected":false},"excerpt":{"rendered":"

Standard & Poor’s (S&P) manage a range of U.S. and global indexes including ‘headline’ equity indices for the U.S., Canadian and Australian markets. The http:\/\/www2.standardandpoors.com site is a portal to international S&P sites. Index lists and information on indices and investment related matters is available from the  various sites. This article solely references the U.S. […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[132],"tags":[],"_links":{"self":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1095"}],"collection":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/comments?post=1095"}],"version-history":[{"count":0,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1095\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/media?parent=1095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/categories?post=1095"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/tags?post=1095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}