**July 28, 2020** – Data updated through May 2020

Detroit data not available for March-May yet.

**The Case-Shiller Home Price Index is the most accurate way to look at house price appreciation in a city, between cities and nationally.**

The price of houses in January 2000 is given the value of 100. So a Case-Shiller value of 200 means house prices have doubled since January 2000.

Using an index of house prices instead of the actual dollar prices makes it easier to compare house price appreciation between the 20 cities.

## The Data

Case-Shiller has data for **16 of the 20 largest metropolitan areas** in the United States. Data isn’t available for, or Case-Shiller doesn’t follow, Houston (#5), Philadelphia (#8), Riverside (#13) or St. Louis (#20). The Case-Shiller graphics on this page show house price data for the rest of the top 20 metros plus Charlotte (#23), Portland (#25), Las Vegas (#28), Cleveland (#33) and the USA as a whole.

The Case-Shiller data is slow. It runs almost **2 months behind**. For example, December data comes out at the end of February.

In addition, the data is a **3-month moving average** so that December data that comes out at the end of February is really the average for October-December. Some might call it November data. Or you could call it a rolling quarterly index.

So you could say Case-Shiller data **really runs 3 months behind**. More discussion of the Case-Shiller data near the bottom of this page.

## Index Baseline Year = 2000

Note. Not all cities have data all the way back to 1987. Phoenix and Minneapolis data start in 1989, Seattle starts in 1990, Atlanta and Detroit start in 1991, and Dallas data only starts in 2000.

Note: I applied the Consumer Price Index for All Urban Consumers (CPI-U) to the Case-Shiller Home Price Index.

## Move Baseline Year to 1995

**The Great Real Estate Bubble**. The Case-Shiller graphs use 2000 as their baseline year but the housing boom started a bit earlier than that in most cities so you can miss the first chapters of the Great Real Estate Bubble story when you start in 2000.

The graphs below shift the base year back from 2000 to 1995 so you can see the whole bubble cycle develop from beginning to end.

A paper by Ferreira and Gyourko (2011) shows the real estate booms in some cities started in 1997-1999 and grew slowly for a while before taking off.

**I wanted to see how the real estate booms developed from the very beginning so I moved the Case-Shiller baseline year back to 1995 from 2000.**

The authors of that study consider a jump in prices as the beginning of a housing boom. That is, if prices have been increasing at around 3% a year for a few years and then they jump to 6% in one year, that jump is the beginning of the boom.

Note: Sorry but Case-Shiller doesn’t have data for **Dallas** before 2000 so I can’t shift the base year back to 1995 for Dallas.

Note: I applied the Consumer Price Index for All Urban Consumers (CPI-U) to the Case-Shiller Home Price Index.

## Move Baseline Year to 1990

**The S&L Real Estate Bubble**. When I set the baseline back to 1990, it’s easy to see how the 1990 recession affected house prices. It took a lot of metros a lot of years to get back to 1990 prices.

If you move the date slider at the bottom of the graphs back to 1987, you can see that when the 1990 Recession started, the S&L real estate bubble peaked in California and DC. House prices in Boston and New York were falling before the 1990 Recession started.

The S&L bubble was centered on commercial real estate but it also affected residential house values in some metros. For more, check out this post, What The 1990s Tell Us About The Next Housing Bust.

For fun, be sure and check out Denver and Portland house prices during the 1990s.

Sorry but the Case-Shiller data for **Atlanta**, **Detroit** and **Dallas** doesn’t start until after 1990 so I can’t shift the base year back to 1990 for those 3 metros.

**Earliest Case-Shiller Data**

1987 = 14 metros

1989 = Phoenix & Minneapolis

1990 = Seattle

1991 = Atlanta & Detroit

2000 = Dallas

## Real Monthly Mortgage Payment Adjusted Case-Shiller Home Price Index

See a full discussion of the Real Monthly Mortgage Payment House Price Index here.

The idea is that if you’re taking out a mortgage to buy a house, the price of the house is mainly your monthly mortgage payment and the mortgage interest rate has a big impact on your monthly mortgage payment. That is, your mortgage interest rate has a big effect on the price – the monthly mortgage payment price – of your house.

## The Real Story of House Prices!

**2000 Baseline**. If 30 years is too long for you, in this graph I moved the baseline year back to 2000.

## Biggest Problem with Case-Shiller

It’s not perfect but the Case-Shiller Home Price Index is a more accurate measure of house price changes than either average or median house price because the Case-Shiller Index looks at changes in the sales prices of individual houses over time.

**However, the Case-Shiller Index has one big problem – it’s SLOW.**

We won’t get the January numbers, for example, until the end of March and then the January numbers are really the November-January numbers because Case-Shiller uses a 3-month moving average. So **what Case-Shiller calls “January” numbers should really be called “December” numbers because they represent November-January sales**.

We usually get the **average** and **median** house price data soon after the end of a month which is an advantage over the Case-Shiller numbers. However, the average and median numbers jump around a lot from month to month which makes it harder to see changes in price trends.

In addition, average and median house prices are more affected by the mix of houses sold. When, for example, more luxury houses are sold for any reason (say, a strong stock market), the average and median house prices will increase even if the underlying house values haven’t changed a cent.

The S&P/Case-Shiller Index, however, is value-weighted, so more expensive houses have a greater influence on estimated price changes.

**Despite running 3 months behind, the Case-Shiller Home Price Index remains the most accurate measure of house price appreciation.**

## 3-Month Markers

Case-Shiller numbers are 3-month moving averages so the January number is really the November-January average. What Case-Shiller calls “January” numbers should really be called “December” numbers because they represent November-January sales. This chart shows that better.

# # #

Great description of the Case Shiller Index. Nifty tool to look at prices of homes across the country.

Thanks, Mark! Enjoy the fresh snow in Denver. And thanks for the comment!