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…
What opportunities are offered by vehicle connectivity and automation on highway?
Over the past decade, the number of road vehicles connected with the outside world has been growing rapidly, in response to the need for real-time navigation data, the introduction of eCall requirements, the practicality ...
Download the Library app!
You can use it to: Check what we have in our print collection (and a selection of our eBooks too!) Borrow items directly with the app instead of using a self-service machine* Reserve and renew ...
Why I chose Cranfield
After completing an undergraduate degree in Internet of Things Engineering, Zhen Sun was working with Siemens and looking for an area to give his focus to. He seized the opportunity to upgrade his skillset ...
Bloomberg basics
Accessible in SOM Library from 12 dedicated terminals, Bloomberg provides access to the real world of finance through the same platform as used by the world’s leading banks, corporations and government agencies. Bloomberg provides real-time ...
Five tips to help you start your Cranfield journey
Starting your postgraduate study journey can be a roller coaster of emotions; as exciting as it is nerve wracking. While there’s lots to look forward to, it’s also normal to be apprehensive of what ...
How do I reference… YouTube, TikTok and other audio-visual material in the APA7 style?
Have you ever wondered how to include a reference to audio-visual material such as a video posted on YouTube or TikTok? If you have, you're in the right place! Referencing audio-visual material is as straightforward ...