House Price Index

Returns the Federal Housing Finance Agency (FHFA) U.S. house price index, which tracks changes in single-family home prices nationwide.

Data Details

Attribute Value
Source Federal Housing Finance Agency (FHFA) / FRED
Frequency Quarterly
Base Period Q1 1980 = 100
Coverage Single-family homes with conforming mortgages

Notes

  • Based on repeat-sales methodology (same properties sold multiple times)
  • Only includes homes with conforming mortgages backed by Fannie Mae or Freddie Mac
  • For broader metro-area coverage, see HousePriceIndex20city() (Case-Shiller)

Examples

Current FHFA house price index
=HousePriceIndex()/100-1
Cumulative price change since 1980

When to Use

  • Tracking national home price trends
  • Analyzing real estate market conditions
  • Economic research on housing
  • Comparing house prices over time

When NOT to Use

Scenario Use Instead
Need Case-Shiller 20-city index HousePriceIndex20city()
Need housing construction data HousingStarts()
Need mortgage rates MortgageRate30y()
Need building permits BuildingPermits()

Common Issues & FAQ

Q: What is the base period? A: Q1 1980 = 100.

Q: How is this different from Case-Shiller? A: FHFA index only includes conforming mortgages; Case-Shiller is broader and focuses on major metro areas.

Q: How often is it updated? A: Quarterly.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use House Price Index and Other Financial Formulas
How does MarketXLS work?