Accounting and market data¶
This family standardizes Compustat financial statements and CRSP returns, and builds the links that connect Revelio firms to public-firm identifiers.
flowchart TB
funda[(Compustat Funda SAS)] --> raw_annual[(Project-raw annual Compustat)]
ccm_source[(CCM link SAS)] --> ccm[(Project-raw CCM links)]
wcik_source[(WRDS historical CIK--GVKEY SAS)] --> wcik[(Project-raw historical CIK--GVKEY links)]
msf[(CRSP MSF SAS)] --> raw_crsp[(Project-raw CRSP monthly)]
stocknames[(CRSP Stocknames V2 SAS)] --> raw_names[(Project-raw CRSP security history)]
raw_annual --> annual[(Processed annual Compustat)]
raw_crsp --> crsp[(Processed CRSP)]
revelio[(Revelio company reference)] --> mapping[(Revelio--Compustat mapping)]
annual -->|eligible GVKEY universe<br/>and metadata| mapping
ccm -->|dated CUSIP--GVKEY links| mapping
wcik -->|historical CIK--GVKEY evidence| mapping
raw_names -->|dated CUSIP evidence| mapping
classDef source fill:#e8eef7,stroke:#52739e,stroke-width:2px
classDef support fill:#fff0cc,stroke:#a66b00,stroke-width:2px
classDef reusable fill:#e2f2e7,stroke:#3b7a4b,stroke-width:2px
class funda,ccm_source,wcik_source,msf,stocknames,revelio source
class raw_annual,ccm,wcik,raw_crsp,raw_names support
class annual,crsp,mapping reusable
Products¶
| Dataset | Role | Grain | Current location |
|---|---|---|---|
| Project-raw Compustat and identifier links | Pipeline support | Vendor financial record / dated identifier-link intervals | /data/full/raw/compustat_annual.parquet, ccm_linktable.parquet, wciklink_gvkey.parquet |
| Project-raw CRSP | Pipeline support | Security-month / security-name interval | /data/full/raw/crsp_monthly.parquet, crsp_stocknames.parquet |
| Processed Compustat | Reusable | Firm-fiscal year | /data/full/processed/compustat_annual.parquet |
| Processed CRSP | Reusable | Security-month | /data/full/processed/crsp.parquet |
| Revelio-Compustat mapping | Audited reusable mapping | Revelio firm | /data/full/processed/mapping_rcid_gvkey.parquet |
Follow the build workflow for the required order.