A Glimpse Into The "ACRIS" Closed Sales Lag
A: I think every Manhattan broker should read this and fully understand the final lag in the Closed Sales equation. Quarterly market reports are uber-lagging and represent a market from say 3-6 months ago, at minimum. We all know that when a transaction closes the deal is done and should be available for use as a comparable sale. But when it gets recorded as public record is another story. For this piece, you must understand the difference between the SALE DATE and the RECORDED/FILING DATE. I've been going over recorded sales in the past few weeks tracking this 'gap' and let me tell you, 'its all over the place'!
Let me show you. First off, the date I picked for this discussion was February 28th, 2011 where we have 58 Recorded Sales Filings. Now, let me break down the lag between "filing date" and actual "sale date" this way first and then I will show you one of the crazy outliers:
Of the 58 Recorded Sales filings on February 28th, 2011:
Talk about an outlier! If we wanted to measure the average lag between "filing date" and actual "sale date" of the transaction, think of how a sale from over 8 years ago would screw with the data! It sounds like a mistake, but it's not! Let me show you.
The sale from January 28th, 2003 was at 99 Jane Street, unit 4D. Let me show you a) the ACRIS filing and b) a partial snapshot of UrbanDigs list of all filings on Feb. 28th, 2011:
1. The ACRIS Recorded Document for 99 Jane Street, Unit 4D

2. UrbanDigs Confirmation Plus Other Feb 28th, 2011 ACRIS File Recordigs
Below is a partial snapshot showing most of Page 1 of 3 for Feb 28th sales filings. The 58 sales are before 'cleansing rules' kick in to eliminate the non-residential sales - think storage unit sales, duplicates, and other strange transfers that always need to be excluded from market metrics.
For ease, I sorted by SALE DATE so you can see the earliest sales that finally made its way to public record about a week ago. The 99 Jane St, unit 4D sale in 2003 is outlined at the top! Then you got 7, count em', 7 recorded filings of sales that occurred in 2010! I highlighted the 2003 sale in red border and the seven 2010 sales in green border:

So, 14% of the 58 residential sales filings recorded on February 28th, 2011, actually sold and closed in January, February, November & December of 2010! Full disclosure folks! Its important to understand the lag because these are the sales that are fueling brokerage firms' Quarterly Market Reports! There has to be a way government can make the public recording of NYC sales transactions more efficient! I think we all deserve to have the best and most recent data available to us, in the fastest possible way. High quality analytics! That is the mission of UrbanDigs.com in the past, right now, and in the future.



Posted by David
Mon Mar 7th, 2011 11:59 AM
How do the ACRIS sales differ form the rolling sales update from the Department of Finance?
Posted by urbandigs
Mon Mar 7th, 2011 12:04 PM
David,
Same data source, just different application that is subject to be lagging and less complete. When I compared them about 2 yrs ago, before we started development of this site's new tools, I found:
1. Dept of Finance public XLS files were not a daily update..rather a lagging monthly update..did this change?
2. It was incomplete and not cleansed. I found that public xls sales files were missing some sales that have doc and doc ID on Acris.gov site
It was necessary to find another way to get the data. I have NOT looked into the current dept of finance xls files in a long time. Has it changed? Does it offer daily updates? Can you see Friday's total filings?
Posted by David
Mon Mar 7th, 2011 12:30 PM
The rolling sales update, I believe, is a quarterly update and still has some incomplete filings.
Posted by urbandigs
Mon Mar 7th, 2011 01:12 PM
ok thanks David...yes, that was my finding too..I could have sworn there was a monthly updated xls file there somewhere though! So on March 1st, January would be released..something like that
Posted by Doug Heddings
Mon Mar 7th, 2011 08:53 PM
Very well done Noah!
Posted by urbandigs
Tue Mar 8th, 2011 07:15 AM
ty ty Doug!!