All Projects → datasets → S And P 500 Companies

datasets / S And P 500 Companies

List of companies in the S&P 500 together with associated financials

Programming Languages

python
139335 projects - #7 most used programming language

List of companies in the S&P 500 (Standard and Poor's 500). The S&P 500 is a free-float, capitalization-weighted index of the top 500 publicly listed stocks in the US (top 500 by market cap). The dataset includes a list of all the stocks contained therein.

Data

Information on S&P 500 index used to be available on the official webpage on the Standard and Poor's website but until they publish it back, Wikipedia is the best up-to-date and open data source.

Sources

Detailed information on the S&P 500 (primarily in XLS format) used to be obtained from its official webpage on the Standard and Poor's website - it was free but registration was required.

  • Index listing - see <data/constituents.csv>
    • used to be extracted from source Excel file on S&P website but this no longer contains a list of constituents. (Note this Excel was actually S&P 500 EPS estimates but on sheet 4 it used to have a list of members - previous file was just members but that 404s as of Dec 2014) (Note: but note you have to register and login to access - no longer true as of August 2013)
  • Historical performance (source xls on S&P website)

Note: for aggregate information on the S&P (dividends, earnings, etc.) see Standard and Poor's 500 Dataset.

General Financial Notes

Publicly listed US companies are obliged various reports on a regular basis with the SEC. Of these 2 types are of especial interest to investors and others interested in their finances and business. These are:

  • 10-K = Annual Report
  • 10-Q = Quarterly report

Preparation

You can run the script yourself to update the data and publish them to GitHub : see scripts README.

License

All data is licensed under the Open Data Commons Public Domain Dedication and License. All code is licensed under the MIT/BSD license.

Note that while no credit is formally required a link back or credit to Rufus Pollock and the Open Knowledge Foundation is much appreciated.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].