A popular home price index that has become quite popular of late is the Case-Shiller index. There are many variations, but the basic premise is you take the home price as of the first quarter of 2000, and give that price a value of 100. Then as prices fluctuate, they will be given values relative to that. So, for example, if the price as of January 2000 was $200,000… $200,000 = 100, $250,000 = 125, $300,000 = 150, $400,000 = 200, so on and so forth.
As this has become a very popular in the US of late, and I hadn’t seen it done for Canadian cities, I decided to take a shot, collected data (average MLS residential resale price, or average SFH resale price in Vancouver’s case) on eight of our larger centres and compiled it into an index based loosely on Case-Shiller, and here are the results… you can click on the picture for a larger image to get a better look…
All figures are through November ’08. You can see that by this measure, Edmonton actually had the biggest run up of prices in the country (though, apparently Saskatoon may have out did them, I could not find complete data for Saskatoon, so they are not included), and peaked earliest.
I was a bit surprised to see Vancouver was toward the middle of the pack, and Toronto actually had the most gradual growth of any. With all the verbiage flying around about those two markets, I would have expected them higher up. That’s not to say there wasn’t a big run up in Vancouver, just it was not as extreme as places like Edmonton, Regina, or even Calgary.
Montreal, Ottawa and Toronto all seemed to have more consistent numbers. Winnipeg saw a bit of a bubble in ’07, then a bigger one in ’08, but fortunately for recent buyers in that city they were a bit late arriving, so when the economic troubles hit, their fall doesn’t look to be nearly as bad as what’s likely to hit Regina, who experienced explosive price increases that rocketed them from the bottom of the chart in early ’07, to second from the top in 12 months.
With even the cities with more moderate figures experiencing very significant declines in their own prices, it should really put a scare into recent buyers in markets such as Edmonton and Regina, where prices exploded.
Here are the peak values each city realized:
Edmonton = 292.98
Regina = 277.17
Calgary = 253.98
Vancouver = 239.60
Winnipeg = 232.08
Montreal = 207.74
Ottawa = 192.47
Toronto = 173.52
In the days to come I’ll also take a look at the respective declines from peak, as well as comparing these results with those in the U.S… the similarities are really quite striking.










Thanks for the great info.
donét know how I missed this blog before but will be a regular reader now.
Just wanted to point out that the Case-Shiller index is actually based on pairs of housing transactions where the house has not been substantially changed/renovated. This is not a trivial thing to do (and the real reason we have yet to see one available for Canadian markets). It also has nothing to do with new housing developments, which may be included in your index.
You have created a housing price index (similar to the one that appears every Saturday in the Globe and Mail), but this methodology should not be confused with a Case-Shiller index.
For more information on the full methodology of generating a Case-Shiller index, I lead you to the link from the Wikipedia page:
http://www2.standardandpoors.com/spf/pdf/index/SPCS_MetroArea_HomePrices_Methodology.pdf
Val – You probably missed it cause I only started it up this week, I think Tuesday was my first entry… glad you like it though!
Trotting – I know the real thing is a fair bit more complicated, mine is just kind of loosely based around their measures. All the data I used was resale market data, largely from old CMHC reports. Thanks for reading!
Shiller himself said Vancouver was “the world’s bubbliest city”.
Cool blog!
It looks like the downturn in Edmonton shown here is muted compared to price per square foot. From the Edmonton real estate blog
~22% decline shown
That would mean the boom was even bigger than shown here for Edmonton.
Yeah, I think price per square foot is a great stat, too bad EREB doesn’t report it in their stat packages. Average price is kind of a bad stat, but it’s the most commonly reported, and widely available…
Those two at the edmontonrealestateblog would have access to all kinds of great info being realtors. Their weekly reports are great, it was pretty easy to see where that December dip in inventory came from, with the 851 listings expiring all in the final week.
I believe this is our version of Case-Shiller:
http://www.housepriceindex.ca/default.aspx?langue=EN