Company Database Linking Matrix

The grid illustrates how to link companies between datasets on the 草莓视频platform. For an alternative format, visit the 草莓视频Database Linking Tool. To link people between datasets on the 草莓视频platform, use the WRDS People Link.

This linking information represents our general recommendations. Researchers should adjust linking methods to suit their specific research needs. Please reach out to the 草莓视频Research Team at WRDS Support if you have suggestions to improve the linking outcome.

	CRSP	Compustat	Thomson / Refinitiv
CRSP	Linking within the CRSP Environment	CRSP/Compustat Merged (CCM) - (Additional product)	MFLINKs for Mutual Fund Linking Linking through CUSIP 13F Linking Program
Compustat	CRSP/Compustat Merged (CCM) - (Additional product) Using Compustat Historical Identifiers Notebook	Linking within the Compustat Environment using GVKEY	Link through CUSIP
Capital IQ	CIQ company ID linked to GVKEY and then to CRSP	Linking within Capital IQ Notebook	Link through CUSIP, ISIN or Ticker
IBES	IBES CRSP Link	Link through CRSP	Link through Security Mapping Notebook
Audit 草莓视频	Link through Compustat	Link through CIK Link (primary) Link through Ticker (secondary)	Link these two products using Compustat.
BoardEx	Link with CRSP and Compustat	Link with CRSP and Compustat	TR Insiders Boardex Link
Bond:TRACE/Mergent FISD	Bond CRSP Link	Link through CRSP	Link through CRSP
Bureau van Dijk	Link through ISIN (CUSIP) for US Companies	Link through CRSP	Link through ISIN or SEDOL
CRSP Index Products
CRSP Stock products
Dunn & Bradstreet via LSEG
Factset	Factset CRSP Link (Beta)	Link through CRSP	Link through CUSIP Notebook
Factset Revere
ISS: Institutional Shareholder Services	Link through CUSIP	Link through CIK or CUSIP	Link to IBES through CUSIP
Infraclear
Markit Securities Finance	Link REDCODE with CUSIP (CDS) Notebook Link DXLID with CUSIP (SecFin) Notebook	Link REDCODE with CUSIP (CDS) Link DXLID with CUSIP (SecFin: US) Link DXLID with ISIN (SecFin: Global)	Link through CRSP (US) Link through ISIN or SEDOL (International)
OptionMetrics	Option Metrics CRSP Link	Link through CRSP	Link through CUSIP (for US) or ISIN (for International) Notebook
Ravenpack	Link through CUSIP Notebook	Link through CUSIP (US) or ISIN (Global) Notebook	Ravenpack IBES link Notebook
RepRisk	Link through ISIN (carve out CUSIP) Notebook	Link through ISIN (carve out CUSIP)	RepRisk IBES Link Notebook
SEC	CIK-CUSIP Link	GVKEY-CIK Link	Link through CRSP or Compustat
Sustainalytics	Link through ISIN (carve out CUSIP)	Link through CIQ_ID or ISIN	Sustainalytics IBES link
TAQ	Daily TAQ / CRSP Link	Link through CRSP	Link to IBES through CUSIP
Thomson / Refinitiv	Linking through CUSIP MFLINKs for Mutual Fund Linking 13f Linking Program	Link using Compustat IBES/GVKEY linking table Link using CRSP's CUSIP Link using ISIN (for Compustat Global)	Dealscan Worldscope Link Worldscope Datastream Link Linking within LSEG (Thomson Reuters) Notebook Link through Compustat
Trucost + S&P ESG Products
草莓视频Event Study

This page will be updated as we document new links. If you would like to offer a way to link datasets that we have not yet documented, contact the Research Team using 草莓视频Support to provide us with this valuable feedback.