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.