


For all other uses please contact Michael R. (WRDS) and can be found under: Thomson Reuters - WRDS-Reuters Dealscan - Compustat Linkingĭata may be used for non-commercial purposes free of charge. If you find any errors or additional matches please notify me so that I can update the file and notify others.ĭealscan-Compustat Link Data: Excel File (Save the linked file).(formerly entitled "Is Financial Contracting Costly? An Empirical Analysis of Debt Covenant Violations") "How does Financing Impact Investment? The Role of Debt Covenants," with Sudheer Chava, Journal of Finance 2008, 63, 2085 - 2121. The dataset I construct merges the Dealscan syndicated loan database, which contains the borrowing history of both public and. Please reference the following paper which contains details on the construction.The current version of the file contains matches through the end of 2017.Ĭonditions for the use of this dataset are as follows: The construction of this link file has been an ongoing process since 2002. Dealscan-Compustat Link Data This link file enables researchers to merge Thomson-Reuters LPC Dealscan database and Standard and Poors Computstat database. In Dealscan to a borrower's unique company identifier in Compustat (GVKEY). Dealscan Database Manual Dealscan records can be linked to Compustat using the Roberts Database, Ticker (problemetic since tickers can be reused), CUSIP (6 digit is company level. The match is accomplished by linking a loan's facility id (facilityid or facid) To the borrowing firm's financial information on Compustat. The link file matches many of the loans (i.e., facilities or tranches) in Dealscan This link file enables researchers to merge Thomson-Reuter's LPC Dealscanĭatabase and Standard and Poor's Computstat database.īriefly, Dealscan contains detailed contract information on sole-lender and syndicated loans Ĭompsutat contains detailed financial information for firms.
