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

• Prosper API Now Has ListingKey On Loan Table A nugget that I missed from the Mid August Prosper Upgrade is that the loan and listing objects in the API are now tied together with a Prosper provided listing key on the loan object.  While I had achieved 99.8% loan to listing matching, I was still missing a few. Leporello......
• Successfully Added ListingKey to Loan Table Prosper's public data does not have a primary key foreign key relationship between the loan and listing table.  This keeps one from being able to correlate loans to listings which prosper does intentionally for privacy reasons. However, the other data in both tables is adequate to match on ~99.8% of the loans.  I......
• UnderAppreciated Listings RSS Feed Update -- Greater than $3MM in Fundable by Rate, Amount, and DTI Listings Expired I started my RSS feeds on March 18th...  I thought I would check in on my favorite (Underappreciated Listings)...  There have been 827 listings profiled, requesting to borrower $9,057,314 or $10,952.01 per loan on average. Here is the listing status break down... Status Total Amount Number Per Loan Cancelled $455,274......
• Prosper Has Returned with New and Improved Features! If you used the Prosper peer-to-peer lending service in the past, you’ll be happy to know that they’ve significantly enhanced many features of the service and are now accepting new borrowers and lenders. Using Prosper is now safer and more convenient than it’s ever been, making it an even better......
• Prime Borrowing on Prosper Hits Record Levels -- Febuary Marketplace Survey SAN FRANCISCO--(BUSINESS WIRE)--March 11, 2008--Spurred by the credit crunch, attractive rates, and lender demand for conservative assets, Prosper (www.prosper.com), America's largest people-to-people lending marketplace with over 600,000 members and $120 million in funded loans, reported that the number of prime borrowers (720+ credit scores) creating listings and obtaining loans continues......

Related Websites

• A Better Way To Lend Money To Friends & Family Lending money to friends and family can be a strain on the relationship (not to mention your finances). Seeing that you're doing well, everyone wants to hit you up for a small loan. If its a short-term thing its fine, but if you're worried about the borrowers ability to repay......
• Sweet Prosper is Back! Being that I am in debt elimination mode I haven’t talked about my investments that much.  But on February 15, 2007, I was intrigued by the idea of Prosper and have since built a very very small portfolio.  As the P2P Lending market grew so did the competition and Prosper......
• Finovate Startup 2009 Live Twitter I am attending Finovate Startup 2009. It is an action packed 1 day format which I belive will lend itself perfectly to a live twitter. Stay tuned it should be an amazing day. http://twitter.com/BlogTrafficExch In the break I have scheduled some talks with SimplFi, Mint, and Calendar Budget. I am......
• Prosper Update It's been a long time since I've made a mention of Prosper.com. The reason is that it hasn't been performing as I had hoped. I'm putting money into Prosper though one could conclude that I should stop. What's the cause for the change in my philosophy? Well, I found LendingStats.com......
• A Review of My Actual Prosper Account I have mentioned in the past that I really like P2P Lending, or Person to Person Lending.  I had previously talked about Prosper, when they brought back lending to New York, and most recently as an alternative source for liquid cash, but I have never given details about my account.......

Online Stores

• Single Router Bits Routers, Bits, Accessories Power Tools Tools Home Improvement
• Single Bits Drill Bits Power Tools Tools Home Improvement
• Single Screwdrivers Screwdrivers Hand Tools Tools Home Improvement
• Single Pliers Pliers Hand Tools Tools Home Improvement

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


Categories:

Prosper.com, Statistics, Tools

Tags:

azerbaijan, mozambique