Discover our blogs

Aerospace | Cranfield University

Aerospace

Agrifood | Cranfield University

Agrifood

Alumni | Cranfield University

Alumni

Careers | Cranfield University

Careers

Careers | Cranfield University

Defence and Security

Design | Cranfield University

Design

Energy and Power | Cranfield University

Energy and Power

Environment | Cranfield University

Environment

Forensics | Cranfield University

Forensics

Libraries | Cranfield University

Libraries

Libraries | Cranfield University

Manufacturing

Libraries | Cranfield University

School of Management

Libraries | Cranfield University

Transport Systems

Water | Cranfield University

Water

Homepage / Introducing… Compustat data

Introducing… Compustat data

06/02/2020

Does your research need in-depth historical financial data for North American companies?  Has your supervisor told you to use Compustat data? If so, take a look at the Capital IQ platform.

Capital IQ data includes both quarterly and annual data from Compustat dating back to the late 1970s for both active and inactive companies.  You can use a wide variety of criteria – including industry, company account items, financial ratios, S&P indices, etc. – to produce data for groups of companies.  

Compustat data is only available for North American companies that have been or are currently quoted on the following US stock exchanges/indexes:

  • the NYSE, AMEX, NASDAQ, TSX, or NYSE/Arca exchanges.
  • the S&P 500, S&P 400, S&P 600, S&P/TSX Composite or Russell 3000 indices.

To access the Compustat data within Capital IQ, select the appropriate option from the left-hand menu.

You can use a wide variety of criteria – including industry, company account items, financial ratios, S&P indices, etc. to produce tailor-made reports and graphs for both individual firms and groups of companies and export data to Excel.

You can also access Compustat financials from within the Excel add-in by right clicking on an empty cell and go to ADD Formula > Financials > Compustat Financials.

Access to Capital IQ is available here.  You will need to set up an account to use it. Find out how in our post on Setting up your account on Capital IQ.

For more information, contact MIRC.

Feature image from Pixabay. Available at:https://pixabay.com/photos/business-stock-finance-market-1730089/

Written by: Tracey Nunn

Written By: Tom Jaycocks

Categories & Tags:

Leave a comment on this post:

Sign up for more information about studying master’s and research degrees at Cranfield

Sign up now
Go to Top