m00m00's weekly property bee stats Week 6

m00m00

in simple terms, I export all the data into csv format and then into excel, and then mess around with it in there. I do this kind of analysis professionally so this is easy for me.

currently tracking 8599 properties ....

neas

I too am watching prices drop using 24 hour emails. I would be intrigued if you use any Excel macros to gather the data from property bee.

It would be really great if property bee was more automated to just 'gather' all houses from an area etc... Manually doing it is time consuming but rewarding nonetheless .

Im seeing 7-8 3-4% reduction every day being added .

SouthCoast

Thanks again.

Think that I need to go on a course to find out how to use OpenOffice!

PasturesNew

I was going to throw together a programme to do the calculations for me. But then I figured somebody else would come up with something soon.

So I am keeping my eye on property-bee for what might be a MySQL/php solution, or an Access solution. Then I'll chuck the data in there.

I got obsessed with propertysnake and was tracking drops daily for a couple of months... ends up all-consuming!

poppy10_2

What excel spreadsheet are you using for these analyses, m00m00?

m00m00

it's all my own work in excel 2007

2 new areas start being tracked this weekend

both in London, should be interesting

budget_counsellor_shaz

m00m00 wrote: »

it's all my own work in excel 2007

2 new areas start being tracked this weekend

both in London, should be interesting

Well done moomoo, you are collating a lot of information, which must take you ages!:T

I have also been using property bee since January its amazing as I think it gives a good clear picture of current prices and what some people are willing to reduce the price of their house by.

Shaz

neas

m00m00 wrote: »

it's all my own work in excel 2007

2 new areas start being tracked this weekend

both in London, should be interesting

Im trying to track the plymouth area at the moment.. .currently seeing 5-10k off asking prices on houses in the 100-200k bracket (2-3 bedroom houses)

m00m00

week 4
this board won't let me embed images so people who want to see the graphs I'm doing for this should look on the GHPC site mirror thread tonight.

NG15
28 reductions

largest reduction £15,000
Largest Percentage reduction 13.05%

average reduction £6,640
average Percentage reduction 4.38%

2 increases
largest increase £10000
largest percentage increase 10.01%

average increase £7,503
average percentage increase 6.39%

Average price of property reduced : £170,489

Status Change Available to STC : 7
Status Change STC to Available : 3


Property on market 846

Percentage of property on market reduced in past week 3.31%
Percentage of property on market status change to STC 0.83%

Change on previous week +6


last weeks reductions 12
change in reductions +16

cumulative total of reductions (4 weeks) 85


GU21 (Woking, Surrey)

27 reductions

largest reduction £25,050
Largest Percentage reduction 7.69%

average reduction £9852
average Percentage reduction 3.02%

average price of property reduced : 316087

Status Change Available to STC : 16
Status Change STC to Available : 2


Property on market 793

Percentage of property on market reduced in past week 3.40%
Percentage of property on market status change to STC 2.02%

Change on previous week -3

last weeks reductions 23
change in reductions +4

cumulative total of reductions (2 weeks) 50


NG 9

56 reductions

largest reduction £50,005
Largest Percentage reduction 13.16%

average reduction £8,601
average Percentage reduction 4.51%

4 increases
largest increase £9951
largest percentage increase 9.95%

average increase £7463
average percentage increase 5.92%

Average price of property reduced : £180114

Status Change Available to STC : 18
Status Change STC to Available : 7


Property on market 1340

Percentage of property on market reduced in past week 4.18%
Percentage of property on market status change to STC 1.34%

Change on previous week +9




last weeks reductions 38
change in reductions +18

cumulative total of reductions (3 weeks) 134


NG8

40 reductions

largest reduction £14950
Largest Percentage reduction 7.73%

average reduction £4260
average Percentage reduction 3.89%

3 increases
largest increase £4950
largest percentage increase 6.60%

average increase £2348
average percentage increase 2.81%

Average price of property reduced : £116368

Status Change Available to STC : 14
Status Change STC to Available : 2


Property on market 750

Percentage of property on market reduced in past week 5.33%
Percentage of property on market status change to STC 1.87%

Change on previous week -2


last weeks reductions 18
change in reductions +22

cumulative total of reductions (4 weeks) 100

York


81 reductions

largest reduction £35000
Largest Percentage reduction 9.11%

average reduction £9399
average Percentage reduction 3.96%

4 increases
largest increase £5000
largest percentage increase 2.70%

average increase £1885
average percentage increase 1.10%

Average price of property reduced : £236030

Status Change Available to STC : 33
Status Change STC to Available : 11


Property on market 2103

Percentage of property on market reduced in past week 3.85%
Percentage of property on market status change to STC 1.57%

Change on previous week +38




last weeks reductions 84
change in reductions -3

cumulative total of reductions (4 weeks) 312


WF6

8 reductions

largest reduction £7995
Largest Percentage reduction 8.00%

average reduction £4994
average Percentage reduction 3.60%

0 increase
largest increase
largest percentage increase

average increase
average percentage increase

Average price of property reduced : £156605

Status Change Available to STC : 1
Status Change STC to Available : 0


Property on market 305

Percentage of property on market reduced in past week 2.62%
Percentage of property on market status change to STC 0.33%

Change on previous week -1




last weeks reductions 12
change in reductions -4

cumulative total of reductions (3 weeks) 56


Wakefield

43 reductions

largest reduction £44950
Largest Percentage reduction 13.62%

average reduction £8010
average Percentage reduction 4.25%

2 increases
largest increase £14950
largest percentage increase 9.97%

average increase £9953
average percentage increase 7.05%

Average price of property reduced : £192518

Status Change Available to STC : 6
Status Change STC to Available : 4


Property on market 1296

Percentage of property on market reduced in past week 2.76%
Percentage of property on market status change to STC 0.54%

Change on previous week -7

last weeks reductions 36
change in reductions +7

cumulative total of reductions (4 weeks) 129

LS1 (+1 mile radius) (Leeds City Centre)

28 reductions

largest reduction £24950
Largest Percentage reduction 16.10%

average reduction £7546
average Percentage reduction 5.19%

3 increases
largest increase £5050
largest percentage increase 4.65%

average increase £3017
average percentage increase 2.32%



average price of property reduced : 146062

Status Change Available to STC : 14
Status Change STC to Available : 3


Property on market 1204

Percentage of property on market reduced in past week 2.29%
Percentage of property on market status change to STC 1.14%

Change on previous week +21

last weeks reductions 21
change in reductions +7

cumulative total of reductions (2 weeks) 49

m00m00

2 london postcodes coming next week