We had a chat about the direction of the market in the last post and I claimed that despite a dip in the average and median prices, the market was showing no signs of slowing down and was on an accelerating trend. To back this up I submit the yearly median price and MOI charts which show the market has been carving a remarkably symmetrical price bowl with a significantly steeper slope in 2015.
The other important metric of current conditions is the ratio of sales to new listings which tells us current conditions and what we might expect going forward. Same story there, with the trend showing no signs of reversal, and even accelerating.
So far no signs of slowdown. We aren’t in hot market territory just yet but at this rate we will end up there by next spring.
Change of topic.
They call me the king of the spreadsheets.
Got ’em all printed out on my bedsheets.
– Weird Al
The master spreadsheet that I based this blog on (and handed over to DavidL who has taken it to the next level) has 11 data sheets and 42 chart sheets. It is pretty unwieldy and fundamentally this cycle of “update excel, update chart bounds, screenshot, upload image” is a real drag. It’s 2015 and we have self driving cars. This kind of manual bullshit really shouldn’t be acceptable anymore.
So I stripped out all the charts and migrated the important data sheets my spreadsheet to Google Sheets. Anyone that wants to play can access the data here. However an Internet spreadsheet doesn’t solve the charting problem. In fact Google Sheets is woefully under-powered compared to Excel and some of the more complicated charts I’ve made over the years are impossible to reproduce in it.
Unfortunately all this goodness cannot run on this blog directly because WordPress hosting restricts what can be embedded into pages. So for now you’ll have to go over to househuntvictoria.ca to see this stuff. Best of all, I no longer have to give my opinion on the market, I’ll let the script do that.
Not sure where I’m taking this, but if you have any ideas about what charts you want, let me know in the comments. And happy thanksgiving everyone.