Seattle Bubble

News & discussion about real estate & the housing bubble in the Seattle area.

Seattle Bubble - News & discussion about real estate & the housing bubble in the Seattle area.

Entries Tagged as 'graphs'

Puget Sound Counties Interactive September Update

By The Tim on November 2nd, 2009 at 8:00 AM · 5 Comments

Whoops, sorry this is late. It took a little extra time to put together this month, as I finally switched the data over from months of supply to Seasonally Adjusted Active Supply. So, let’s have our September data checkup of NWMLS statistics from around the sound. As usual, courtesy Tableau Software, the Around the Sound update is rocking exclusive interactive data visualizations.

Feel free to download the old charts in Excel 2007 and Excel 2003 format. To get specific info about a certain point on any graph in the post below, float your mouse pointer over the data.

Before we get to the cool stuff, here’s the usual table of YOY stats for each of our seven covered counties as of September 2009.

September 2009 King Snohomish Pierce Kitsap Thurston Island Skagit Whatcom
Median Price 7.9% 11.1% 8.2% 4.6% 2.8% 1.8% 2.0% 8.7%
Listings 19.4% 23.6% 25.8% 25.1% 15.8% 2.0% 4.9% 9.7%
Closed Sales 14.3% 14.6% 12.4% 14.5% 1.5% 11.5% 20.9% 19.3%
Seasonally Adjusted Active Supply 2.0 2.1 1.8 2.0 1.9 2.5 3.0 1.5

Hit the jump for this month’s interactive charts.

[Read more →]

→ 5 CommentsCategories: Statistics
Tags: , , , , , , , , , , , , , ,

September Seasonally-Adjusted Active Supply by Neighborhood

By The Tim on October 29th, 2009 at 6:00 AM · 5 Comments

Let’s check in again on our regular monthly neighborhood update to Seasonally-Adjusted Active Supply (SAAS). For an explanation of what seasonally-adjusted active supply is, please refer to this post. Also, you may view a map of the areas discussed in this post.

As usual, the sweet interactive data visualizations (new and improved!) in today’s post come to you courtesy Tableau Software.

In the charts below I have taken the calculated value for SAAS and subtracted 2, in order to better visualize the difference between a buyer’s market and a seller’s market. Using this method, negative SAAS values indicate a seller’s market, while positive values indicate a buyer’s market.

Summary

King County’s overall SAAS dropped further below the “balanced” level, coming in at 1.80 for September (August was 1.88). 11 of 30 areas came in below 1.75 as seller’s markets, 5 of 30 came in above 2.25 as buyer’s markets, and the remaining 14 were more or less balanced between 1.75 and 2.25.

Hit the jump for the rest of this month’s interactive charts and commentary.

[Read more →]

→ 5 CommentsCategories: Statistics
Tags: , , , , ,

Case-Shiller: Seattle Still Being Left Out of the Summer Party

By The Tim on October 27th, 2009 at 7:01 AM · 97 Comments

It’s that fun time of the month once again. That’s right, time for the latest data from the Case-Shiller Home Price Index. According to August data,

Up 0.1% July to August.
Down 0.2% July to August (seasonally adjusted)
Down 14.7% YOY.
Down 22.2% from the July 2007 peak

Last year prices fell 0.7% from July to August (not seasonally adjusted) and year-over-year prices were down 8.8%.

Once again, here’s a little dose of sanity to contrast with what is no doubt set to be a day full of crowing and hoopla over the month-to-month increases seen in most of the 20 cities tracked by the Case-Shiller index.

Case-Shiller HPI: Month to Month Change

It still looks as though Seattle is being somewhat left out of this party.

Here’s our offset graph, with L.A. & San Diego time-shifted from Seattle & Portland by 17 months. Look at SoCal’s year-over-year skyrocketing back up to zero. Portland came in at -12.5%, and now both Los Angeles at -12.0%, and San Diego at -8.9% came in better than Seattle.

Case-Shiller HPI: West Coast

Note: This graph is not intended to be predictive. It is for entertainment purposes only.

Here’s the graph of all twenty Case-Shiller-tracked cities:

Case-Shiller HPI: All Cities

In July, fourteen of the twenty Case-Shiller-tracked cities experienced smaller year-over-year drops than Seattle (vs. twelve last month). Dallas at -1.2%, Denver at -1.9%, Cleveland at -2.8%, Boston at -4.2%, Washington, DC at -7.9%, Charlotte at -8.6%, San Diego at -8.9%, New York at -9.6%, Atlanta at -10.6%, Los Angeles at -12.0%, Portland at -12.5%, San Fancisco at -12.5, Chicago at -12.7%, and Minneapolis at -13.7%. Vegas took the #1 spot again for the largest year-over-year drop, with prices still falling over 30% in a single year down there—stimulus? What stimulus?

Here’s an update to the peak-decline graph, inspired by a graph created by reader CrystalBall. This chart takes the twelve cities whose peak index was greater than 175, and tracks how far they have fallen so far from their peak. The horizontal axis shows the total number of months since each individual city peaked.

Case-Shiller HPI: Decline From Peak

In the two years and a month since the price peak in Seattle prices have declined 22.2%. Definitely seems to be stuck moving sideways.

Here’s a complimentary chart to that last one. This one shows the

Case-Shiller HPI: Bounce Since March 2009

With just a 0.3% increase since March, the summer of stimulus seems to be having little effect on Seattle home prices. But hey, at least we’re not as immune to stimulus as Vegas apparently is. Down 9% in just the last five months. Ouch!

The following chart takes the post-bubble years of 2007, 2008, and 2009 and indexes each January’s Case-Shiller HPI to 100 so we can get a picture of how this year’s declines compare to last year:

Post-Bubble Seattle Case-Shiller HPI by Year

Thanks to the tax credits, abnormally / artificially low interest rates, and lots of hype about a so-called recovery, it would seem that we have pulled 2009 into slightly better territory than 2008.

Lastly, here’s an update to the Case-Shiller vs. NWMLS median chart. The following chart shows Seattle-area 2009 home prices, indexed to January = 100, as reported by the NWMLS (using a 3-month rolling average) and by Case-Shiller.

Seattle Case-Shiller HPI and NWMLS SFH Median

Check back tomorrow for a post on the Case-Shiller data for Seattle’s price tiers.

(Home Price Indices, Standard & Poor’s, 10.27.2009)

→ 97 CommentsCategories: Statistics
Tags: , , , ,

Case-Shiller: Seattle Home Prices Hold Steady Through Summer

By The Tim on September 29th, 2009 at 7:05 AM · 137 Comments

It’s everybody’s favorite time of the month again. That’s right, time for the latest data from the Case-Shiller Home Price Index. According to July data,

Down 0.1% June to July.
Down 0.3% June to July (seasonally adjusted)
Down 15.3% YOY.
Down 22.3% from the July 2007 peak

Last year prices fell 1.0% from June to July (not seasonally adjusted) and year-over-year prices were down 8.2%.

Since the national media outlets will no doubt be crowing once again about a month-to-month increase in the nationwide 20-city index, here’s a new chart to kick things off: every city’s percentage change from June to July (taken from the non-seasonally-adjusted data, since that’s all the national media usually reports on):

Case-Shiller HPI: Month to Month Change

So, there’s that.

Here’s our offset graph, with L.A. & San Diego time-shifted from Seattle & Portland by 17 months. Still the summer of improvement on this one, with Portland up to -13.9%, Los Angeles at -14.9%, and San Diego again coming in better than Seattle at -12.3%.

Case-Shiller HPI: West Coast

Note: This graph is not intended to be predictive. It is for entertainment purposes only.

Here’s the graph of all twenty Case-Shiller-tracked cities:

Case-Shiller HPI: All Cities

In July, twelve of the twenty Case-Shiller-tracked cities experienced smaller year-over-year drops than Seattle (vs. ten last month). Cleveland at -1.3%, Dallas at -1.6%, Denver at -2.9%, Boston at -5.0%, Charlotte at -9.0%, Washington, DC at -9.8%, New York at -10.0%, Atlanta at -12.1%, San Diego at -12.3%, Portland at -13.9%, Chicago at -14.2%, and Los Angeles at -14.9%. Vegas held the #1 spot for the largest year-over-year drop, with prices still falling over 30% in a single year down there.

Here’s an update to the peak-decline graph, inspired by a graph created by reader CrystalBall. This chart takes the twelve cities whose peak index was greater than 175, and tracks how far they have fallen so far from their peak. The horizontal axis shows the total number of months since each individual city peaked.

Case-Shiller HPI: Decline From Peak

In the two full years since the price peak in Seattle prices have declined 22.3%. We still haven’t quite moved over to the DC trend, but the summer of flatline prices did at least move Seattle off the Phoenix price drop trend.

The following chart takes the post-bubble years of 2007, 2008, and 2009 and indexes each January’s Case-Shiller HPI to 100 so we can get a picture of how this year’s declines compare to last year:

Post-Bubble Seattle Case-Shiller HPI by Year

Still slightly below where we were this far into last year, at just over 3% off January.

Here’s an update to the Case-Shiller vs. NWMLS median chart. The following chart shows Seattle-area 2009 home prices, indexed to January = 100, as reported by the NWMLS and by Case-Shiller.

Seattle Case-Shiller HPI and NWMLS SFH Median

While Case-Shiller has been mostly flat since March, the NWMLS median has been swinging all over the place.

Check back tomorrow for a post on the Case-Shiller data for Seattle’s price tiers.

(Home Price Indices, Standard & Poor’s, 09.29.2009)

→ 137 CommentsCategories: Statistics
Tags: , , , ,

August Seasonally-Adjusted Active Supply by Neighborhood

By The Tim on September 28th, 2009 at 6:00 AM · 58 Comments

Let’s check in again on our regular monthly neighborhood update to Seasonally-Adjusted Active Supply (SAAS). For an explanation of what seasonally-adjusted active supply is, please refer to this post. Also, you may view a map of the areas discussed in this post.

As usual, the sweet interactive data visualizations in today’s post come to you courtesy Tableau Software.

In the charts below I have taken the calculated value for SAAS and subtracted 2, in order to better visualize the difference between a buyer’s market and a seller’s market. Using this method, negative SAAS values indicate a seller’s market, while positive values indicate a buyer’s market.

Summary

Seasonally-Adjusted Active Supply

With new listings continuing to wane, King County’s overall SAAS finally dropped below the “balanced” level, coming in at 1.88 for August (July was 2.01). 10 of 30 areas came in below 1.75 as seller’s markets, 7 of 30 came in above 2.25 as buyer’s markets, and the remaining 13 were more or less balanced between 1.75 and 2.25.

Hit the jump for the rest of this month’s interactive charts and commentary.

[Read more →]

→ 58 CommentsCategories: Statistics
Tags: , , , , ,

Puget Sound Counties Interactive August Update

By The Tim on September 25th, 2009 at 6:00 AM · 5 Comments

The time has come for our regularly-scheduled late-month check on NWMLS statistics from around the sound. As usual, courtesy Tableau Software, the Around the Sound update is rocking exclusive interactive data visualizations.

Feel free to download the old charts in Excel 2007 and Excel 2003 format. To get specific info about a certain point on any graph in the post below, float your mouse pointer over the data.

Before we get to the cool stuff, here’s the usual table of YOY stats for each of our seven covered counties as of August 2009.

(Note: Keep in mind that certain NWMLS definitions were modified beginning July 2008 that affect the reported number of active listings and pending sales (and therefore the “months of supply”). The net result of this change is that active listings post 07/08 will appear lower, pending sales higher, and months of supply lower than prior to 07/08. See this post for more details.)

August 2009 King Snohomish Pierce Kitsap Thurston Island Skagit Whatcom
Median Price 11.5 11.8% 8.8% 12.5% 3.8% 5.3% 13.7% 0.5%
Listings 20.6% 25.9% 24.0% 27.4% 17.2% 5.0% 0.8% 10.5%
Closed Sales 5.0% 8.1% 5.2% 4.7% 12.2% 2.4% 7.1% 10.3%
Months of Supply 4.1 4.6 4.4 5.2 4.6 11.3 8.4 6.1

Hit the jump for this month’s interactive charts.

[Read more →]

→ 5 CommentsCategories: Statistics
Tags: , , , , , , , , , , , , ,