Have you ever gone NUTS trying to figure out a program...well I have tonight - over 2 hours on MS Excell trying to make a simple chart.
My biggest problem is that instead of showing data every month, for some reaspon it only wants to generate quarterly points on the chart...and that is not going to cut it.
I spent the afternoon compiling this data and it is important to me and San Jainto Real Estate.
so here is the spreadsheet by itself...
November, 2009 | December, 2008 | January, 2009 | February, 2009 | March, 2009 | April, 2009 | May, 2009 | June, 2009 | July, 2009 | August, 2009 | September, 2009 | October, 2009 | ||
Total Closed Sales | 114 | 118 | 116 | 116 | 143 | 148 | 145 | 135 | 130 | 107 | 104 | 125 | |
Avg Sold Price | $166,503 | $145,779 | $154,971 | $131,060 | $121,852 | $124,898 | $120,859 | $141,489 | $131,765 | $129,779 | $134,091 | $145,957 | |
Avg DOM | 63 | 69 | 70 | 64 | 79 | 76 | 72 | 65 | 58 | 55 | 56 | 50 | |
New Listings | 175 | 147 | 187 | 170 | 195 | 145 | 111 | 176 | 158 | 126 | 133 | 118 | |
Avg List Price | $ 147,759 | $ 133,861 | $ 141,107 | $ 125,108 | $ 134,018 | $ 133,110 | $ 140,815 | $ 133,708 | $ 131,376 | $ 125,386 | $ 144,556 | $ 139,137 | |
TOTAL REO SOLD | 80 | 78 | 83 | 97 | 131 | 128 | 135 | 114 | 107 | 87 | 78 | 84 | 67.20% |
Avg Sold Price | $161,482 | $144,952 | $144,570 | $131,275 | $117,361 | $120,219 | $119,320 | $139,272 | $128,840 | $126,347 | $130,681 | $139,539 | |
Avg DOM | 57 | 59 | 66 | 61 | 75 | 74 | 69 | 58 | 48 | 44 | 45 | 30 | |
New Listings | 111 | 107 | 112 | 108 | 135 | 77 | 56 | 92 | 84 | 65 | 68 | 56 | 47.46% |
Avg List Price | $ 133,493 | $ 131,434 | $ 127,792 | $ 113,341 | $ 128,784 | $ 123,856 | $ 124,592 | $ 126,549 | $ 124,603 | $ 123,024 | $ 136,293 | $ 127,790 | |
TOTAL SHORT SALE SOLD | 3 | 4 | 5 | 2 | 3 | 6 | 3 | 8 | 12 | 15 | 16 | 24 | 19.20% |
Avg Sold Price | $182,500 | $190,000 | $182,400 | $165,500 | $157,166 | $165,166 | $138,333 | $146,562 | $138,466 | $143,800 | $145,125 | $156,708 | |
Avg DOM | 145 | 129 | 123 | 63 | 153 | 141 | 94 | 127 | 124 | 116 | 133 | 129 | |
New Listings | 32 | 22 | 53 | 51 | 50 | 52 | 43 | 64 | 54 | 45 | 44 | 36 | 30.51% |
Avg List Price | $ 150,881 | $ 140,045 | $ 159,241 | $ 139,517 | $ 144,308 | $ 130,725 | $ 149,351 | $ 138,428 | $ 127,278 | $ 120,209 | $ 143,151 | $ 129,877 | |
TOTAL STANDARD SALES SOLD | 6 | 10 | 5 | 5 | 1 | 4 | 0 | 5 | 2 | 0 | 2 | 10 | 8.00% |
Avg Sold Price | $142,166 | $148,670 | $234,000 | $122,460 | $504,000 | $147,625 | $0 | $210,328 | $170,000 | $0 | $118,500 | $160,790 | |
Avg DOM | 9 | 83 | 34 | 67 | 95 | 87 | 0 | 74 | 78 | 0 | 77 | 30 | 25.42% |
New Listings | 11 | 2 | 6 | 4 | 3 | 7 | 6 | 7 | 6 | 5 | 10 | 12 | |
Avg List Price | $ 174,745 | $ 234,499 | $ 175,883 | $ 237,475 | $ 149,633 | $ 269,899 | $ 152,915 | $ 152,984 | $ 199,050 | $ 144,180 | $ 204,033 | $ 159,187 | |
TOTAL OTHER SALES SOLD* | 25 | 26 | 23 | 12 | 8 | 11 | 7 | 8 | 9 | 5 | 8 | 7 | 5.60% |
Avg Sold Price | $182,754 | $140,346 | $169,360 | $127,158 | $133,812 | $149,112 | $143,057 | $124,812 | $149,111 | $147,440 | $149,175 | $164,928 | |
Avg DOM | 74 | 82 | 79 | 86 | 100 | 65 | 116 | 101 | 81 | 71 | 41 | 39 | |
New Listings | 21 | 16 | 16 | 7 | 7 | 9 | 6 | 13 | 14 | 8 | 11 | 14 | 11.86% |
Avg List Price | $ 189,886 | $ 129,012 | $ 138,250 | $ 137,464 | $ 154,757 | $ 119,665 | $ 218,966 | $ 150,745 | $ 164,818 | $ 162,837 | $ 147,190 | $ 191,155 | |
*OTHER SALES INCLUDES | |||||||||||||
Auction | |||||||||||||
Bankruptcy | |||||||||||||
HUD/Govt Owned | |||||||||||||
Probate | |||||||||||||
Red-Tagged | |||||||||||||
Relocation Company Owned | |||||||||||||
Subject to RELO Company Approval | |||||||||||||
Subject to Court Approval |
Lots of good data here, broken down month by month. If you look, you'll see the number of total listings and the total number of sales. Then typical with myother market reports, I go ahed and break it down by sale type; i.e. REO, Short Sales, etc.
There are definately some trends, and I promise to repost this once I have a better handel on the uncoperative MS Excel 2003 program I am using.
Comments(0)