Hostname: page-component-76d6cb85b7-jhrpq Total loading time: 0 Render date: 2026-07-13T06:38:10.846Z Has data issue: false hasContentIssue false

Rewriting CRSP’s History: Impact of Altered Monthly Returns on Asset Pricing

Published online by Cambridge University Press:  24 March 2026

Patrick Schwarz
Affiliation:
University of Liège HEC Liège patrick.schwarz@uliege.be
Dominik Walter*
Affiliation:
University of Konstanz
Patrick Weiss
Affiliation:
Reykjavik University patrickw@ru.is
*
d.walter@uni-konstanz.de (corresponding author)
Rights & Permissions [Opens in a new window]

Abstract

In January 2025, CRSP discontinued the existing stock tape used in many published papers. This transition rewrites 9.62% of monthly returns by more than 1 basis point (bp), primarily due to a change in the dividend reinvestment assumption. Analyzing the impact for a comprehensive set of premia in several thousand sorting specifications reveals that, on average, 11.43% of all monthly long-short returns differ by more than 10 bp—especially in early periods, NBER recessions, and return-based sorts. Reassuringly, average premia and their significance remain largely unaffected, suggesting CRSP changes mainly introduce unsystematic variation without altering key asset pricing conclusions.

Information

Type
Research Article
Creative Commons
Creative Common License - CCCreative Common License - BY
This is an Open Access article, distributed under the terms of the Creative Commons Attribution licence (http://creativecommons.org/licenses/by/4.0), which permits unrestricted re-use, distribution and reproduction, provided the original article is properly cited.
Copyright
© The Author(s), 2026. Published by Cambridge University Press on behalf of the Michael G. Foster School of Business, University of Washington
Figure 0

FIGURE 1 Articles Conducting a CRSP-Based Return AnalysisFigure 1 shows the total number of published articles in five leading finance journals (Top5, i.e., JF, JFE, RFS, JFQA, and RoF) along with the absolute and relative number of published articles using CRSP return data. The sample period is from 2000 to 2024. An article is counted as conducting a CRSP-based return analysis if the article contains words (e.g., CRSP, return, portfolio sort, among others as described in Section IA.I of the Supplementary Material) indicating that return data from CRSP has been used in an empirical analysis.

Figure 1

TABLE 1 Differences in Monthly Stock Returns

Figure 2

FIGURE 2 Decomposing Monthly Return Differences Between CRSP TapesFigure 2 shows the share of absolute return differences between the old (SIZ) and new (CIZ) CRSP tape exceeding 0.1 bp that can be explained by changing the reinvestment assumption, trading gaps/IPO months, and adjusting delisting returns. We compute these shares as follows: First, we compute how many of the monthly return differences can be explained by compounding the daily returns of the old CRSP tape for months without missing previous month-end prices and no recorded delistings (“Diff. Due to Reinvestment”). Second, we calculate how many of the monthly return differences can be reconciled by compounding daily returns also for months with missing month-end prices from the previous month and no recorded delistings (“Diff. Due to Trading Gaps + IPO Months”). Third, we compute how many of the monthly return differences can be explained by additionally adjusting delisting returns in the old tape (“Diff. Due to Delistings”). Lastly, we show the share of monthly return differences that we cannot explain (“Diff Remaining”) after compounding daily returns within all months and adjusting delisting returns. The sample covers all common stocks from AMEX, NYSE, and NASDAQ from 1926 to 2023. All relative frequencies are in percent, and the vertical-axis scales differ for illustrative purposes.

Figure 3

FIGURE 3 Flowchart of Construction Decisions in Portfolio SortsFigure 3 shows the paths based on 14 construction decisions (forks) for a portfolio sort until the premium is estimated. The first seven forks concern the sample construction: Excluding small stocks dependent on market equity quantiles (No, smaller than p(10) or p(20)), financials (included (Inc.) or excluded (Exc.)), utilities (included or excluded), firm-months with negative book equity (included or excluded), firm-months with negative earnings (included or excluded), requiring 2 years of minimum listing as in Fama and French (1992) (Yes or No), and excluding stock prices smaller than $1, $5, or none. The subsequent seven forks belong to the portfolio construction: The lag of the sorting variables (1 month (1 M.), 3 months (3 M.), 6 months (6 M.), or a Fama and French (1992) lag (FF)), the portfolio rebalancing (monthly (Mon.) or annually (Ann.)), the number of main portfolios (5 or 10), the sorting method (single sorts (Sing.), dependent (Dep.), or independent double sorts (Ind.)), the number of secondary portfolios for double sorts (2 or 5), the exchanges for breakpoints (all stocks (All) or NYSE listed stocks (NYSE)), and the weighting scheme (equal-weights (EW) or value-weights based on the market capitalization (VW)). Note that we only allow for a sorting variable lag of 3 months, 6 months, and as in Fama and French (1992) for sorting variables updated yearly. For sorting variables updated monthly, we allow for sorting variable lags of 1, 3, and 6 months. Sorting variables updated quarterly can have a sorting variable lag of 3 or 6 months. Also, the choice to rebalance portfolios annually is naturally only available for sorting variables updated yearly and not for those updated monthly or quarterly. The color saturation indicates how often the 109 papers analyzed by Hou et al. (2020) implemented each choice.

Figure 4

TABLE 2 Differences in Monthly Long-Short Portfolio Returns

Figure 5

TABLE 3 Differences in Return Premia

Figure 6

TABLE 4 Significance of Premia Between Tapes

Figure 7

FIGURE 4 Cross-Sectional Correlations for Components of Return ChangesFigure 4 shows the time series of cross-sectional correlations between the payout yield and the compounded return from the ex-date to the end of the ex-date month. We compute these cross-sectional correlations in each month based on the observations that have absolute return differences exceeding 0.1 bp between monthly returns from the new (CIZ) and the old (SIZ) tape of CRSP. The red line shows the 12-month rolling average of these cross-sectional correlations, and the black line shows the 36-month rolling average.

Figure 8

TABLE A.1 Distribution of the Trading Days Between the Payment Date, the Ex-Date, and the End of the Ex-Date Month

Figure 9

TABLE B.1 Differences in CRSP Items for Monthly and Daily Stock Data

Figure 10

FIGURE B.1 Dissecting Reinvestment Return DifferencesFigure B.1 shows the average absolute return differences in percent (“Ret. Diff.”) in each of the 25 double-sorted buckets with increasing color intensity. We assign observations with monthly return differences exceeding 0.1 bp between the new (CIZ) and old (SIZ) CRSP tape into quintiles based on their payout yield and the stock’s absolute compounded return from the ex-date to the month-end (“Reinvestment Return of Payouts”). We replace missing daily returns for the computation of the reinvestment return with zero. Based on these independent double sorts, we assign stocks into 25 buckets and depict the absolute return differences for each bucket by color intensity. We show the mean values for the payout yield (horizontal axis) and reinvestment return of payouts (vertical axis) for each bucket in percent. We include all common stocks listed on AMEX, NYSE, and NASDAQ from 1926 until 2023.

Figure 11

TABLE C.1 List of 68 Sorting Variables

Figure 12

TABLE D.1 Significance of Premia Between Tapes for Each Sorting Variable

Figure 13

TABLE E.1 Significance of Cyclicality Coefficients Across All Paths

Figure 14

TABLE E.2 Significance of Cyclicality Coefficients for a Specific Path

Figure 15

TABLE F.1 Differences in Return Premia—Overview of Comparisons

Figure 16

TABLE F.2 Differences in the Significance of Premia—Overview of Comparisons

Supplementary material: File

Schwarz et al. supplementary material

Schwarz et al. supplementary material
Download Schwarz et al. supplementary material(File)
File 1 MB