Dealscan-Compustat Link Data

This link file enables researchers to merge Thomson-Reuter's LPC Dealscan database and Standard and Poor's Computstat database. Briefly, Dealscan contains detailed contract information on sole-lender and syndicated loans; Compsutat contains detailed financial information for firms.

The link file matches many of the loans (i.e., facilities or tranches) in Dealscan to the borrowing firm's financial information on Compustat. The match is accomplished by linking a loan's facility id (facilityid or facid) in Dealscan to a borrower's unique company identifier in Compustat (GVKEY).

The construction of this link file has been an ongoing process since 2002. The current version of the file contains matches through the end of 2017.

Conditions for the use of this dataset are as follows:
  1. Please reference the following paper which contains details on the construction and usage of the data.

    "How does Financing Impact Investment? The Role of Debt Covenants," with Sudheer Chava, Journal of Finance 2008, 63, 2085 - 2121. (formerly entitled "Is Financial Contracting Costly? An Empirical Analysis of Debt Covenant Violations")

  2. If you find any errors or additional matches please notify me so that I can update the file and notify others.
Dealscan-Compustat Link Data: Excel File (Save the linked file)

The file is also available on Wharton Research Data Services (WRDS) and can be found under: Thomson Reuters --- WRDS-Reuters Dealscan --- Compustat Linking Table

Data may be used for non-commercial purposes free of charge. For all other uses please contact Michael R. Roberts.