P2P Lending -- News, Information, Borrowing and Lending Strategy


Does Prosper’s Public Data Allow Loan to Listing Correlation?

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.

 


January 13, 2007 | Filed Under Prosper.com, Statistics, Tools 

Useful Info:
Related Articles
Successfully Added ListingKey to Loan Table
Prosper API Now Has ListingKey On Loan Table
Loan to Listing Correlation — 99.8% With 100% Accuracy
Are 2nd time Borrowers a Better Risk?
General Opinion of New Prosper Forums

← New Loan — debt consolodation [sic] — $25,000 at 15.00% — B Credit — DTI 15%

What is my Internal Rate Of Return on Prosper? →



comments

Leave a Reply




Prosper America's Leading Online Lending Marketplace

Financial Web - The Independent Financial Portal
Need a loan before payday? Trying hard to settle debt? Get back on track, learn all about consolidating your debt and find out where to get credit cards for bad credit.