COMPUSTAT is a database we subscribe to through WRDS (Wharton Research Data Service).  WRDS is available on a single

computer in the BusinessSPEA Information Commons.  Kelley faculty may obtain their own accounts.

COMPUSTAT Noth America (from Standard & Poor's) provides more than 300 annual and 100 quarterly Income Statement,

Balance Sheet, Statement of Cash Flows, and supplemental data items on more than 24,000 publicly held companies.

COMPUSTAT Global & EMDB

Compustat Global provides data covering publicly traded companies in more than 80 countries, representing over 90% of the

world's market capitalization, including coverage of over 96% of European market capitalization and 88% of Asian market

capitalization.  S&P's EMDB covers 53 markets and more than 2,200 stocks in developing countries.

Sample Queries:

Historical lists of S & P 500 constituents:

Select Compustat North America

Click on "Tools" at the very top of the page

Select "S & P Index Constituents"

Create Query (various variables on the page)

Under "Select Output", go with the default which is a fixed width text file. The resulting file can

easily be uploaded into Excel (just not on this machine). Depending on the size of the file, the

search may take a while. Eventually however, a link will appear to the txt file.