Outstanding Mortgage Rates

Get the distribution of the interest rates US homeowners pay on the mortgages they already have, from the National Mortgage Database (NMDB) of the Federal Housing Finance Agency (FHFA): the share of the mortgages outstanding at the end of each quarter with a contract interest rate below 3%, between 3% and 4%, 4% and 5%, 5% and 6%, and at or above 6%, next to their average rate.

This is the measure of the mortgage rate “lock-in”: a homeowner with a rate well below the rate on a new mortgage (see get_mortgage_rate_30_year) gives that rate up when moving, so the further the outstanding rates lie below the market rate, the fewer existing homes come up for sale. The share of mortgages below 3%, 4%, 5% and 6% (cumulative=True) is how the lock-in is usually reported, to be compared with the rate on a new mortgage.

The NMDB is a 1-in-20 sample of the closed-end first-lien residential mortgages reported to one of the three national credit bureaus, quarterly from 2013 Q1 and published about three months after the quarter ends. The rate is the contract interest rate at origination, a nominal annual rate (compounded monthly for the usual monthly payments), so an adjustable rate mortgage counts at its initial rate. Each market is a subset of all mortgages, as the FHFA defines them:

  • All Mortgages: every closed-end first-lien single-family mortgage in the NMDB.
  • Enterprise: the mortgages acquired by Fannie Mae and Freddie Mac (that are not guaranteed by a government agency).
  • Government: the government insured, guaranteed or direct mortgages (FHA, VA, USDA).
  • Other Conventional: the remaining conventional mortgages (jumbo mortgages, bank portfolios, private label pools, credit unions and the Federal Home Loan Bank programs).

The shares come in two weightings, as the FHFA publishes them: by the number of mortgages (“loans”, VALUE1 in the NMDB files, “weighted by the number of mortgages at the end of the quarter”) and by the unpaid principal balance (“balance”, VALUE2, “weighted by the value of the unpaid principal balance (UPB) of the mortgage as of the end of the quarter”), see the NMDB Aggregate Statistics Data Dictionary.

See the data: https://www.fhfa.gov/data/national-mortgage-database-aggregate-statistics

Also known as: mortgage rate lock-in, outstanding mortgage rate distribution, share of mortgages below 3%, 4%, 5% or 6%, NMDB outstanding residential mortgage statistics.

The formula is as follows:

\[\text{Share Below}\; \text{X\%} = \text{Share Below}\; 3\% + \ldots + \text{Share} \;(X - 1) \% \;\text{to}\; \text{X\%},\;\; \text{the sum of the published buckets below } X \text{\% (cumulative=True)}\]

Outstanding Mortgage Rates in Python or via the MCP

Install the Finance Toolkit with:

pip install financetoolkit -U

Then call get_outstanding_mortgage_rates as shown below.

from financetoolkit import Economics

economics = Economics(start_date='2025-01-01', end_date="2026-06-30")

economics.get_outstanding_mortgage_rates(cumulative=True)

Or, after setting up the Finance Toolkit MCP, ask:

What share of outstanding US mortgages had a rate below 3%, 4%, 5% and 6%, and what was the average rate, each quarter from 2025 to the second quarter of 2026?

Which returns:

Date Below 3% Below 4% Below 5% Below 6% Average Rate
2025Q1 0.205 0.531 0.707 0.81 0.043
2025Q2 0.202 0.521 0.695 0.799 0.043
2025Q3 0.198 0.51 0.681 0.786 0.044
2025Q4 0.195 0.501 0.67 0.781 0.044
2026Q1 0.193 0.494 0.66 0.778 0.044
2026Q2 0.192 0.491 0.656 0.776 0.044

Parameters

get_outstanding_mortgage_rates accepts the following parameters.

ParameterTypeDescriptionExample
marketstrThe market of the mortgages: “all”, “enterprise” (Fannie Mae and Freddie Mac), “government” or “other conventional”. Defaults to “all”."all"
regionstrThe area: “United States”, a census region (“Northeast”, “Midwest”, “South”, “West”), a census division (“New England”, “Middle Atlantic”, “East North Central”, “West North Central”, “South Atlantic”, “East South Central”, “West South Central”, “Mountain”, “Pacific”), or “United States Rural” and “United States Non-Rural”. Defaults to “United States”."Europe"
weightingstrWhether the shares and the average rate are weighted by the number of mortgages (“loans”) or by their unpaid principal balance (“balance”). Defaults to “loans”."loans"
cumulativeboolWhether to return the share of mortgages below 3%, 4%, 5% and 6% instead of the share per bucket. Defaults to False.True
rollingintThe rolling window size to use for smoothing the data (simple moving average). Defaults to None.4
growthboolWhether to return the growth data or the actual data. Defaults to False.True
lagintThe number of periods to lag the data by. Defaults to 1.4
standardizeboolWhether to standardize (Z-Score) the result. When combined with growth=True, standardizes the growth values instead of the raw values. Defaults to False.True
roundingint | NoneThe number of decimals to round the results to. Defaults to None, which uses the rounding of the Economics class.2
show_columnsstr | list[str] | NoneThe columns to keep, a name or a list of names, matched on every column level, or the rows when no column has those names (such as the line items of a financial statement). Names that do not exist are logged, and when none exist the result is returned in full. Defaults to None, which keeps every column.None, which keeps every column
Share