Using today’s public data, 98% of the time I can correlate loans in arrears to the listing with 100% accuracy.

There are 488 loans with statuses not equal to paid as expected:

Select count(*) from loan where status!=’Paid’ and status!=’Current’ and status!=’Payoff in progress’

I have a sql statement that can accurately generate the listing key or listing number (and hence the borrower) for 482.  

At this time I am intentionally keeping my sql statement under wraps, pending a response.  It is not a simple primary key foreign key join, but it is a single select.  Since there isn’t a primary key foreign key relationship in the data provided by prosper, I infer that they don’t want you to be able to correlate listings to loans. As that is not public information.  And yet via the public information it can be done.

Overtime, with higher loan volumes I expect the percentage of the number that can be 100% accurately identified to go down, but I will always be able to find some late loan’s listing numbers.

 

Related posts:

• Import Prosper.com Listing, Loan, Group, Member Data into Microsoft Sql Server 2000 Prosper.com makes all publicly available data accessible via a data export.  They also provide tools for importing that data into Microsoft Sql Server 2005.  What...
• Analyze a Loan Using Crystal Report and Data Export Since starting this blog I have reviewed several loans.  Since then I have developed a basic crystal report to analyze a loan (DTI, Amount, Credit, and Lender Rate)...
• Listings, Unique Bidders, Loans, Average Interest Rate, and Total Amount Lent Some of these are leading indicators and some are trailing. Do you see a pattern? Month # Listings # Unique Bidders # Loans Average Interest Rate...
• All RateLadder.com Loan Basic Information I have created 2 pages and will add more as needed: 2006 Loans and 2007 Loans. On these pages you will find all of the...
• Another Loan Cancelled Automatically by Prosper.com. Thank you!!! I just got an email from Prosper.com cancelling a listing on which I had been a winning bidder because some of the information is the...

If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Prosper.com, Statistics, Tools

Tags:

azerbaijan, mozambique