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()Returns
number
30-year fixed mortgage rate as a percentage
Examples
Current 30-year mortgage rate
=MortgageRate30y()/100Spread 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.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Natural Gas Price
- Personal Savings Rate
- Population
- Producer Price Index - Crude Goods
- Producer Price Index - Final Demand
- Producer Price Index - Final Demand (Excluding Food and Energy)
- Producer Price Index - Finished Goods
- Producer Price Index - Finished Goods (Excluding Food and Energy)
See MortgageRate30y used in a complete workbook: Yield Curve Dashboard Excel: June 2026 Recession Indicator and Treasury Spread Tracker
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?