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 the Library.
Feature image from Pixabay. Available at:https://pixabay.com/photos/business-stock-finance-market-1730089/
Categories & Tags:
Leave a comment on this post:
You might also like…
How to build a business that keeps growing
Ask any business owner about their ambitions and "growth" will almost certainly feature near the top of the list. More customers, higher revenues, larger teams and new markets are often seen as signs of ...
Three practical ways SMEs can build resilience in a challenging business environment
Economic uncertainty, shifting customer expectations and rapid technological change have become part of everyday business. While no organisation can predict every challenge, small and medium-sized enterprises (SMEs) can improve their resilience by focusing on ...
Six reasons students fall in love with Cranfield University
If you ask a Cranfield student what makes the University special, you won’t just get the usual “great teaching” answer. You’ll hear stories about industry projects that feel like real jobs, friendships built with ...
Boosting flight safety: Cranfield’s icing wind tunnel in action
The icing wind tunnel (IWT) was established at Cranfield University in 2003. The facility is capable of producing impact ice on models mounted within a range of different test sections. At present, the Cranfield ...
Getting ready to hand in your thesis?
You are nearly there! Many of our students are now starting to think about finishing their theses. If you are one of them, then you might find this post useful as you write up your ...
Frameworks to help you critically evaluate your sources
With so much information available, it can be challenging to identify reliable sources. Not all information is trustworthy, so it is important to critically evaluate what you find. Library Search and our subscription databases can ...

Comments are closed.