YLTNBoomerang sent in some extremely detailed townhouse market tracking data for downtown Vancouver with the following note:
Long time reader and sometimes contributor to your blog. I sold my place last March in Yaletown (townhouse on Marinaside Crescent) at $890/sqft and have been tracking townhouses in Vancouver ever since. More recently (January) I started recording changes in prices etc. on MLS in a increasingly large spreadsheet. I thought you might be interested in seeing how this specific slice of the market is reacting and have attached this sheet. Please feel free to use or distribute as you please.
Keep up the good work!
The information in this spreadsheet includes square footages, new listings and price changes from January 10 until July 29th (today). Within the tracked time period for Waterfront townhouses in downtown Vancouver there have been 5 instances of asking price increases and 73 instances of asking prices being dropped. The entire database is color-coded, with red indicating price increases and green indicating drops.
We discussed options for graphing the data included here, but neither YLTNBoomerang nor I could figure out the best way to do it, so here’s an open challenge to Vancouver real estate market data obsessives & excel graphing gurus: Can you figure out a way to present the information in this spreadsheet in an interesting and informative visual manner?
Want to share a graph? You can email it to me along with the name you’d like credited and I’ll post it here. If you want to cut out the middleman (me) you can make a post in the discussion forum with any graphs or images attached and link to it in the comments below.
UPDATE: That was fast! Here’s a “day’s on market / price drops” scatter graph courtesy of an anonymous contributor:
UPDATE 2: Yet another anonymous graph-maker sent in this chart showing asking price per square foot for downtown town houses for the first half of 2008: