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/
Categories & Tags:
Leave a comment on this post:
You might also like…
How do I reference… a newspaper article in the APA7 style?
If you're using newspaper content in your work, you may be wondering how to reference it. Is it exactly the same as a journal article reference? Well, it's pretty similar. Here's a short guide. To ...
Resource trial: Writefull
Throughout June, Library Services are running a trial for Writefull which provides tools to help with academic writing. Writefull's support includes proofreading, spelling and grammar checking your work. It can also help you craft your ...
Working smarter, cleaner and greener: The future of manufacturing and materials
Everything we own, use or interact with in life starts with a material or materials. But even we in the industry admit that materials are a huge part of what has led us to where ...
Hubert Ovie Madise: My group design project
'Hubert Ovie Madise, what have you been up to the past ten weeks?' The Cranfield School of Water, Energy and Environment (SWEE) Group Design Project (GDP) module - that's what! The SWEE GDP module ...
The importance of big ideas: How small businesses can maximise their impact
Every year the Bettany Centre for Entrepreneurship hosts our annual entrepreneurship conference VentureDay. We are proud to have some small and medium enterprise (SME) owners on staff, including Heni Cloake and Gabriela Pearson, who share ...
How do I access the full-text of Harvard Business Review (HBR)?
This is one of the most frequently asked questions in the School of Management Library, presumably because HBR is such a key management journal and is renowned worldwide. The short answer is via EBSCO Business ...