Skip to content

S&P Capital IQ: company, capital-structure, and transactions data (licensed)

View this page as raw Markdown (.md)

corporate-financedebttransactionslicenseddata:capital-iq

S&P Capital IQ is S&P Global Market Intelligence’s platform covering public and private companies worldwide. It holds detailed capital structure / debt data (individual debt tranches, terms, and maturities), company financials, people / professionals, M&A and private-equity transactions, key developments (corporate events), and ESG-adjacent fields. In research it is most used for granular debt-structure data (Capital IQ Capital Structure) that Compustat does not break out, and for private-company and transactions coverage. A paper we distill uses it, for example Derrien, Krüger, Landier & Yao on ESG news and future cash flows.

  • Cost: licensed, subscription. No free tier.
  • Vendor: S&P Global Market Intelligence.
  • Coverage: global public and private firms, with debt-tranche detail, transactions, and key developments. Most data runs from the 2000s, with some back-history.
  • Via WRDS or the Capital IQ platform. Many researchers reach Capital IQ through WRDS under the Capital IQ libraries (Capital Structure / debt, key developments, people, transactions). It is also available directly through the Capital IQ Pro platform and its API.
  • Identifiers and linking. Capital IQ is keyed by its own companyid (and securityid). To join to Compustat, use the CIQ-to-gvkey linking table (ciqgvkey) rather than assuming a direct match.
  • Credentials and a WRDS or Capital IQ account are required. Keep any credentials in .env, never hard-coded.

These are the failure modes to expect; they are documented, not verified here.

  • Identifiers are not gvkey. Capital IQ uses companyid / securityid, not gvkey. The CIQ-to-Compustat link table (ciqgvkey) is essential and is imperfect: expect unmatched firms and many-to-one cases. Resolve the link before building a panel, and report the match rate.
  • Capital Structure (debt) data is point-in-time / snapshot oriented. Reconstructing a firm’s debt as of a past date is tricky: some fields reflect the latest available value rather than the as-of value, so a naively built panel can be anachronistic. Pull as-of snapshots where available and pin the extraction date.
  • Debt tranches can double-count or omit. Revolver availability versus drawn amounts, capitalized leases, and the classification of hybrids all complicate the totals; summing tranches need not equal balance-sheet debt. Reconcile to a known total before using tranche-level figures.
  • Private-company financials are sparse. Coverage is conditional and not missing at random: private-firm financials are sparsely populated and are self-reported or estimated. Do not treat the populated subset as a random sample of private firms.
  • Key developments change over time. Events are tagged by S&P, and both the taxonomy and the coverage shift across the history. Pin the extraction date and check the event-type definitions for the period you use.
  • It will not match Compustat. Figures will not reconcile to Compustat line items because of different definitions and timing. Do not assume a Capital IQ field equals its nearest Compustat analogue; compare definitions first.
  • WRDS table structure is nontrivial. The Capital IQ tables on WRDS are multiple linked tables, and the join keys must be applied carefully. A wrong join silently inflates or drops rows; validate row counts at each step.
Module / libraryWhat it holds
Capital StructureIndividual debt tranches, terms, maturities, and capital-structure summaries
FinancialsStandardized company financial statements (public and private)
People / ProfessionalsExecutives, board members, and other professionals
TransactionsM&A, private-equity, and financing transactions
Key DevelopmentsTagged corporate events (earnings, deals, management changes)
Linking (ciqgvkey)CIQ companyid-to-Compustat gvkey crosswalk

Cite the provider and the modules used, e.g.: S&P Capital IQ (Capital Structure) / WRDS, accessed YYYY-MM-DD. State the modules / tables used (for example Capital Structure, Transactions, Key Developments), the identifier link applied (ciqgvkey), and the extraction date.

Found an error or want a topic covered? Open an issue, use the Edit page link above, or email contact@instituteforautomatedresearch.org. Edits are reviewed before publishing; provenance and accuracy are the point.