select a.*, b.permno, b.linkdt, b.linkenddt from comp.funda a join ccm.ccmxpf_linktable b on a.gvkey = b.gvkey where b.linktype in (‘LU’, ‘LC’) and b.linkprim = ‘P’;
import wrds import pandas as pd
(Full script available as supplementary material) wrds compustat
Note : Market equity (ME) is best obtained from CRSP monthly file ( mktcap or PRC * SHROUT ), then linked via CCM.
Unlocking Financial Insight: A Guide to WRDS Compustat Wharton Research Data Services (WRDS) is the industry-standard platform for high-performance financial research, and is widely considered its most essential database. For researchers in accounting, finance, and economics, WRDS Compustat provides the high-quality, standardized data necessary to analyze market trends and corporate performance across decades. What is WRDS Compustat? select a
You're looking for useful posts related to WRDS (Wharton Research Data Services) and Compustat!
Essential Compustat data items (annual): What is WRDS Compustat
Some popular topics related to WRDS and Compustat include: