The PropKaki Wave™

Definition

The PropKaki Wave measures how many sold HDB flat units are estimated to reach MOP in a given quarter — i.e. become eligible for open-market resale for the first time. It is a forward-looking supply indicator: a rising Wave reading signals a larger cohort of first-time resale-eligible flats entering the HDB resale pool that quarter.

MOP is fixed at 5 years from key collection under current HDB rules (Standard and Plus model flats). Prime / PLH model flats carry a 10-year MOP, but they represent a small share of total stock and are not separately identified in the source dataset; for current PropKaki Wave purposes they are modelled at 5 years alongside standard flats — a conservative assumption that slightly overstates near-term PLH supply.

Scope and data source

Source dataset: HDB Property Information (data.gov.sg resource ID d_17f5382f26140b1fdae0ba2ef6239d2f), updated regularly by the Housing and Development Board. The dataset covers all HDB blocks island-wide from 1937 to the present, with block-level fields for year_completed, total_dwelling_units, and sold unit counts by flat type (1-room through executive). All data is fetched via the official CKAN API at data.gov.sg.

Flat types included: All sold flat types — 1-room, 2-room, 3-room, 4-room, 5-room, executive, multigeneration, and studio apartment sold units are summed into mop_units_total_qtr. Flat types tracked individually: 3-room, 4-room, 5-room, and executive (the four types most relevant to the HDB resale market). Rental units (*_rental fields) are excluded — they have no MOP requirement.

Completion year floor: Only blocks with year_completed ≥ 2010 are included, placing MOP years at 2015 and later. Older cohorts are excluded — their MOP windows have long passed and including them would add noise to the historical baseline without adding insight.

Quarter distribution rationale: HDB key-collection exercises historically cluster in the second half of the year, with H2 key collections accounting for a disproportionate share of annual completions. PropKaki applies a 15% / 15% / 35% / 35% split across Q1–Q4 within each completion year. The Q4 quarter receives the arithmetic remainder after Q1–Q3 rounding, ensuring unit counts are conserved exactly at the block level.

Computation steps

Suppression rules

Unlike transaction-based metrics, the Wave has no minimum-transaction suppression threshold — the HDB dataset is a complete census of blocks, not a sample. A quarter with few MOP units is a genuine low-supply reading, not a data artefact.

However, quarters where the data.gov.sg API returns zero records (i.e. the fetch fails or the dataset is temporarily unavailable) are not written to market_series — the sync is skipped with a logged reason code rather than overwriting existing data with zeroes.

Interpretation notes

The Wave is a stock-based estimate, not a transaction count. It represents units that become eligible to be listed on the open market, not units that are actually transacted. Actual resale volume in a quarter depends on seller willingness, prevailing prices, and market conditions — the Wave measures only the supply pool that is newly unlocked.

Because the source dataset provides only year_completed (not month or quarter of key collection), the quarter distribution is modelled, not observed. PropKaki calibrates the 15/15/35/35 skew against HDB's published pattern that completion key-collections are disproportionately H2-weighted — but individual projects may distribute differently.

The dataset does not distinguish BTO projects from SERS redevelopment stock. SERS flats carry the same 5-year MOP from key collection and are correctly included in the Wave; they represent a small minority of completions in most years.

Prime / PLH model flats (launched from 2022 onwards) carry a 10-year MOP. They are included at 5 years in the current methodology, meaning the Wave slightly overstates near-term PLH resale supply. A separate PLH adjustment series is planned for v1.1 once reliable project-to-block mapping is available.

Series keys and API access

All five series are available via PropKaki's free JSON API (no key required):

All series return integer unit counts per quarter. The mop_units_total_qtr series equals the sum of all flat types (including 1-room, 2-room, multigeneration, and studio apartments) and will be larger than the sum of the four individually tracked series.

Citation

Preferred citation for the PropKaki Wave:

When quoting a specific quarter's reading, include the quarter and flat type, e.g.: "An estimated 4,200 HDB units reached MOP in 2025Q3, of which 1,800 were 4-room flats (PropKaki Wave™, methodology v1.0)."

Full citation formats, BibTeX, and licence terms: /market/cite.

Version history