Talk: Market: Discussing 'The SE "recorded sales" tool does not give an accurate measure of sales activity'
 

email updates RSS The SE "recorded sales" tool does not give an accurate measure of sales activity

16 comments
about 7 weeks ago

If you look at the past seven days you see 7 sales.

If you look at the past 14 days you see 108 sales.

If you look at the past 30 days you see 558 sales.

If you look at the past 60 days you see 1721 sales.

Most recent data would suggest that sales have fallen off a cliff. That seems very unlikely. What is more likely is that short term sales are being continually revised. As such, the short term numbers do not provide an accurate picture of what is taking place in the market.

Don't know if the "contracts signed" tool on urbandigs is more accurate.

about 7 weeks ago

I've been thinking about this. If the count is accurate, the market is really fried. I don't think it's possible. I believe UD uses the Streeteasy count. Is there any other way of checking sales? Calling UD for an answer.

about 7 weeks ago

Right, continually revised.

SE is getting the recorded-sales data from the city. The city scans and data-enters sales in clumps, so sales dated, e.g., 10/20 will hit ACRIS and SE over the course of many days. Sales aren't always reported to the city in a timely manner, either. That's the way it appears to work, anyway.

Right now the newest co-op sale is dated 10/21, but if you check tomorrow there might be more 10/21s and maybe some 10/22s and 10/23s.

So, if you're using any of this to gauge number of transactions, it's not much use except over the long term.

about 7 weeks ago

Nevertheless, the charts looked quite differently a couple of months ago.

about 7 weeks ago

It can take a few days to a few weeks for sales to be recorded, so the 30-day figure is pretty accurate, but the 1-day is a small fraction of actual sales. If you want to see a trend, you can track the 60-day number over time.

about 7 weeks ago

I'm just watching the UD inventory. Steadily growing again...
http://www.streeteasy.com/nyc/talk/discussion/15694-inventory-back-over-9500-again

about 7 weeks ago

sorry, meant to post the direct link...

http://www.urbandigs.com/charts.html

about 7 weeks ago

I wonder what is the margin for error?

about 7 weeks ago

Maly, what do you mean by "error"?

about 7 weeks ago

Well, SE data is not perfect, so even scrubbing for duplicates must leave a margin for error. I wonder if Noah has done 100% checks to get the margin of error. I occasionally find listings in my searches that have been sold, but are still listed as available or in contract months later.

about 7 weeks ago

10022 how do you know that big drop in inventory in the six-month chart can be entirely accounted for by increased sales?

Maybe some of it -- maybe a big chunk of it -- is due to sellers pulling their listings, and only a portion of it is due to a bump in sales activity.

Just wondering.....

about 7 weeks ago

Ok. I think you mean data quality or accuracy, which is not really the same thing as margin of error (which refers to sampling error).

Well, maybe think about it this way: even if the data isn't perfect, it probably has the same level of accuracy over time. If you are concerned that the quality of the data is changing over time, that's interesting (but I'm not really hearing that).

So, I wouldn't be concerned about accuracy of the data if you are comparing against historical levels, which is how most people use this data. If you are trying to do absolute arithmetic with the data, that's a different story.

about 7 weeks ago

I am actually more concerned about the noise because UD gives charts based on the 1-day data, which is random. This is the least interesting measure. I'd like to see 30-day data trend on contracts and sales. It would also be nice to have some idea of the accuracy of the data on listings, but that's more academic, you're right.

about 7 weeks ago

NWT: while I agree with you, I don't think it's quite right to explain it as the data gets recorded in "clumps". It's simply that the data recording is time lagged, and that SE uses "date of sale" (which I think is the correct thing to do) rather than "recording date". So, you will ALWAYS see very few sales in the last 7 days since almost no sales get recorded that quickly. So if a sale gets recorded 8 days after it occurs, the first time it shows up is after the "last 7 days" time period.

However, at least in Manhattan these days, from what I've seen most get recorded within 30 days. So the difference between 30 days and 60 days is meaningful, but I think you have to make an adjustment on the 30 days for the lack of recording of the most recent closings. What I guess I'd really like to see is the number of sales from 2 weeks to 6 weeks ago compared to 6 weeks to 10 weeks ago. I'm not familiar with the SE tools for insiders, so I don't know what's possible.

about 7 weeks ago

Yeah, I'm probably mis-guessing the cause of the ebb and flow of data. I'll do a query every day or so on the last 14 days of co-op closings, and when nothing's new I imagine piles of forms stacking up downtown.

SE does let you edit the query URL (e.g. <<.

about 7 weeks ago

(Another ten tries and I'll remember how to escape angle brackets.) SE does let you edit the query URL (e.g. less than 21 days rather than less than 14 days) but doesn't let you do a search like "more than 14 days AND less than 60 days."

16 comments

Add your comment