Robert F. Swenson III site markROBERT F. SWENSON III
← Back to Projects

Rate Tracking & Decision Support

MORTGAGE INTELLIGENCE

Automated mortgage-rate tracking and decision support system designed around refinance thresholds and long-term financial planning.

AUTOMATIONDATAMONITORINGDASHBOARD
Status
ACTIVE
Host
UBUNTU
Deployment
SELF-HOSTED
Mortgage Intelligence dashboard: 30-year rate trend line against a refinance target, with current average, target, and tracked balance.

Overview

System Overview

An automated mortgage-rate tracking and decision-support system built around refinance thresholds and long-term financial planning — turning a manual, easy-to-forget check into a monitored, data-backed decision.

PythonScheduled automationDashboarding

Problem

The Problem

  • ›Refinance opportunities are time-sensitive and easy to miss when tracking rates means remembering to check manually.
  • ›Rate data on its own doesn't answer the real question: does this specific move make sense given the numbers that matter for this loan.

Requirements

What It Had to Do

  • ›Automatically collect current mortgage-rate data on a schedule instead of relying on manual checks.
  • ›Evaluate rates against defined refinance thresholds relevant to the actual loan and financial plan.
  • ›Present results on a dashboard rather than in scattered notes or spreadsheets.

Architecture

How It's Structured

Rate Sources
Automated Collection
Threshold Evaluation
Dashboard
Decision Support

Build

Engineering the Build

A scheduled collection job pulls current rate data and logs it over time, rather than only capturing a single point-in-time snapshot.

Collected rates are evaluated against defined refinance thresholds to flag when conditions actually justify a closer look.

A dashboard presents current rates, history, and threshold status, turning the process into a monitored system instead of a recurring manual chore.

Challenges

What Made It Hard

  • ›Defining thresholds that reflect real breakeven math rather than a simple 'rate went down' check.
  • ›Keeping data collection reliable over long, mostly-uneventful stretches where nothing changes.

Current System

Results — Where It Stands Today

  • ›Automated rate tracking and threshold evaluation run on a schedule, with results visible on a dashboard.
  • ›The system functions as ongoing monitoring rather than a one-time calculator.

What's Next

What's Next

  • ›Expand the model behind threshold evaluation as more real-world data accumulates.
  • ›Add longer-horizon trend tracking to support broader financial planning, not just refinance timing.