CRSP Monthly Stock File // crsp_msf

CRSP monthly stock file (MSF). Returns, prices, shares outstanding and trading volume for all common stocks listed on NYSE/AMEX/NASDAQ since 1925. The canonical US asset-pricing dataset; almost every US empirical-finance paper uses it.

数据来源:Center for Research in Security Prices, University of Chicago Booth School of Business · 版本:Monthly Stock File (MSF) — rolling · 更新:monthly, ~3 weeks after month-end · 官方页面

常用研究方向

CRSP Monthly Stock File 共收录 18 个变量——其中常被用作因变量的 3 个、用作核心自变量的 6 个、用作控制变量的 10 个。本数据集常见的研究方向包括:Size effect on monthly returns、Cross-sectional momentum (Jegadeesh-Titman)。

Size effect on monthly returns:因变量 ret,核心自变量 shroutprc,建议控制 exchcdshrcdsiccd

Cross-sectional momentum (Jegadeesh-Titman):因变量 ret,核心自变量 ret,建议控制 exchcdshrcdsiccd

variables · 变量清单(18 个)

变量名标签类型/角色数据文件说明 · 关键词
permnoPERMNO
CRSP Permanent Issue Identifier
identifier / identifiermsfStable issue-level CRSP identifier; with date forms the panel key
permnostockid
permcoPERMCO
CRSP Permanent Company Identifier
identifier / identifiermsfStable company-level CRSP identifier (one company can have multiple permnos)
permcocompany
dateDate
Month-end Trading Date
identifier / controlmsfLast trading date in month — panel time index
datemonthtime
cusipCurrent CUSIP
Current 8-digit CUSIP
identifier / identifiermsfCurrent 8-digit CUSIP — for merging with Compustat (also see ncusip for historical CUSIP)
cusip
ncusipHistorical CUSIP
CUSIP As-of-period
identifier / identifiermsfHistorical CUSIP for the issue at this date
ncusipcusiphistorical
tickerTicker
Ticker Symbol
identifier / identifiermsfStock ticker
ticker
exchcdExchange Code
Exchange Code
categorical / controlmsfListing exchange (1=NYSE, 2=AMEX, 3=NASDAQ)
exchangenysenasdaq
shrcdShare Code
Share Code
categorical / controlmsfShare class code (10/11 = US common stock; standard sample restriction)
share classcommon stock
siccdSIC Code
SIC Industry Code (CRSP)
categorical / controlmsfCRSP-assigned 4-digit SIC industry code
industrysic
prcPrice
Closing Price (signed)
continuous / iv,controlmsfLast closing price; CRSP encodes bid-ask midpoint as a negative number when no trade — take abs() before using
priceclose
retHolding Period Return
Monthly Holding Period Return (with dividend)
continuous / dv,ivmsfMonthly holding-period return inclusive of cash distributions
returnholding period
retxReturn Without Dividends
Monthly Return Excluding Dividends
continuous / dv,ivmsfMonthly return excluding cash distributions
returnex-dividend
volTrading Volume
Monthly Trading Volume (shares)
continuous / iv,controlmsfTotal monthly trading volume in shares
volumetrading
shroutShares Outstanding
Shares Outstanding (thousands)
continuous / iv,controlmsfShares outstanding in thousands; |prc|×shrout/1000 = market cap in $M
sharesoutstandingmarket cap
cfacprCumulative Price Adjustment
Cumulative Price Adjustment Factor
continuous / controlmsfUsed to adjust historical prices for splits
adjustmentsplitfactor
cfacshrCumulative Share Adjustment
Cumulative Share Adjustment Factor
continuous / controlmsfUsed to adjust historical share counts for splits
adjustmentsplit
dlretDelisting Return
Delisting Return
continuous / dv,ivmsedelistReturn inclusive of delisting payoff; non-missing only in delisting month
delistingreturn
dlstcdDelisting Code
Delisting Code
categorical / controlmsedelistReason for delisting (200s = merger, 400s = liquidation, 500s = exchange-driven, 100 = active)
delistingmergerbankruptcy

把变量直接用起来

变量百科是开放查询入口;实证向导把同样的码本接到代码生成里——上传你的 crsp_msf 数据,系统自动识别变量并套用对应的清洗规则、推荐研究设计、跑回归、出 Word 报告。