Is there an easy way to compare Asking Price vs Sold Price?

DRP

Hi, I've used the forum search function but have not found anything relevant so I was hoping for some info.

A website like Zoopla is useful to identify house sold prices (after 3 months) and Zoopla/Property Bee is able to give information on reductions in asking price on currently marketed properties.

Is there an easy way to combine this information and compare the asking price of a property to what it actually sold for. Obviously there are a huge number of variables like condition of the house or urgency of the vendors to sell, but it may be a useful tool for buyers if you could work out the average % selling/asking price for say, a 3 bed semi in a specific area in the last 12 months .... :money:


does anyone know of an online (or other ) analysis tool like this?

googler

Log in a spreadsheet the properties coming to market in the area that you're interested in. Log price changes as they occur.

Get sold prices from Zoopla when they update at the beginning of each month. Enter these on the spreadsheet to match the properties already logged.

Note in passing how many didn't sell ....

Calculate (Selling Price - Asking Price) / Asking Price for each property, and set the format of the resultant field to percentage.

DRP

googler wrote: »

Log in a spreadsheet the properties coming to market in the area that you're interested in. Log price changes as they occur.

Get sold prices from Zoopla when they update at the beginning of each month. Enter these on the spreadsheet to match the properties already logged.

Note in passing how many didn't sell ....

Calculate (Selling Price - Asking Price) / Asking Price for each property, and set the format of the resultant field to percentage.

Hi thanks for your response

Well , yes in the period I have been searching I have been recording houses in my area in this way.

Because of the delay in publishing sold prices, and having a large/changing area to look in , that method isn't possible in a practical way.

This would seem to be a simple task for a computer program / website to sift through houses as they come on to the market and append each record with price drops and eventual sold prices (after the 3 month wait), then make the data available as a search similarly to rightmove...

googler

It would be a cinch if every agent in the land sent a data feed to 'the program' or to one property portal that the program ran against, but even if this were to be done for the main E&W portal, Rightmove, there'd still be data missing, because not everything is listed therein.

Oh, and round my way, Zoopla sold prices are available 1 month after the month of settlement - a sale on 15th February, say, is on Zoopla just after 1 April ....