Skip to content

Compustat and CRSP vendor data

Compustat and CRSP provide financial statements, public-firm identifiers, security links, returns, and historical firm classifications. They do not feed the core HCT training sample; they are used for public-firm links and analyses.

Access: WRDS extracts
Storage: /data/compustat/

Files used

Asset Main contents
funda.sas7bdat Full Compustat annual Funda delivery
ccmxpf_linktable.sas7bdat Compustat gvkey to CRSP security links
wciklink_gvkey.sas7bdat WRDS SEC Suite historical CIK--GVKEY links, including dated link provenance
msf_v2.sas7bdat CRSP monthly stock-file delivery
stocknames_v2.sas7bdat CRSP CIZ historical security names and identifiers
execucomp/ Executive identity, role, and compensation tables

The project persists configured fields from these vendor SAS files as raw Parquet, then filters the annual Funda data to industrial, consolidated, standardized USD records. The CRSP security-history source preserves dated CUSIP, ticker, and issuer-name evidence for identifier mapping. The variable lists and source paths are explicit in shared/config/config_full.yaml; refreshes should retain the vendor files and record the WRDS extraction date.

Reusable annual Compustat and CRSP outputs and company mappings are documented under Accounting and market data. ExecuComp is documented separately because it is a person-level vendor product.