[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4762: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4764: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4765: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4766: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
Seattle Bubble Forum Archive • View topic - Inventory changes vs. Price Changes. verrry interesting

Inventory changes vs. Price Changes. verrry interesting

Anything and everything relating to Seattle-area real estate.

Moderators: synthetik, The Tim, Lake Hills Renter

Inventory changes vs. Price Changes. verrry interesting

Postby deejayoh » Fri Jun 08, 2007 12:02 pm

deejayoh
Bubble Banter Boss
 
Posts: 1166
Joined: Mon Feb 26, 2007 12:14 pm
Location: Capitol Hill

Postby femto » Fri Jun 08, 2007 12:49 pm

Have you looked at rolling changes in sales volume into this as well? That way you explicitly get both sides of the supply/demand equation.
femto
Bubble Blatherer
 
Posts: 88
Joined: Thu May 17, 2007 12:48 am

Postby deejayoh » Fri Jun 08, 2007 12:54 pm

Holy fa-shizzle! The comparison against Case Shiller is almost perfect...

A 12 month lag again turned out the best model (which gives me comfort about the approach) and using this data, I get an r-squared of 0.829!!

CS is 2 months in arrears in their reporting - meaning we get 14 months of forecast.

Here's the fugliness. I backed in to the M2M numbers as well.


Month Y2Y M2M Actual
Apr-07 9.13% 0.8% 9.6%/1.3%
May-07 6.94% -0.5%
Jun-07 4.99% -0.2%
Jul-07 4.40% 0.6%
Aug-07 3.11% -0.2%
Sep-07 1.74% -0.7%
Oct-07 1.18% -0.2%
Nov-07 2.04% 0.9%
Dec-07 3.38% 1.4%
Jan-08 3.66% 0.2%
Feb-08 3.50% 0.4%
Mar-08 0.68% -1.9%
Apr-08 -0.96% -0.8%
May-08 -2.57% -2.2%

Check out the scatterplot...
Image
Last edited by deejayoh on Tue Jul 03, 2007 7:04 pm, edited 1 time in total.
deejayoh
Bubble Banter Boss
 
Posts: 1166
Joined: Mon Feb 26, 2007 12:14 pm
Location: Capitol Hill

Postby deejayoh » Fri Jun 08, 2007 12:59 pm

deejayoh
Bubble Banter Boss
 
Posts: 1166
Joined: Mon Feb 26, 2007 12:14 pm
Location: Capitol Hill

Postby biliruben » Fri Jun 08, 2007 1:00 pm

biliruben
Bubble Banter Boss
 
Posts: 575
Joined: Sun Feb 18, 2007 4:31 pm
Location: Lake City

Postby deejayoh » Fri Jun 08, 2007 2:44 pm

deejayoh
Bubble Banter Boss
 
Posts: 1166
Joined: Mon Feb 26, 2007 12:14 pm
Location: Capitol Hill

Postby Alan » Fri Jun 08, 2007 6:01 pm

Alan
Bubble Banter Boss
 
Posts: 780
Joined: Sun Feb 18, 2007 7:08 pm

Postby deejayoh » Tue Jun 12, 2007 4:49 pm

Here's my model posted against the CS time series
Image

I'd bet that the down trend will be smoother than what I show here - w/o that little run-up, but the slope and depth are probably in the ball park
deejayoh
Bubble Banter Boss
 
Posts: 1166
Joined: Mon Feb 26, 2007 12:14 pm
Location: Capitol Hill

Postby deeplennon » Thu Jun 14, 2007 8:41 am

Really interesting.. you should post a higher res version of your graph. Keep updating this monthly!
deeplennon
Bubble Watcher
 
Posts: 35
Joined: Fri Feb 23, 2007 8:45 am

Postby Dave0 » Thu Jun 14, 2007 4:21 pm

Dave0
Bubble Blatherer
 
Posts: 66
Joined: Thu Jun 14, 2007 4:15 pm


Return to Seattle Real Estate

Who is online

Users browsing this forum: No registered users and 11 guests