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 think this is really bad because the data is freely and openly available.  While I am under Prosper Terms of Service as a lender, the link provided below requires no agreement.  That means a lay person can download the data use similar techniques to find and publish all late loans with links to the listings in turn linking to the actual borrowers.

I started off trying to produce a single sql statement to perform the correlation.  However, after a couple of days of thought and experiments, I have changed my strategy for producing a loan to listing link out of the freely available data from prosper.

The approach I am taking now adds a listingkey column to the loan table. (Very useful for me since I use crystal reports.)  It takes several sql statements to add the column and set the value without duplicates through a multipass approach.  Today’s data yielded 7575/7591 loans identified… 99.8%.

The entire process takes less than 10 seconds.

The Prosper data is openly and freely available here: ProsperDataExport_xml.zip

I am still not sure of the legal or moral arguments around publishing the sql script to the world, however… A $5 dollar donation and a request (kevin at rateladder.com) will get you a copy for personal use.  Don’t share.  Don’t publish. Your internal use only for analyzing loan opportunities.  Don’t attribute loan/listing correlation to RateLadder for any purpose without prior written permission. No Warranty. No promise to be accurate. Past success is no guarantee it will work in the future.

 

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 they don't provide is a mechanisms for getting this data into other databases, specifically in my case Microsoft Sql Server 2000.  I have succeeded in......
• New Loan Funded — Finance for an ESTABLISHED Business — $25,000 at 24% — B Credit — DTI 1392557% A new loan funded (Finance for an ESTABLISHED Business – $25,000 at 24%).  I participated via a manual bid the loan was Autofunding.  The borrower had B credit and a 1392557% DTI (unverifiable income).  As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10 or less delinquencies......
• 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......
• Track Prosper Referrals with ProProsper Followup Just a quick followup to the Prosper referral tracking with ProProsper.  Here is the email sent to me this morning detailing my active listings... Referral bepmike48     Listing: Guarenteed Money for Simple loan Amt=5000.0000(25.00) CG=A DTI=0.09 Open For Duration Lender Rate=0.0625 Referral bigdog1     Listing: deck and bills......
• Rateladder Referral Listing: Guarenteed Money for Simple loan Guarenteed Money for Simple loan This is the cleanest A I have ever seen. I am a little surprised that it is not a AA. Account Verified, DTI 9%, A Credit. CLEAN! Purpose of loan: Supplement stock porfolio for more diversified lending (explain what you will be using this loan......

Related Websites

• LendingClub vs. Prosper Recently, I had come across an article about zopa.com and it really peaked my interest on peer-to-peer lending. In researching more about Zopa, I also came across two other major peer-to-peer lenders: Prosper and LendingClub. I researched both Prosper and LendingClub a bit and decided I liked LendingClub better, so......
• Two Monday Thoughts About Prosper If you've spent any time in the archives or if you are a long time reader, you'll know that I used to write about Prosper.com quite often. I've since taken this blog in a more general finance direction. However, I find that I need to continue to cover the peer-to-peer......
• Improving Money Behavior with Online Budget Tools We have all heard (or experienced ourselves) that "there is too much month left at the end of the money" and "I just don't know where all my money goes!"  These statements are used to explain why debt reduction plans are not implemented or cannot be completed.  Anyone with a computer......
• Money Saving Mondays: How to know if your loan should be refinanced I went into the bank the other day to see if I should refinance our car loan. I have really outstanding credit and I wondered if I could parley that into a lower interest rate, shorter term or lower payment. Turns out that I could do all three, but......
• What Happened to Prosper on Lazy Man? Last week, Get Rich Slick asked the question, What Happened To All The Prosper.com Blogs? Two years ago, along with RateLadder, I probably wrote about Prosper more than most personal finance bloggers. So when RichSlick asks why the blogs have seemingly gone silent, I feel that I should stand up......

Online Stores

• Table Birdhouses Bird & Wildlife Accessories Yard, Garden & Outdoor Living Nursery
• Data Logging Rain Gauges Garden Décor Yard, Garden & Outdoor Living Nursery
• Table Saws Saws, Blades, & Accessories Power Tools Tools Home Improvement
• Data Logging Infrared Thermometers Garden Décor Yard, Garden & Outdoor Living Nursery
• Table Birdhouses Bird & Wildlife Accessories Yard, Garden & Outdoor Living

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


Categories:

Prosper.com, Statistics, Tools

Tags:

azerbaijan, mozambique