House Price Index - Shiller 20 City
Returns the S&P/Case-Shiller 20-city composite home price index, which tracks changes in home prices across 20 major U.S. metropolitan areas.
Data Details
| Attribute | Value |
|---|---|
| Source | S&P Dow Jones Indices / FRED |
| Frequency | Monthly |
| Base Period | January 2000 = 100 |
| Coverage | 20 major metro areas |
Covered Metropolitan Areas
Atlanta, Boston, Charlotte, Chicago, Cleveland, Dallas, Denver, Detroit, Las Vegas, Los Angeles, Miami, Minneapolis, New York, Phoenix, Portland, San Diego, San Francisco, Seattle, Tampa, Washington D.C.
Notes
- Uses repeat-sales methodology
- More focused on major metro areas compared to FHFA index
- Widely followed as a leading indicator of housing market health
Syntax
=HousePriceIndex20city()Returns
number
S&P/Case-Shiller 20-city composite home price index
Examples
=HousePriceIndex20city()=HousePriceIndex20city()/100-1=HousePriceIndex20city()-HousePriceIndex()When to Use
- Tracking metro-area home price trends
- Analyzing urban real estate markets
- Economic research on housing
- Investment analysis for real estate
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need national FHFA index | HousePriceIndex() |
| Need housing construction data | HousingStarts() |
| Need mortgage rates | MortgageRate30y() |
| Need building permits | BuildingPermits() |
Common Issues & FAQ
What is the base period?
January 2000 = 100.
Which cities are included?
20 major metros including New York, Los Angeles, Chicago, San Francisco, etc.
How is this different from FHFA index?
Case-Shiller focuses on 20 major metro areas and includes all mortgages, while FHFA is national and only conforming mortgages.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?