Skip Navigation

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

Started by Topper
over 16 years ago
Posts: 1335
Member since: May 2008
Discussion about
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.
Response by mimi
over 16 years ago
Posts: 1134
Member since: Sep 2008

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.

Ignored comment. Unhide
Response by NWT
over 16 years ago
Posts: 6643
Member since: Sep 2008

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.

Ignored comment. Unhide
Response by mimi
over 16 years ago
Posts: 1134
Member since: Sep 2008

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

Ignored comment. Unhide
Response by maly
over 16 years ago
Posts: 1377
Member since: Jan 2009

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.

Ignored comment. Unhide
Response by nyc10022
over 16 years ago
Posts: 9868
Member since: Aug 2008

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

Ignored comment. Unhide
Response by nyc10022
over 16 years ago
Posts: 9868
Member since: Aug 2008

sorry, meant to post the direct link...

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

Ignored comment. Unhide
Response by maly
over 16 years ago
Posts: 1377
Member since: Jan 2009

I wonder what is the margin for error?

Ignored comment. Unhide
Response by SkinnyNsweet
over 16 years ago
Posts: 408
Member since: Jun 2006

Maly, what do you mean by "error"?

Ignored comment. Unhide
Response by maly
over 16 years ago
Posts: 1377
Member since: Jan 2009

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.

Ignored comment. Unhide
Response by GraffitiGrammarian
over 16 years ago
Posts: 687
Member since: Jul 2008

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.....

Ignored comment. Unhide
Response by SkinnyNsweet
over 16 years ago
Posts: 408
Member since: Jun 2006

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.

Ignored comment. Unhide
Response by maly
over 16 years ago
Posts: 1377
Member since: Jan 2009

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.

Ignored comment. Unhide
Response by 30yrs_RE_20_in_REO
over 16 years ago
Posts: 9897
Member since: Mar 2009

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.

Ignored comment. Unhide
Response by NWT
over 16 years ago
Posts: 6643
Member since: Sep 2008

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. <<21 days rather than <<14 days) but no way to search ">>x and <

Ignored comment. Unhide
Response by NWT
over 16 years ago
Posts: 6643
Member since: Sep 2008

(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."

Ignored comment. Unhide

Add Your Comment