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…
Creating Impact: Women in STEM Scholars discuss their journey and aspirations
We recently had the opportunity to catch up with some of your Women in STEM scholars to discuss what receiving the scholarship means to them, their experiences studying and living in the UK, their ...
Getting involved in outreach activities improved me as a Cranfield PhD Researcher
I spent an amazing three years as a PhD student with the Plant Science Laboratory, researching the metabolic and physiological changes in mango ripening. As a Cranfield PhD student I had many opportunities outside ...
Academic spotlight interview: Hannah Allen
From Crime Scenes to Classrooms: Hannah Allen’s Unique Path in Forensic Science “Forensics is about finding justice for victims, ensuring the guilty are prosecuted, and protecting the innocent.” Forensic Investigation MSc Course Director, Hannah ...
Automotive Engineering MSc alumnus Ghazi Raad on the impact of Cranfield on his career
Ghazi Raad is a Senior Innovation Engineer at AQA. He graduated from Cranfield University with an MSc in Automotive Engineering in 2023, after also completing a Pre-master’s in engineering in 2022. ...
Running a peer analysis in Fame
If you need to compare a UK company’s financial performance against that of other companies, Fame is a great place to start. This database contains the financial accounts of over 8.5 million public and private ...
From medical robotics to space exploration: My journey at Cranfield University
My name is Praveen Elavazhagan, and I’m from India. I recently completed my MSc in Robotics at Cranfield University, graduating in 2024. My journey to Cranfield, and now into a PhD, ...