Skip to main content
Top
Published in: The Journal of Real Estate Finance and Economics 4/2020

12-01-2019

Using Revisions as a Measure of Price Index Quality in Repeat-Sales Models

Authors: Alex van de Minne, Marc Francke, David Geltner, Robert White

Published in: The Journal of Real Estate Finance and Economics | Issue 4/2020

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Repeat-sales indexes are the most widely used type of transaction based property price indexes. However, such indexes are particularly prone to revision. When a new period of transaction data becomes available and is used to update the repeat-sales model, all past index values can potentially be revised. These revisions are especially problematical for commercial real estate (as compared to housing), due to the relative scarcity of transaction data and the heterogeneity of the underlying properties. From a methodological perspective, the magnitude of the revisions is a particularly useful measure of the index quality, as it directly reflects both the precision of the index and its practical usefulness in economic and business applications. This paper focuses on index revisions in thin, commercial property markets, the type of market that is most challenging. We present multiple specifications of the repeat-sales model (both existing and new), seeking to reduce revisions. We are able to reduce overall index revisions by more than 50%, compared to more traditional repeat-sales models.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Appendix
Available only for authorised users
Footnotes
1
Both use a slightly different setup than the classical (Bailey et al. 1963) method. The HPI uses a WLS approach to estimate the repeat-sales model as proposed by Case and Shiller (1987). The Moody’s/RCA CPPI uses frequency conversion as proposed by Bokhari and Geltner (2012). Since September 2017 the RCA CPPIs employ a methodology based on the current paper.
 
2
Note that βi is specified as a pair fixed effect in this paper, as this the most widely accepted form in both academic literature and in industry. However, it could also be specified as a property fixed effect. So if a property is sold 3 times, we ‘break it up’ into 2 pairs, instead of seeing it as 1 property. See Francke (2010) for the (small) difference in specification.
 
3
The metro areas are defined by Real Capital Analytics.
 
4
In fact, we also ran some additional indexes as a robustness check in “Robustness”. As such, the total number of indexes we estimate is closer to 5,000.
 
5
For example, consider Fig. 3. In both markets the crisis is clearly visible. Although the amplitude and the timing for especially the recovery is different. The SFO index started dropping 2 quarters before the LAI index. Subsequently, offices in LAI went down approximately 50%, whereas apartments in SFO ‘only’ decreased 20% in value. However, arguably the biggest difference is that at the end of the sample, the LAI index is still not above its previous peak, whereas the SFO index reached the previous peak already in 2013.
 
6
A partial exception is Gatzlaff and Geltner (1998) which estimated repeat-sales indexes of Florida commercial property based on a ridge regression methodology reflecting an a priori assumption of positively correlated ‘true’ returns.
 
7
Note that Francke and van de Minne (2017) use a similar setup. Their hierarchical repeat-sales (HRS) model has multiple stochastic log price trends with a hierarchical additive structure: One common trend using information from all sectors and markets, and target market specific trends estimated as deviations from the common trend. In the present approach we simply estimate the aggregate indexes separately and use them as explanatory variables in the granular index estimation. This reduces computing time considerably. Moreover, we found that in some cases of data scarcity, the HRS can result in highly correlated indexes.
 
8
We do provide some of the revision statistics for the aggregate indexes in “Robustness”.
 
9
In an earlier version we experimented with transaction volume, regional GDP, and unemployment in the state equation, and allowed the variance of the signal and noise component to be time-varying. For the sake of brevity and readability these results have not been included in the paper. Moreover, the results did not improve much, or not at all.
 
10
The effective sample size (ESS) is computed as follows; \( \text {ESS} = {n \over 1 + 2 {\sum }_{k = 1}^{\infty } \rho (k)} , \) where n is the number of samples and ρ(k) is the correlation at lag k. One gets a different ESS for every variable. Thus, the difference between the effective sample size and the actual sample size, gives one a measure on how independent the draws are.
 
11
The intuition behind the \(\bar {R}\) is that the chains should look alike, if the chains converged. First, the Gelman-Rubin diagnostic is computed, which calculates both the between-chain and the within-chain variance. The \(\hat {R}\) is essentially the fraction between the two, see Gelman and Rubin (1992) and Brooks and Gelman (1998) for more details. A value of 1.1 is usually used as an upper limit.
 
Literature
go back to reference Abraham, J.M., & Schauman, W.S. (1991). New evidence on home prices from Freddie Mac repeat sales. Real Estate Economics, 19(3), 333–352. Abraham, J.M., & Schauman, W.S. (1991). New evidence on home prices from Freddie Mac repeat sales. Real Estate Economics, 19(3), 333–352.
go back to reference Bailey, M.J., Muth, R.F., Nourse, H.O. (1963). A regression method for real estate price index construction. Journal of the American Statistical Association, 58, 933–942. Bailey, M.J., Muth, R.F., Nourse, H.O. (1963). A regression method for real estate price index construction. Journal of the American Statistical Association, 58, 933–942.
go back to reference Barkham, R., & Geltner, D.M. (1995). Price discovery in American and British property markets. Real Estate Economics, 23(1), 21–44. Barkham, R., & Geltner, D.M. (1995). Price discovery in American and British property markets. Real Estate Economics, 23(1), 21–44.
go back to reference Betancourt, M., & Girolami, M. (2015). Hamiltonian Monte Carlo for hierarchical models. Current trends in Bayesian methodology with applications, 79, 30. Betancourt, M., & Girolami, M. (2015). Hamiltonian Monte Carlo for hierarchical models. Current trends in Bayesian methodology with applications, 79, 30.
go back to reference Bokhari, S., & Geltner, D. (2012). Estimating real estate price movements for high frequency tradable indexes in a scarce data environment. The Journal of Real Estate Finance and Economics, 45(2), 522–543. Bokhari, S., & Geltner, D. (2012). Estimating real estate price movements for high frequency tradable indexes in a scarce data environment. The Journal of Real Estate Finance and Economics, 45(2), 522–543.
go back to reference Bokhari, S., & Geltner, D.M. (2011). Loss aversion and anchoring in commercial real estate pricing: empirical evidence and price index implications. Real Estate Economics, 39(4), 635–670. Bokhari, S., & Geltner, D.M. (2011). Loss aversion and anchoring in commercial real estate pricing: empirical evidence and price index implications. Real Estate Economics, 39(4), 635–670.
go back to reference Bourassa, S.C., Cantoni, E., Hoesli, M. (2013). Robust repeat sales indexes. Real Estate Economics, 41(3), 517–541. Bourassa, S.C., Cantoni, E., Hoesli, M. (2013). Robust repeat sales indexes. Real Estate Economics, 41(3), 517–541.
go back to reference Brooks, S.P., & Gelman, A. (1998). General methods for monitoring convergence of iterative simulations. Journal of Computational and Graphical Statistics, 7(4), 434–455. Brooks, S.P., & Gelman, A. (1998). General methods for monitoring convergence of iterative simulations. Journal of Computational and Graphical Statistics, 7(4), 434–455.
go back to reference Carpenter, B., Gelman, A., Hoffman, M., Lee, D., Goodrich, B., Betancourt, M., Brubaker, M.A., Guo, J., Li, P., Riddell, A. (2017). Stan: a probabilistic programming language. Journal of Statistical Software, 76(1), 1–32. Carpenter, B., Gelman, A., Hoffman, M., Lee, D., Goodrich, B., Betancourt, M., Brubaker, M.A., Guo, J., Li, P., Riddell, A. (2017). Stan: a probabilistic programming language. Journal of Statistical Software, 76(1), 1–32.
go back to reference Case, K.E., & Shiller, R.J. (1987). Prices of single family homes since 1970: new indexes for four cities. New England Economic Review, 45–56. Case, K.E., & Shiller, R.J. (1987). Prices of single family homes since 1970: new indexes for four cities. New England Economic Review, 45–56.
go back to reference Case, K.E., & Shiller, R.J. (1989). The efficiency of the market of single-family homes. The American Economic Review, 79, 125–137. Case, K.E., & Shiller, R.J. (1989). The efficiency of the market of single-family homes. The American Economic Review, 79, 125–137.
go back to reference Case, K.E., & Shiller, R.J. (1990). Forecasting prices and excess returns in the housing market. Real Estate Economics, 18(3), 253–273. Case, K.E., & Shiller, R.J. (1990). Forecasting prices and excess returns in the housing market. Real Estate Economics, 18(3), 253–273.
go back to reference Clapham, E., Englund, P., Quigley, J.M., Redfearn, C.L. (2006). Revisiting the past and settling the score: index revision for house price derivatives. Real Estate Economics, 34, 275–302. Clapham, E., Englund, P., Quigley, J.M., Redfearn, C.L. (2006). Revisiting the past and settling the score: index revision for house price derivatives. Real Estate Economics, 34, 275–302.
go back to reference Clapp, J.M., & Giaccotto, C. (1999). Revisions in repeat-sales price indexes: here today, gone tomorrow. Real Estate Economics, 27, 79–104. Clapp, J.M., & Giaccotto, C. (1999). Revisions in repeat-sales price indexes: here today, gone tomorrow. Real Estate Economics, 27, 79–104.
go back to reference Clements, M.P., & Galvão, A. B. (2017). Predicting early data revisions to us gdp and the effects of releases on equity markets. Journal of Business & Economic Statistics, 35, 1–18. Clements, M.P., & Galvão, A. B. (2017). Predicting early data revisions to us gdp and the effects of releases on equity markets. Journal of Business & Economic Statistics, 35, 1–18.
go back to reference De Wit, E.R., Englund, P., Francke, M.K. (2013). Price and transaction volume in the Dutch housing market. Regional Science and Urban Economics, 43(2), 220–241. De Wit, E.R., Englund, P., Francke, M.K. (2013). Price and transaction volume in the Dutch housing market. Regional Science and Urban Economics, 43(2), 220–241.
go back to reference Deng, Y., & Quigley, J.M. (2008). Index revision, house price risk, and the market for house price derivatives. The Journal of Real Estate Finance and Economics, 37 (3), 191–209. Deng, Y., & Quigley, J.M. (2008). Index revision, house price risk, and the market for house price derivatives. The Journal of Real Estate Finance and Economics, 37 (3), 191–209.
go back to reference Durbin, J., & Koopman, S.J. (2012). Time series analysis by state space methods Vol. 2. Oxford: Oxford Univ Press. Durbin, J., & Koopman, S.J. (2012). Time series analysis by state space methods Vol. 2. Oxford: Oxford Univ Press.
go back to reference Fisher, J., Gatzlaff, D., Geltner, D.M., Haurin, D. (2003). Controlling for the impact of variable liquidity in commercial real estate price indices. Real Estate Economics, 31(2), 269–303. Fisher, J., Gatzlaff, D., Geltner, D.M., Haurin, D. (2003). Controlling for the impact of variable liquidity in commercial real estate price indices. Real Estate Economics, 31(2), 269–303.
go back to reference Francke, M.K. (2010). Repeat sales index for thin markets: a structural time series approach. Journal of Real Estate Finance and Economics, 41, 24–52. Francke, M.K. (2010). Repeat sales index for thin markets: a structural time series approach. Journal of Real Estate Finance and Economics, 41, 24–52.
go back to reference Francke, M.K. (2017). Repeat sales models, holding periods and index revision. The Hoyt Group; May 2017 50th Anniversary Program Presentations. Francke, M.K. (2017). Repeat sales models, holding periods and index revision. The Hoyt Group; May 2017 50th Anniversary Program Presentations.
go back to reference Francke, M.K., & De Vos, A.F. (2000). Efficient computation of hierarchical trends. Journal of Business and Economic Statistics, 18, 51–57. Francke, M.K., & De Vos, A.F. (2000). Efficient computation of hierarchical trends. Journal of Business and Economic Statistics, 18, 51–57.
go back to reference Francke, M.K., & van de Minne, A. (2017). The hierarchical repeat sales model for granular commercial real estate and residential price indices. The Journal of Real Estate Finance and Economics, 55(4), 511–532. Francke, M.K., & van de Minne, A. (2017). The hierarchical repeat sales model for granular commercial real estate and residential price indices. The Journal of Real Estate Finance and Economics, 55(4), 511–532.
go back to reference Gatzlaff, D.H., & Geltner, D.M. (1998). A transaction-based index of commercial property and its comparison to the NCREIF index. Real Estate Finance, 15(1), 7–22. Gatzlaff, D.H., & Geltner, D.M. (1998). A transaction-based index of commercial property and its comparison to the NCREIF index. Real Estate Finance, 15(1), 7–22.
go back to reference Gelman, A., & Rubin, D.B. (1992). Inference from iterative simulation using multiple sequences. Statistical Science, 7, 457–72. Gelman, A., & Rubin, D.B. (1992). Inference from iterative simulation using multiple sequences. Statistical Science, 7, 457–72.
go back to reference Geltner, D., & Mei, J. (1995). The present value model with time-varying discount rates: implications for commercial property valuation and investment decisions. The Journal of Real Estate Finance and Economics, 11(2), 119–135. Geltner, D., & Mei, J. (1995). The present value model with time-varying discount rates: implications for commercial property valuation and investment decisions. The Journal of Real Estate Finance and Economics, 11(2), 119–135.
go back to reference Geltner, D.M., Francke, M.K., Shimizu, C., Fenwick, D., Baran, D. (2017). Commercial property price indicators: sources, methods and issues. Eurostat. Geltner, D.M., Francke, M.K., Shimizu, C., Fenwick, D., Baran, D. (2017). Commercial property price indicators: sources, methods and issues. Eurostat.
go back to reference Geltner, D.M., MacGregor, B.D., Schwann, G.M. (2003). Appraisal smoothing and price discovery in real estate markets. Urban Studies, 40(5-6), 1047–1064. Geltner, D.M., MacGregor, B.D., Schwann, G.M. (2003). Appraisal smoothing and price discovery in real estate markets. Urban Studies, 40(5-6), 1047–1064.
go back to reference Geltner, D.M., Miller, N.G., Clayton, J., Eichholtz, P.M.A. (2014). Commercial real estate, analysis & investments Vol. 4. Boston: Cengage Learning. Geltner, D.M., Miller, N.G., Clayton, J., Eichholtz, P.M.A. (2014). Commercial real estate, analysis & investments Vol. 4. Boston: Cengage Learning.
go back to reference Genesove, D., & Mayer, C. (2001). Loss aversion and seller behavior: evidence from the housing market. The Quarterly Journal of Economics, 116(4), 1233–1260. Genesove, D., & Mayer, C. (2001). Loss aversion and seller behavior: evidence from the housing market. The Quarterly Journal of Economics, 116(4), 1233–1260.
go back to reference Goetzmann, W.N. (1992). The accuracy of real estate indices: repeat sale estimators. Journal of Real Estate Finance and Economics, 5, 5–53. Goetzmann, W.N. (1992). The accuracy of real estate indices: repeat sale estimators. Journal of Real Estate Finance and Economics, 5, 5–53.
go back to reference Guo, X., Zheng, S., Geltner, D.M., Liu, H. (2014). A new approach for constructing home price indices: the pseudo repeat sales model and its application in China. Journal of Housing Economics, 25, 20–38. Guo, X., Zheng, S., Geltner, D.M., Liu, H. (2014). A new approach for constructing home price indices: the pseudo repeat sales model and its application in China. Journal of Housing Economics, 25, 20–38.
go back to reference Harvey, A. (1989). Forecasting structural time series models and the kalman filter. Cambridge: Cambridge University Press. Harvey, A. (1989). Forecasting structural time series models and the kalman filter. Cambridge: Cambridge University Press.
go back to reference Hegde, S.P., & McDermott, J.B. (2003). The liquidity effects of revisions to the S&P 500 index: an empirical analysis. Journal of Financial Markets, 6(3), 413–459. Hegde, S.P., & McDermott, J.B. (2003). The liquidity effects of revisions to the S&P 500 index: an empirical analysis. Journal of Financial Markets, 6(3), 413–459.
go back to reference Hoffman, M.D., & Gelman, A. (2014). The no-U-turn sampler: adaptively setting path lengths in Hamiltonian Monte Carlo. Journal of Machine Learning Research, 15 (1), 1593–1623. Hoffman, M.D., & Gelman, A. (2014). The no-U-turn sampler: adaptively setting path lengths in Hamiltonian Monte Carlo. Journal of Machine Learning Research, 15 (1), 1593–1623.
go back to reference Koehler, E., Brown, E., Haneuse, S.J.P.A. (2009). On the assessment of Monte Carlo error in simulation-based statistical analyses. The American Statistician, 63(2), 155–162. Koehler, E., Brown, E., Haneuse, S.J.P.A. (2009). On the assessment of Monte Carlo error in simulation-based statistical analyses. The American Statistician, 63(2), 155–162.
go back to reference Link, W.A., & Eaton, M.J. (2012). On thinning of chains in MCMC. Methods in Ecology and Evolution, 3(1), 112–115. Link, W.A., & Eaton, M.J. (2012). On thinning of chains in MCMC. Methods in Ecology and Evolution, 3(1), 112–115.
go back to reference Lunn, D., Jackson, C., Best, N., Thomas, A., Spiegelhalter, D. (2013). The BUGS Book; A practical introduction to bayesian analysis. Boca Raton: CRC Press. Lunn, D., Jackson, C., Best, N., Thomas, A., Spiegelhalter, D. (2013). The BUGS Book; A practical introduction to bayesian analysis. Boca Raton: CRC Press.
go back to reference McMillen, D.P., & Thorsnes, P. (2006). Housing renovations and the quantile repeat-sales price index. Real Estate Economics, 34(4), 567–584. McMillen, D.P., & Thorsnes, P. (2006). Housing renovations and the quantile repeat-sales price index. Real Estate Economics, 34(4), 567–584.
go back to reference Plummer, M. (2003). JAGS: a Program for analysis of Bayesian graphical models using Gibbs sampling. In: Proceedings of the 3rd internation workshop on distributed statistical computing, pp. 124. Plummer, M. (2003). JAGS: a Program for analysis of Bayesian graphical models using Gibbs sampling. In: Proceedings of the 3rd internation workshop on distributed statistical computing, pp. 124.
go back to reference Quan, D.C., & Quigley, J.M. (1991). Price formation and the appraisal function in real estate markets. The Journal of Real Estate Finance and Economics, 4(2), 127–146. Quan, D.C., & Quigley, J.M. (1991). Price formation and the appraisal function in real estate markets. The Journal of Real Estate Finance and Economics, 4(2), 127–146.
go back to reference Schwann, G.M. (1998). A real estate price index for thin markets. Journal of Real Estate Finance and Economics, 16, 269–287. Schwann, G.M. (1998). A real estate price index for thin markets. Journal of Real Estate Finance and Economics, 16, 269–287.
go back to reference Shiller, R.J. (1981). Do stock prices move too much to be justified by subsequent changes in dividends? American Economic Review, 71, 421–436. Shiller, R.J. (1981). Do stock prices move too much to be justified by subsequent changes in dividends? American Economic Review, 71, 421–436.
go back to reference Shiller, R.J. (1993). Macro Markets, Creating institutions for managing society’s largest economic risks. Oxford: Oxford University Press. Shiller, R.J. (1993). Macro Markets, Creating institutions for managing society’s largest economic risks. Oxford: Oxford University Press.
go back to reference Shrestha, M.L., & Marini, M. (2013). Quarterly GDP revisions in G-20 countries: evidence from the 2008 financial crisis. IMF Working Paper (13/60). Shrestha, M.L., & Marini, M. (2013). Quarterly GDP revisions in G-20 countries: evidence from the 2008 financial crisis. IMF Working Paper (13/60).
go back to reference Vehtari, A., Gelman, A., Gabry, J. (2016). Practical Bayesian model evaluation using leave-one-out cross-validation and WAIC. Statistics and Computing, 27, 1–20. Vehtari, A., Gelman, A., Gabry, J. (2016). Practical Bayesian model evaluation using leave-one-out cross-validation and WAIC. Statistics and Computing, 27, 1–20.
go back to reference Watanabe, S. (2010). Asymptotic equivalence of Bayes cross validation and widely applicable information criterion in singular learning theory. Journal of Machine Learning Research, 11(Dec), 3571–3594. Watanabe, S. (2010). Asymptotic equivalence of Bayes cross validation and widely applicable information criterion in singular learning theory. Journal of Machine Learning Research, 11(Dec), 3571–3594.
go back to reference Yu, K., & Moyeed, R.A. (2001). Bayesian quantile regression. Statistics & Probability Letters, 54(4), 437–447. Yu, K., & Moyeed, R.A. (2001). Bayesian quantile regression. Statistics & Probability Letters, 54(4), 437–447.
Metadata
Title
Using Revisions as a Measure of Price Index Quality in Repeat-Sales Models
Authors
Alex van de Minne
Marc Francke
David Geltner
Robert White
Publication date
12-01-2019
Publisher
Springer US
Published in
The Journal of Real Estate Finance and Economics / Issue 4/2020
Print ISSN: 0895-5638
Electronic ISSN: 1573-045X
DOI
https://doi.org/10.1007/s11146-018-9692-x

Other articles of this Issue 4/2020

The Journal of Real Estate Finance and Economics 4/2020 Go to the issue