Mortgage Rate - 30 Year

Returns the average 30-year fixed mortgage rate as a percentage from the Freddie Mac Primary Mortgage Market Survey.

Data Details

Attribute Value
Source Freddie Mac / FRED
Frequency Weekly
Unit Percentage
Type 30-year fixed-rate mortgage

Notes

  • The most common mortgage term in the United States
  • Key driver of housing affordability
  • Closely watched economic indicator

Syntax

=MortgageRate30y()
Excel Desktop (Windows)

Returns

number

30-year fixed mortgage rate as a percentage

Examples

=MortgageRate30y()
Current 30-year mortgage rate
=MortgageRate30y()/100
Convert to decimal for calculations
=MortgageRate30y()-MortgageRate15y()
Spread between 30y and 15y rates

When to Use

  • Tracking mortgage rates
  • Housing affordability analysis
  • Real estate investment decisions
  • Economic research on housing

When NOT to Use

Scenario Use Instead
Need 15-year rate MortgageRate15y()
Need house prices HousePriceIndex()
Need housing starts HousingStarts()

Common Issues & FAQ

What unit is the result in?

Percentage (e.g., 6.95 means 6.95%).

How often is this updated?

Weekly, from Freddie Mac's Primary Mortgage Market Survey.

Is this for conforming loans?

Yes, this represents rates for conventional conforming mortgages.

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Mortgage Rate - 30 Year and Other Financial Formulas
▶
How does MarketXLS work?