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…
Using AI tools for your literature review
There are a proliferation of AI tools that can help you organise your life, work and study. This post focuses on academic or scholarly tools that have been developed to enhance the literature searching process, whether for independent research, an assignment or thesis. Bear in mind that these predominantly relate to finding journal/research papers, and not technical, business or trade sources such as standards, market research, industry reports or financial data. So ...
Finding successful past Cranfield theses
It’s always a good idea to look at examples of theses before you start work on your own. You may find them valuable for reading previous research, and for looking at structure, style and methodology. ...
On‑campus or off‑campus? How Cranfield students found their home away from home
Finding the right place to live is one of the biggest decisions you’ll make as you begin your student journey. Whether you’re looking for the convenience and community of living on-campus or the independence ...
Avoiding common referencing errors
As librarians, we get to see the full spectrum of reference lists in student work —from exemplary to … well, let’s just say, works still very much in progress! We are experts in spotting mistakes ...
Using your Mendeley library after you have left Cranfield
So you have spent the whole year (or more) lovingly collecting references around the topics that matter to you and now you have a large, personalised library in Mendeley Reference Manager containing all that information. ...
Referencing the use of generative AI in your work
We recognise that Artificial Intelligence (AI) has, and will increasingly, become a part of our everyday lives and that we need to adapt to it. Hopefully you will have already seen the guidance for staff ...