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()Examples
Current Case-Shiller 20-city index
=HousePriceIndex20city()/100-1Compare to FHFA index
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.
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?