
However, all (SAS) files are available in the following subdirectory in WRDS server: /wrds/tfn/sasdata/dealscan DealScan (SAS) Tables in WRDS are presented in the next table.

Only the main ones datasets (Company, Package and Facility) are available through WRDS web queries. As of January 2010, DealScan provides 21 datasets in WRDS, that include information about borrower, lender, purpose, amount, fees, covenants, financials and more. For instance, PLC DealScan collects global as well as US data ( and it contains bank loans from foreign lender to foreign companies ).ĭealScan Datasets at WRDS. For international borrower information, Haselmann and Wachtel (2009) matched DealScan international firms with Bureau van Dyk's Amadeus database. In order to obtain lender's information, Guner (2006), for example, matched DealScan with a bank database (FDIC's Call Reports). For borrower's information, researchers would need to link DealScan firms with Compustat data ( see Chava and Roberts, 2008). Dealscan collects terms and conditions information about loans as of their date of origination.Įven though Dealscan provides detailed reports on each loan characteristics, it does not provide additional information about the lender and borrower per-se beyond company names and tickers ( if available). Each deal may comprise one or more ‘facilities' (term loans, bridge loans, line of credit, leases, etc).Įach Facility is treated as one observation.
DEALSCAN DATABASE MANUAL DOWNLOAD
Cara Download Epaper Kompas on this page. The “Deal” is contract signed between a borrower and a lender (or lenders) at a particular date. The data on Dealscan are organized by “Package” (or Deal) and by “Facility”. Chava and Roberts (2008) reported that around 60 percent of DealScan data comes from SEC filings. Carey and Hrycray (1999) estimated that DealScan loans covered between half and three-quarters of the volume for outstanding commercial and industrial loans in the US.
DEALSCAN DATABASE MANUAL REGISTRATION
DealScan data is compiled from SEC filings and public documents (10Ks, 10Qs, 8Ks and registration statements), loan syndicators as well as other internal sources.Ĭarey and Hrycray (1999) and Chava and Roberts (2008) provide nice introduction to LPC DealScan and find that DealScan seems to provide a good coverage of US loan market. However In addition to loans data, it LPC DealScan also provides contract information for high yield bonds, private placements and hybrid financial structures.


DealScan database contains comprehensive historical information on loan pricing and contracts details, terms, and conditions. WRDS-Thomson-Reuters' LPC DealScan, also known as Loan Pricing Corporation Deal Scan, is “the world pre-eminent source for extensive and reliable information on the global commercial loan market”. Background Information I Introduction to the Deals Database The Deals Database contains information on over $2 trillion of large corporate and middle market. DEALSCAN The DealScan database - accessible through Thomson Reuters LPC’s LoanConnector platform - is the world’s number one source for comprehensive.
