Using WRDS to connect RavenPack data with Compustat data
Linking RavenPack with Compustat (NA)
RavenPack (/wrds/ravenpack/sasdata/) is a database that extracts information on named entities with sentiment, and financially-relevant events from the unstructured content of thousands of publications. In WRDS, RavenPack contains a file named WRDS_COMPANY_NAMES (/wrds/ravenpack/sasdata/common) that contains the identifiers ( RP_ENTITY_ID, ISIN, CUSIP, and TICKER). Ravenpack’s CUSIP (9-character cusip) could be used to link with Compustat’s CUSIP (9-character cusip).
This sample code shows the procedure. Please make sure to select "SAS" in the kernel list when trying to run the code in Jupyter Notebook environment.
Jupyter Notebook: LinkRavenpackComp.ipynb Download
Linking RavenPack with Compustat Global
To link RavenPack data with Compustat Global data, begin by using the RavenPack WRDS_COMPANY_NAMES file as shown in the instructions above. Then, merge the WRDS_COMPANY_NAMES with the Compustat Global data by using the ISIN. The following sample code shows the procedure for linking the identifiers of both databases: