CRSP Useful Variables for Financial Analysis
undefined
CRSP useful variables
April 15, 2020
WHARTON
RESEARCH
DATA
SERVICES
Wharton Research Data Services
2
CRSP useful variables
•
“Negative” Prices
•
Adjusting Prices and Shares for Splits
•
Returns with Dividends
•
Delisting Returns
•
Market Capitalization.
1. “Negative” Prices
“Negative” Prices
Wharton Research Data Services
4
2. Adjusting Prices and
Shares for Splits
Adjusting Prices and Shares for Splits
Wharton Research Data Services
6
Adjusted prices
=
abs(PRC)
/
CFACPR
Adjusted shares
=
SHROUT
*
CFACSHR
C
F
A
C
S
H
R
i
s
n
o
t
a
l
w
a
y
s
e
q
u
a
l
t
o
C
F
A
C
P
R
.
T
h
i
s
c
a
n
b
e
c
a
u
s
e
d
b
y
l
e
s
s
c
o
m
m
o
n
d
i
s
t
r
i
b
u
t
i
o
n
e
v
e
n
t
s
,
s
p
i
n
-
o
f
f
s
,
a
n
d
r
i
g
h
t
s
.
3. Returns with
Dividends
Return with Dividends
Wharton Research Data Services
8
4. CRSP Delisting
Returns
CRSP Delisting Returns
Wharton Research Data Services
10
10
Listed Period
Delisted Period
Delisting Date
dlret
dlamt
Delisting Returns: daily vs monthly
Wharton Research Data Services
11
11
Daily Data
Monthly Data
Missing
Delisting Returns
Wharton Research Data Services
12
12
What to do?
Delisting Returns and Their Effect on Accounting-Based Market
Anomalies (Beaver, McNichols, Price) JAE, 2007.
•
Nothing (assume dlret=0). Bias.
•
-100%
•
-30%
•
Use average DLRET from non-missing three-digit delisting
cases.
* From daily crsp files
5. Market Capitalization
Market Cap …
Wharton Research Data Services
14
14
Wharton Research Data Services
15
15
Summary
•
“Negative Prices”
•
Adjusting Prices and Shares for Splits
•
Returns with Dividends
•
Delisting Returns
•
Market Capitalization.
Welcome to this WRDS Presentation about Coverage of CRSP Stock data…
Explore CRSP useful variables for analyzing financial data, including negative prices, adjusting prices and shares for splits, returns with dividends, delisting returns, and more. Learn about adjusting prices and shares for splits, delisting dates, and daily vs. monthly delisting returns. Gain insights into how these variables can impact your financial research and analysis.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
WHARTON RESEARCH DATASERVICES CRSP useful variables April 15, 2020
CRSP useful variables Negative Prices Adjusting Prices and Shares for Splits Returns with Dividends Delisting Returns Market Capitalization. 2 Wharton Research Data Services
Negative Prices 4 Wharton Research Data Services
2. Adjusting Prices and Shares for Splits
Adjusting Prices and Shares for Splits Adjusted prices = abs(PRC) / CFACPR date TICKER PRC CFACPR 20140603 AAPL 637.54 7 Adjusted shares = SHROUT * CFACSHR 20140604 AAPL 644.82 7 20140605 AAPL 647.35 7 20140606 AAPL 645.57 7 CFACSHR is not always equal to CFACPR. This can be caused by less common distribution events, spin-offs, and rights. 20140609 AAPL 93.70 1 20140610 AAPL 94.25 1 20140611 AAPL 93.86 1 20140612 AAPL 92.29 1 6 Wharton Research Data Services
3. Returns with Dividends
Return with Dividends RET (t) = ?????? ? +??????(?)/??????(?) ??????(? 1) 1 8 Wharton Research Data Services
4. CRSP Delisting Returns
CRSP Delisting Returns Delisting Date dlamt dlret Delisted Period Listed Period 10 Wharton Research Data Services
Delisting Returns: daily vs monthly Daily Data PERMNO 27474 20150529 24.80 0.3% 27474 20150601 24.67 -0.5% 27474 20150602 24.95 1.1% 27474 20150603 24.91 -0.2% Date PRC RET PERMNO Date Delisting Code 241 Delisting Amount 24.98 Delisting Payment Date 20150608 Delisting Return 8.2% -7.1% 27474 20150604 23.13 27474 20150605 23.09 -0.2% 27474 20150605 Monthly Data PERMNO Date PRC RET Delisting Code Amount After Delisting Date of Delisting Payment Delisting Return 27474 20150529 24.80 PERMNO Date 3.0% 27474 20150630 27474 20150630 241 24.98 20150608 0.7% 11 Wharton Research Data Services
Missing Delisting Returns Type Of Delisting* Percentage is missing Missing Non-Missing 1% M&A (dlstcd=200s) 96 13,194 Dropped (Price below acceptable level, Bankruptcy, Insolvent) (dlstcd=500s) 30% 3,094 7,118 12% Issue Liquidated (dlstcd=400s) 190 1,418 Issue Exchanged (dlstcd=300s) 1% 8 1,010 * From daily crsp files What to do? Delisting Returns and Their Effect on Accounting-Based Market Anomalies (Beaver, McNichols, Price) JAE, 2007. Nothing (assume dlret=0). Bias. -100% -30% Use average DLRET from non-missing three-digit delisting cases. 12 Wharton Research Data Services
Market Cap MarketCap (t) = [ abs ??? ? /??????(?) ] x [ SHROUT ? x ???????(?) ] In Most of the cases MarketCap (t) = abs ??? ? x SHROUT ? 14 Wharton Research Data Services
Summary Negative Prices Adjusting Prices and Shares for Splits Returns with Dividends Delisting Returns Market Capitalization. 15 Wharton Research Data Services
