Understanding Capital IQ: A Comprehensive Overview

Slide Note
Embed
Share

Explore the world of Capital IQ through this detailed guide covering its history, products on WRDS, unique features, and comparison with other data services. Learn about the extensive financial information, real-time market data, structured datasets, and people intelligence provided by Capital IQ. Dive into the wealth of data available on capital structures, transactions, key developments, and more. Discover how Capital IQ stands out in the financial data landscape with its comprehensive offerings and user-friendly interfaces.


Uploaded on Jul 22, 2024 | 0 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

E N D

Presentation Transcript


  1. WHARTON RESEARCH DATASERVICES Introduction to Capital IQ April, 2020 Eunji Oh, Ph.D.

  2. Agenda 1 Capital IQ Overview 2 Capital IQ Products on WRDS 3 Capital IQ products Schema 2 Wharton Research Data Services

  3. Capital IQ Founded in 1999 and acquired by Standard & Poor s in 2004 Provides financial information and workflow solutions to financial institutions Real-time market data, back-testing, portfolio management, financial modeling, quantitative analysis Capital IQ products on WRDS Compustat Capital IQ Xpressfeed via WRDS 3 Wharton Research Data Services

  4. Capital IQ on WRDS Capital IQ Web Portal Structured Datasets Capital Structure Transactions People Intelligence Key Developments Transcripts 4 Wharton Research Data Services

  5. Comparison Capital IQ Portal Capital IQ via WRDS Web interface Structured data (XpressfeedTM) Company-oriented interface Various options to access to and work with the bulk data Real time & dynamic data WRDS cloud (SAS, Stata, Python, R, Matlab, Postgresql) Short historical data Data fields contain most current information Web query for direct download All historical data is available Quarterly updates Each product has different update schedule (quarterly to annually) 5 Wharton Research Data Services

  6. Capital IQ Capital Structure Capital Structure Extensive detailed debt and equity capital structure for global public and private companies Point-in-time database Debt structure goes back to 2001 Equity structure goes back to early 1990s Sources: press releases, company websites, global stock exchange, SEC, and etc. 6 Wharton Research Data Services

  7. Capital IQ People Intelligence People Intelligence Professional and compensation data for executive and directors of global companies Other descriptive information included is Biographies, Specialties, Job Functions, Coverage, and Educational Relationships Data goes back to 1992 Sources: proxies, public records, regulatory filings 7 Wharton Research Data Services

  8. Capital IQ Key Developments Key Developments Material news and events that may affect the market value of securities 165 event types with announcement date Significant coverage starts from 2003 Sources: press releases, news wires, regulatory filings, exchanges, company web sites, web mining (significant percentage), and call transcripts (2009+) 8 Wharton Research Data Services

  9. Capital IQ - Transactions Transactions Detailed data and analysis of corporate entity transactions About 2 million transactions across the globe Deals with non-corporate entities are covered, including government institutions, educational institutions, and etc. Significant coverage starts from 1998 for US data 9 Wharton Research Data Services

  10. Capital IQ - Transcripts Transcripts Historical conference call transcripts around the world covering around 8,000 public companies Earnings conference calls, Conference presentations, M&A calls, Shareholder calls, and etc. + Language: English Full text data accessible on WRDS cloud Significant coverage starts from 2008 Sources: Call recordings, Other data vendors 10 Wharton Research Data Services

  11. Use case of Capital IQ products Example: In-depth analysis on multiple M&A events using Transcripts, Key developments, People Intelligence, Transactions M&A Call Event M&A Call Transcript KeyDevId ProID CompanyId, Date Executives information M&A GVKEY-CompanyId Link Compustat Transactions Event M&A CompanyId, Date Transactions Details 11 Wharton Research Data Services

  12. Related videos More detailed information will be covered in separate videos: How to pull Capital IQ data Capital IQ identifiers Capital IQ Transcripts Capital IQ Key Developments And so on 12 Wharton Research Data Services

Related


More Related Content