We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
PLEASE READ BEFORE POSTING: Hello Forumites! In order to help keep the Forum a useful, safe and friendly place for our users, discussions around non-MoneySaving matters are not permitted per the Forum rules. While we understand that mentioning house prices may sometimes be relevant to a user's specific MoneySaving situation, we ask that you please avoid veering into broad, general debates about the market, the economy and politics, as these can unfortunately lead to abusive or hateful behaviour. Threads that are found to have derailed into wider discussions may be removed. Users who repeatedly disregard this may have their Forum account banned. Please also avoid posting personally identifiable information, including links to your own online property listing which may reveal your address. Thank you for your understanding.
House Price Calculator

Pigmy
Posts: 33 Forumite
Hi,
I wrote a little Excel spreadsheet that I thought that someone else might find useful. It basically uses the data that is publicly available on the Land Registry website on historical house prices for a region to determine the shift up (or down!) in prices. Then you enter the historical sales price and date for a property, either the one you are after or a similar one (available from most good house sales websites), and the spreadsheet tells you what that property is now worth. I currently only have the data for postcode PO2 (Portsmouth) loaded as that is where I have been looking but if you want a different area I can show you how to do that. Hopefully the linky thing below works.
http://
redsailsconsulting.co.uk/PO2 Property Value Calculator.xls
I would give a bit of caution about getting too hung up on numbers - at the end of the day if you like the property then you'll pay what you think its worth, but this gives some interesting reading in a falling market.
Anyway, if you want details of how to load your own postcode area then let me know.
I wrote a little Excel spreadsheet that I thought that someone else might find useful. It basically uses the data that is publicly available on the Land Registry website on historical house prices for a region to determine the shift up (or down!) in prices. Then you enter the historical sales price and date for a property, either the one you are after or a similar one (available from most good house sales websites), and the spreadsheet tells you what that property is now worth. I currently only have the data for postcode PO2 (Portsmouth) loaded as that is where I have been looking but if you want a different area I can show you how to do that. Hopefully the linky thing below works.
http://
redsailsconsulting.co.uk/PO2 Property Value Calculator.xls
I would give a bit of caution about getting too hung up on numbers - at the end of the day if you like the property then you'll pay what you think its worth, but this gives some interesting reading in a falling market.
Anyway, if you want details of how to load your own postcode area then let me know.
0
Comments
-
Certainly an interesting spreadsheet, but I suspect that regional and locational variations will have a bigger impact on the bottom line figures.
zoopla.co.uk attempts to do the same thing online with varying degress of success.
In the final analyis, your right that people shouldn't get too hung up on the price... it's only worth what you're or someone else is prepared to pay for it!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350K Banking & Borrowing
- 252.7K Reduce Debt & Boost Income
- 453.1K Spending & Discounts
- 243K Work, Benefits & Business
- 619.9K Mortgages, Homes & Bills
- 176.5K Life & Family
- 255.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 15.1K Coronavirus Support Boards