Download Page for Daniel, Grinblatt, Titman, and Wermers (DGTW; 1997) Characteristic-Based Benchmarks
Monthly Benchmark Returns & Annually Reconstituted Benchmark Portfolio Assignment Identifiers
-- Covering all NYSE/AMEX/Nasdaq (United States) Stocks From 1975 to 2007 Having Complete Data (for a Given Year) in the CRSP/Compustat Merged Database --
(Excludes REITS, Closed-End Funds, ADRs, Canadian Firms (and Other Non-U.S. Incorporated Firms), Primes and Scores, and HOLDRs)
Maintained by Russ Wermers
University of Maryland
Updated September 2, 2008
I. Rules for Use of These Data
A) You must have a legal subscription to the CRSP/Compustat Merged Database from the Center for Research in Security Prices (CRSP)
B) You must cite Daniel, Grinblatt, Titman, and Wermers (1997) and Wermers (2004) (both available below) in your working papers and published papers that use any of these data
C) You must place the following text in a footnote of your paper (to help other researchers find the benchmarks): "The DGTW benchmarks are available via http://www.smith.umd.edu/faculty/rwermers/ftpsite/Dgtw/coverpage.htm"
- If you cannot comply with the above, then please exit this page. Otherwise, your downloading of these data signifies your acceptance of these terms -
- I hope these data are helpful for your research! -
II. Notes About Recent Changes to DGTW Procedure From Prior Years
1. All stock returns are now delisting-adjusted, using CRSP delisting returns--when available. This assumes, therefore, that a stock is held through the delisting event and is not sold (even if the delisting is publicly known beforehand). In the case of a performance-related delisting without a CRSP delisting return, I use the procedures recommended by Shumway (1997, 1999).
2. All CRSP/Compustat information is drawn from the "Fundamentals" file of CRSP/Compustat, with the exception of Post-Retirement Benefit Asset (PRBA), which is drawn from the Compustat "Pension" tables (available via WRDS).
III. Description of Data & Hyperlinks to Datasets (All Excel Datasets)
These data cover the period 1975 to 2007 (inclusive). The benchmark assignments are conducted as described on page 7 of Wermers (2004), which also refers to the DGTW (1997) paper. The main innovation in Wermers (2004) is that the book-to-market ratio is industry-adjusted in a different way--please carefully read that page to see the details. Also, note that industry portfolios are formed using the 48 Fama-French industry classifications available on Ken French's website (http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/). Benchmark assignments are reconstituted each June 30th (not quarterly, as in one version shown in the Wermers (2004) paper), starting June 30, 1975 and ending June 30, 2007.
1) Benchmark Returns for 125 DGTW Portfolios (1975 to 2007)--Note that each row has benchmark returns that begin during July of the sort year, then continue through June of the following year. For example, all rows (portfolios) (e.g., size_jun=1, book_m_jun=1, and mom_jun=1) corresponding to the year "1975" have the July, August, September, October, November, and December 1975 benchmark returns, followed by the January, February, March, April, May, and June 1976 benchmark returns. Then, proceed to the 1976 row for the same benchmark cell (e.g., size_jun=1, book_m_jun=1, and mom_jun=1) to obtain the July-December 1976 and January-June 1977 benchmark returns for that cell (which is now populated with potentially different stocks).
2) Stock Assignments to Benchmark Portfolios (June 30 of Each Year, 1975 to 2007) -- All in One Excel 2007 Dataset !
- Stock Assignments (All in One Excel 2007 Dataset)
- Stock Assignments (In One .CSV Dataset)
Defined as Maximum Value, in Each Cell During Each Year, of:
i) Market Capitalization (in $Thousands)
ii) Industry-Adjusted Book-to-Market Ratio (as Defined in Wermers (2004), Page 7)
iii) Book-to-Market Ratio (Unadjusted, for Reference Only)
iv) Momentum (Average Monthly Return During June 1 of Year t-1 to May 31 of Year t)
4) Total Number of NYSE Stocks in Each Cell During Each Year
5) Total Number of NYSE/AMEX/Nasdaq Stocks in Each Cell During Each Year