Selling prices quite a bit lower than asking prices

fret_wimp2

Im doing an informal study of current asking vs selling prices.

Im finding that Selling prices are quite a bit lower than Asking prices, actually over 8% in Dublin and a bit more outside of Dublin.

Im asking if anyone can help explain this, seeing as all we hear in the discussions and on tv is that bidding wars push prices way above asking. The data simply doesn't show that, on average.


Asking prices are coming from MyHome (couldn't use daft for this purpose) and is a snapshot of the data mid February.

Selling prices are coming from Property Price register, and sample is Dec 2017 to present, to keep prices relatively recent. Prices are adjusted for VAT where necessary.

Outliers have been removed so only including property <= €1,000,000


Appreciate any educated guesses or actual industry knowledge to help explain this.

lawred2

fret_wimp2 wrote: »

Im doing an informal study of current asking vs selling prices.

Im finding that Asking prices are quite a bit lower than selling prices, actually over 8% in Dublin and a bit more outside of Dublin.

Im asking if anyone can help explain this, seeing as all we hear in the discussions and on tv is that bidding wars push prices way above asking. The data simply doesn't show that, on average.


Asking prices are coming from MyHome (couldn't use daft for this purpose) and is a snapshot of the data mid February.

Selling prices are coming from Property Price register, and sample is Dec 2017 to present, to keep prices relatively recent. Prices are adjusted for VAT where necessary.

Outliers have been removed so only including property <= €1,000,000


Appreciate any educated guesses or actual industry knowledge to help explain this.

I'm failing to see the contradiction

fret_wimp2

The contradiction is that if you read threads here or listen to general opinion, everything goes for way above asking.

Is everyone really that out of touch with how the market appears to be working?

lawred2

fret_wimp2 wrote: »

The contradiction is that if you read threads here or listen to general opinion, everything goes for way above asking.

Is everyone really that out of touch with how the market appears to be working?

but you've just said yourself that

Im finding that Asking prices are quite a bit lower than selling prices, actually over 8% in Dublin and a bit more outside of Dublin.

fret_wimp2

I see, my bad, very badly placed typo.

Corrected, it, should have read:

Im finding that Selling prices are quite a bit lower than Asking prices, actually over 8% in Dublin and a bit more outside of Dublin.

Del2005

fret_wimp2 wrote: »

Im doing an informal study of current asking vs selling prices.

Im finding that Selling prices are quite a bit lower than Asking prices, actually over 8% in Dublin and a bit more outside of Dublin.

Im asking if anyone can help explain this, seeing as all we hear in the discussions and on tv is that bidding wars push prices way above asking. The data simply doesn't show that, on average.


Asking prices are coming from MyHome (couldn't use daft for this purpose) and is a snapshot of the data mid February.

Selling prices are coming from Property Price register, and sample is Dec 2017 to present, to keep prices relatively recent. Prices are adjusted for VAT where necessary.

Outliers have been removed so only including property <= €1,000,000


Appreciate any educated guesses or actual industry knowledge to help explain this.

Unless you are comparing the ad with the eventual sales price its not a correct correlation.

But what could be happening is that people are now asking too much, say 20% increase, and they are selling for less than the asking price which still gives a 8% increase from last year

cruizer101

Ah was wondering myself, might want to get thread title updated.

Can you share your work in any way for others to see, I'd be interested in looking at it as am in process of looking for house but also have interest in this kind of data and recently did course on data analytics.

Also are you considering location and are some places generally higher or lower.

fret_wimp2

Del2005 wrote: »

Unless you are comparing the ad with the eventual sales price its not a correct correlation.

I agree to a point,but this applies to any sample dataset. central tenancy measures such as mean, median help at least to get a picture of whats going on, from a high level, otherwise no studies would ever get done.

Del2005 wrote: »

But what could be happening is that people are now asking too much, say 20% increase, and they are selling for less than the asking price which still gives a 8% increase from last year

Thats a fair observation. Over 8% in 3 months is lot though.
Figures show a lot more outside of dublin, over the rest of the country.

cruizer101 wrote: »

Can you share your work in any way for others to see

Not really, at least at this point, the data is pretty raw, being munged in python and answers or at least theories need to be found for issues such as this one before making anything available, otherwise its just incorrect.

.......

This post has been deleted.

whatever76

not in Cork - I can tell you right now anything in a decent location is going WAY above the asking .

eg. Asking 275 - > Sold for at least 325k as I had to bow out at that point !!

fret_wimp2

....... wrote: »

This post has been deleted.

Im not, its not a direct comparison.
MyHome data & asking price is a snapshot of property for sale mid feb.
Selling price comes from the property price register and is from Dec 2017 to start of End of February.

Dec and Jan could account for some variation but 8% seems very high.

fret_wimp2

whatever76 wrote: »

not in Cork - I can tell you right now anything in a decent location is going WAY above the asking .

eg. Asking 275 - > Sold for at least 325k as I had to bow out at that point !!

Not being smart, but anything, or just a few desirable properties? has this happened multiple times?
Your statement is exactly why im asking the quesiton, discussions here indicate selling prices are generally above asking.

whatever76

desirable properties within that price range in the city .... happened to e at least 4 times in last 10 month where I kept getting out bid .. even one was a do upper and I had to bale as it was getting to close to my limit for a do upper and needed money to do up and I lost out !

.......

This post has been deleted.

fret_wimp2

....... wrote: »

This post has been deleted.

I dont see how an average price is not a relevant comparison.

Imagine im sampling the number of fish in a section river. Each month i go back to take a new sample, its not the same fish im counting, but im getting a number of samples and over time will get a reasonable average.

If i have 200 properties in an area i can get the average price of those 200 properties. How is it not reasonable to compare this to the selling price of 200 properties in the same area?

GingerLily

Your method is severely flawed........

Lumen

Maybe the expensive ones are not selling!

fret_wimp2

GingerLily wrote: »

Your method is severely flawed........

Perhaps, could you expand a little please so that i might revise it?

.......

This post has been deleted.

fret_wimp2

....... wrote: »

This post has been deleted.

Fair point. PPR data simply doesn't contain that granularity of information, probably best abandon this avenue. Thanks for the help, was is genuinely useful.

Lumen

fret_wimp2 wrote: »

Fair point. PPR data simply doesn't contain that granularity of information, probably best abandon this avenue. Thanks for the help, was is genuinely useful.

You have to match ads against PPR entries. Some on thepropertypin have attempted it. It's hard. Maybe easier now with eircodes?

Are daftdrop and collapso still working?

elainers

fret_wimp2 wrote: »

GingerLily wrote: »

Your method is severely flawed........

Perhaps, could you expand a little please so that i might revise it?

I would agree with GingerLily. The best comparison is individual property ad compared to individual property sales price gap and understand how that gap % tracks across a large volume of sales. 

This doesn't seem to be what you're doing - you seem to be taking asking prices from Feb 2018 and sales prices from December - March 2018. Those properties in the December - March 2018 PPR with those sales prices could have been listed up to a year ago and the prices both asked and paid in the market have increased since then. This would likely account for the gap you've observed.

If you want to take an average from each data source separately, you need to account for the lag effect in some way. And that's difficult as it varies dramatically depending on the property. Time from listing to going sale agreed is likely to vary by property, location and I would imagine season. 

12 weeks has always been the minimum I have heard to go from sale agreed (not from listing) to transfer of the property. In the case of new builds, it can be 9-12 months if build time is required. Probate sales are almost always longer than 12 weeks and anything where a solicitor is slow or a vendor is in a chain will also impact. So the lag in listing to sale agreed to sale date can vary dramatically. 
Then you have the lag in terms of logging the sale price in the PPR. Do agents do this immediately on sale? And if not, what is the lag? 

I'd imagine it's hard to settle on an average time lag so you could correctly time the PPR to Myhome comparison. As a result, I'm not sure you can do what you're trying to do by counting averages at specific times.

davo10

Unless I'm reading this incorrectly, the biggest flaw in your research is that you are applying price comparison in reverse.

I could be wrong, but you are using historical sales data and applying it to currant asking price. Instead of concluding that asking price is going up as time has gone on, you are concluding that sale price in the past is lower than asking price now, then deducing sale price < asking price.

If you want to do a more accurate study, take a snap shop of 200 properties advertised on daft/myhome today, then in 6 months time check the property register to see how much they sold for.

Michael D Not Higgins

Mod note: thread title updated due to typo.

GingerLily

fret_wimp2 wrote: »

GingerLily wrote: »

Your method is severely flawed........

Perhaps, could you expand a little please so that i might revise it?

You cannot and shouldn't directly compare the two datasets, they aren't really comparable. Apples and oranges really.

You don't have the data to prove or disprove what you want.

dudara

I’d also suspect that lower prices are being deliberately recorded on the property register, and there’s probably an element of cash in hand accompanying some sales.

Kyta

My house was on the PPR about 3 weeks after closing date. I am not sure who publishes this, solicitor or estate agent?

dudara wrote: »

I’d also suspect that lower prices are being deliberately recorded on the property register, and there’s probably an element of cash in hand accompanying some sales.

That sounds very risky for both buyer and seller in my opinion, as when the contracts are signed either party can enforce the contract at stated price. Buyer could then say "what extra cash?".

What is purpose of publishing lower prices on PPR? Maybe CGT avoidance for selling of investment properties?

Lumen

Kyta wrote: »

My house was on the PPR about 3 weeks after closing date. I am not sure who publishes this, solicitor or estate agent?

Comes from solicitor's filing of the stamp duty return. Six week limit IIRC. Some transactions don't have stamp duty, those between spouses, civil partners, divorcers etc.

wench

Kyta wrote: »

My house was on the PPR about 3 weeks after closing date. I am not sure who publishes this, solicitor or estate agent?

Neither, it is the Revenue Commissioners.
It comes from the stamp duty return which should be done within a month of the transaction.

Michael D Not Higgins

Kyta wrote: »

My house was on the PPR about 3 weeks after closing date. I am not sure who publishes this, solicitor or estate agent?



That sounds very risky for both buyer and seller in my opinion, as when the contracts are signed either party can enforce the contract at stated price. Buyer could then say "what extra cash?".

What is purpose of publishing lower prices on PPR? Maybe CGT avoidance for selling of investment properties?

The data is a republishing of the price declared by the conveyancing solicitor for stamp duty purposes to the Revenue. A solicitor is very unlikely to misdeclare the price paid however buyers and sellers may do a side deal without the solicitor's involvement. The number of these occurring is small in my opinion.

.......

This post has been deleted.