Skip to content

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.