MarketXLS

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)

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.

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 Mortgage Rate - 30 Year and Other Financial Formulas
▶
How does MarketXLS work?

Live Data

Related Functions