Methodology & Data Sources

How CityDataLab decomposes real estate prices — the data, the factor model, and the thinking behind it.

Methodology

The Hedonic Factor Model

At each point in time we run a cross-sectional OLS regression of log(price/sqm) on property characteristics using a rolling 3-month window. The fitted coefficients (betas) tell us the market price of each characteristic in that window.

For each rolling window t and each transaction i, the regression is:

log(pi,t / ai,t) = αt + Σk βk,t · xk,i,t + εi,t

where p is the transacted price, a the floor area in square metres and xk the k-th factor (continuous or dummy). Every factor is centred on its average over the whole period, so the intercept αt is the log price per sqm of the average home.

Vocabulary

Every page and post uses these terms, and only these:

The Index and its decomposition

The Index reprices a slowly updated basket of homes, x̃t: a blend of the average home sold over the past 24 and 6 months, known one month ahead. Chain-linking month by month:

Δ log Indext = Δαt + Σk x̃k,t · Δβk,t
Index Return = Baseline Market + Σk Factor Contributionk
Average Price Paid = Index Return + Σk Compositionk

Both identities hold exactly. The log parts are rescaled so that they also add up in %, and every series is measured from the first full 3-month window. Because the basket changes slowly, a burst of sales of one kind of home moves the Average Price Paid but not the Index; that difference is the Composition.

Why a rolling 3-month window

Factor Selection

Factors are selected iteratively using forward selection. At each step, candidate factors are evaluated over all rolling windows. A factor is accepted if:

This ensures each factor adds independent, stable information to the model.

Per-city feature engineering

The set of hedonic characteristics differs by city because the underlying datasets differ. Where multiple encodings are plausible we prefer the simplest one that produces an interpretable coefficient.

Quality Controls

Limitations

References

The hedonic approach to residential property pricing goes back to Rosen (1974). The classic survey is Sirmans, Macpherson and Zietz (2005), The Composition of Hedonic Pricing Models, Journal of Real Estate Literature 13(1).

Data Sources

City Data Source Date Range Transactions

All transaction data is used in anonymised aggregate form only. No individual property records are stored or displayed.

Factors by City

Contact

Questions about the methodology, data, or cities covered? Send us a message.