Visualization of HDB resale prices and SORA rate analysis

Real Estate

HDB Resale Prices and SORA Rates

A market study combining MAS rate data, HDB resale transactions, and town-level mapping to examine how financing conditions and resale activity moved together.

PythonSQLMAS APIGeoPandas HDB ResaleInterest RatesSORAMacroeconomic Signals

Outcome: Built a framework for reading HDB resale activity alongside Singapore interest-rate conditions, with town-level comparisons that made macro shifts easier to interpret.

Problem

Interest-rate shifts affect housing markets, but the relationship is rarely clean or immediate.

In Singapore, one of the more useful questions is not just whether rates went up or down, but how financing conditions interacted with HDB resale behaviour across towns, transaction bands, and time periods.

Approach

I built a workflow that combined market and macro data into the same analytical frame.

  • MAS SORA data was used to track the financing backdrop over time.
  • SQL queries pulled HDB resale transactions across multiple years so 2023 activity could be compared against earlier periods.
  • Higher-value transactions were isolated as one way of reading where resilience or pressure might be showing up more clearly.
  • Python and GeoPandas were used to aggregate the results by HDB town and prepare them for mapping.

This made it possible to compare changes in median resale prices, transaction distribution, and town-level movement against a changing interest-rate environment.

What the Analysis Looked For

The project was designed to answer practical questions such as:

  • which HDB towns saw larger median price changes between 2022 and 2023
  • where higher-value resale activity was concentrated
  • how rising rate conditions coincided with changes in transaction behaviour

The goal was not to claim a simple one-variable explanation for the market. Housing prices move through a mix of policy, supply, financing, and local demand conditions. But rates are one of the most important parts of that system, and they need to be analyzed in context rather than in isolation.

Why It Mattered

This case study is closer to the kind of public-facing market work I want this portfolio to represent.

It connects macro conditions to actual housing-market behaviour, uses maps to make the variation legible across towns, and treats market interpretation as a structured exercise rather than a headline reaction. That makes it useful both as research and as a framework for market commentary.