Jump to content
House Price Crash Forum
Sign in to follow this  
mmt

Top Of The Flips

Recommended Posts

Using the publicly available land registry data set imported into a database, I've written a query to extract the top flippers nationwide from the start of 2013 to the end of the current data range (Feb 2014). That is, repeat sales since Jan 2013 that have made a profit, ranked by profit. The overall numbers are 4086 repeat sales made a profit, 467 made a loss, 208 even.

Share this post


Link to post
Share on other sites

Using the publicly available land registry data set imported into a database, I've written a query to extract the top flippers nationwide from the start of 2013 to the end of the current data range (Feb 2014). That is, repeat sales since Jan 2013 that have made a profit, ranked by profit. The overall numbers are 4086 repeat sales made a profit, 467 made a loss, 208 even.

Another 100,000+ are holding on 'hoping' to make a profit when the market picks up.

Share this post


Link to post
Share on other sites

Using the publicly available land registry data set imported into a database, I've written a query to extract the top flippers nationwide from the start of 2013 to the end of the current data range (Feb 2014). That is, repeat sales since Jan 2013 that have made a profit, ranked by profit. The overall numbers are 4086 repeat sales made a profit, 467 made a loss, 208 even.

What were the average buying and selling prices for those making a profit, and how much did the losers lose?

Share this post


Link to post
Share on other sites

Using the publicly available land registry data set imported into a database, I've written a query to extract the top flippers nationwide from the start of 2013 to the end of the current data range (Feb 2014). That is, repeat sales since Jan 2013 that have made a profit, ranked by profit. The overall numbers are 4086 repeat sales made a profit, 467 made a loss, 208 even.

Windy attempted sellers should get ready to chase the market down

did you include any estimates for moving/legal/stamp duty costs in working out who won and who lost?

Share this post


Link to post
Share on other sites

What were the average buying and selling prices for those making a profit, and how much did the losers lose?

average loss: 60,204

average profit: 57,179

selling average (winners): 227,500

selling average (losers): 180,045

Share this post


Link to post
Share on other sites

Thanks for posting. Interesting info.

So thats a 34% profit for the winners. Much higher than actual house price inflation. Its a shame these numbers tell us nothing about what was spent on the properties to bring them back to market. I was initially shocked that such a high percentage of flips were wildly "profitable", but thinking about it that should be expected since most would have no doubt had money spent on them. Once considering the work/money that was spent, I wonder how many were still profitable, and to what extent.

Share this post


Link to post
Share on other sites

Do you have it by region. Think most of the gains will be in london

Here are the top few ordered by number of transactions (sorry about the formatting):

winners:

{ "_id" : "BIRMINGHAM", "average" : 40888.81690140845, "count" : 71 }
{ "_id" : "LONDON", "average" : 103679.27272727272, "count" : 66 }
{ "_id" : "COUNTY DURHAM", "average" : 27576.59574468085, "count" : 47 }
{ "_id" : "SHEFFIELD", "average" : 34532.391304347824, "count" : 46 }
{ "_id" : "LEEDS", "average" : 32850.044444444444, "count" : 45 }
{ "_id" : "LAMBETH", "average" : 145961.34146341463, "count" : 41 }
{ "_id" : "NORTHAMPTON", "average" : 37262.0243902439, "count" : 41 }
{ "_id" : "WALTHAM FOREST", "average" : 120462.475, "count" : 40 }
{ "_id" : "WANDSWORTH", "average" : 161336.3, "count" : 40 }
{ "_id" : "MANCHESTER", "average" : 29736.842105263157, "count" : 38 }
{ "_id" : "LIVERPOOL", "average" : 42091.029411764706, "count" : 34 }
{ "_id" : "CITY OF BRISTOL", "average" : 59285.294117647056, "count" : 34 }
{ "_id" : "LEWISHAM", "average" : 107521.21212121213, "count" : 33 }
{ "_id" : "CARDIFF", "average" : 42420.53125, "count" : 32 }
{ "_id" : "WIRRAL", "average" : 47803.333333333336, "count" : 30 }
{ "_id" : "NEWHAM", "average" : 53861.55172413793, "count" : 29 }
{ "_id" : "CROYDON", "average" : 73813.72413793103, "count" : 29 }
{ "_id" : "SOUTHAMPTON", "average" : 39517.857142857145, "count" : 28 }
{ "_id" : "COVENTRY", "average" : 34600, "count" : 28 }
{ "_id" : "KENSINGTON AND CHELSEA", "average" : 494666.96428571426, "count" : 28 }
losers:
{ "_id" : "LEEDS", "average" : -9355.555555555555, "count" : 9 }
{ "_id" : "KENSINGTON AND CHELSEA", "average" : -1277873.125, "count" : 8 }
{ "_id" : "LIVERPOOL", "average" : -11981.375, "count" : 8 }
{ "_id" : "NORTHUMBERLAND", "average" : -6541.666666666667, "count" : 6 }
{ "_id" : "COUNTY DURHAM", "average" : -17208.333333333332, "count" : 6 }
{ "_id" : "NEWCASTLE UPON TYNE", "average" : -12166.5, "count" : 6 }
{ "_id" : "RHONDDA CYNON TAFF", "average" : -7075, "count" : 6 }
{ "_id" : "EAST DEVON", "average" : -38480, "count" : 5 }
{ "_id" : "LAMBETH", "average" : -57861, "count" : 5 }
{ "_id" : "BURNLEY", "average" : -6200, "count" : 5 }
{ "_id" : "BARNET", "average" : -56970, "count" : 5 }
{ "_id" : "WIRRAL", "average" : -24801.25, "count" : 4 }
{ "_id" : "BIRMINGHAM", "average" : -6125, "count" : 4 }
{ "_id" : "SWANSEA", "average" : -44987.5, "count" : 4 }
{ "_id" : "CORNWALL", "average" : -56625, "count" : 4 }
{ "_id" : "WALTHAM FOREST", "average" : -51748.75, "count" : 4 }
{ "_id" : "BRADFORD", "average" : -42875, "count" : 4 }
{ "_id" : "NEWCASTLE-UNDER-LYME", "average" : -6850, "count" : 4 }
{ "_id" : "KIRKLEES", "average" : -12237.5, "count" : 4 }
{ "_id" : "WANDSWORTH", "average" : -55937.5, "count" : 4 }

Share this post


Link to post
Share on other sites

Here are the top few ordered by number of transactions (sorry about the formatting):

winners:

{ "_id" : "BIRMINGHAM", "average" : 40888.81690140845, "count" : 71 }
{ "_id" : "LONDON", "average" : 103679.27272727272, "count" : 66 }
{ "_id" : "COUNTY DURHAM", "average" : 27576.59574468085, "count" : 47 }
{ "_id" : "SHEFFIELD", "average" : 34532.391304347824, "count" : 46 }
{ "_id" : "LEEDS", "average" : 32850.044444444444, "count" : 45 }
{ "_id" : "LAMBETH", "average" : 145961.34146341463, "count" : 41 }
{ "_id" : "NORTHAMPTON", "average" : 37262.0243902439, "count" : 41 }
{ "_id" : "WALTHAM FOREST", "average" : 120462.475, "count" : 40 }
{ "_id" : "WANDSWORTH", "average" : 161336.3, "count" : 40 }
{ "_id" : "MANCHESTER", "average" : 29736.842105263157, "count" : 38 }
{ "_id" : "LIVERPOOL", "average" : 42091.029411764706, "count" : 34 }
{ "_id" : "CITY OF BRISTOL", "average" : 59285.294117647056, "count" : 34 }
{ "_id" : "LEWISHAM", "average" : 107521.21212121213, "count" : 33 }
{ "_id" : "CARDIFF", "average" : 42420.53125, "count" : 32 }
{ "_id" : "WIRRAL", "average" : 47803.333333333336, "count" : 30 }
{ "_id" : "NEWHAM", "average" : 53861.55172413793, "count" : 29 }
{ "_id" : "CROYDON", "average" : 73813.72413793103, "count" : 29 }
{ "_id" : "SOUTHAMPTON", "average" : 39517.857142857145, "count" : 28 }
{ "_id" : "COVENTRY", "average" : 34600, "count" : 28 }
{ "_id" : "KENSINGTON AND CHELSEA", "average" : 494666.96428571426, "count" : 28 }
losers:
{ "_id" : "LEEDS", "average" : -9355.555555555555, "count" : 9 }
{ "_id" : "KENSINGTON AND CHELSEA", "average" : -1277873.125, "count" : 8 }
{ "_id" : "LIVERPOOL", "average" : -11981.375, "count" : 8 }
{ "_id" : "NORTHUMBERLAND", "average" : -6541.666666666667, "count" : 6 }
{ "_id" : "COUNTY DURHAM", "average" : -17208.333333333332, "count" : 6 }
{ "_id" : "NEWCASTLE UPON TYNE", "average" : -12166.5, "count" : 6 }
{ "_id" : "RHONDDA CYNON TAFF", "average" : -7075, "count" : 6 }
{ "_id" : "EAST DEVON", "average" : -38480, "count" : 5 }
{ "_id" : "LAMBETH", "average" : -57861, "count" : 5 }
{ "_id" : "BURNLEY", "average" : -6200, "count" : 5 }
{ "_id" : "BARNET", "average" : -56970, "count" : 5 }
{ "_id" : "WIRRAL", "average" : -24801.25, "count" : 4 }
{ "_id" : "BIRMINGHAM", "average" : -6125, "count" : 4 }
{ "_id" : "SWANSEA", "average" : -44987.5, "count" : 4 }
{ "_id" : "CORNWALL", "average" : -56625, "count" : 4 }
{ "_id" : "WALTHAM FOREST", "average" : -51748.75, "count" : 4 }
{ "_id" : "BRADFORD", "average" : -42875, "count" : 4 }
{ "_id" : "NEWCASTLE-UNDER-LYME", "average" : -6850, "count" : 4 }
{ "_id" : "KIRKLEES", "average" : -12237.5, "count" : 4 }
{ "_id" : "WANDSWORTH", "average" : -55937.5, "count" : 4 }

Actually, those numbers don't seem right. Will re-check the query when I have time.

Share this post


Link to post
Share on other sites

Actually, those numbers don't seem right. Will re-check the query when I have time.

Ah, it's by county. I didn't realise there was a county of London.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • The Prime Minister stated that there were three Brexit options available to the UK:   209 members have voted

    1. 1. Which of the Prime Minister's options would you choose?


      • Leave with the negotiated deal
      • Remain
      • Leave with no deal

    Please sign in or register to vote in this poll. View topic


×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.