Loan to Listing Correlation — 99.8% With 100% Accuracy | P2P Lending, Peer to Peer Lending, People to People Lending

I have spent some time reviewing and revamping my loan to listing match algorithm.

Using yesterday’s data I am am able to match 7575 out of 7591 loans ~ 99.8%.

The 16 remaining loans look very similar and have creations dates within a day or two of each other.

Here is my algorithm (each pass finds only unique matches, once a match is found that listing can no longer be used in subsequent passes):

Pass #1: (7339 rows matched)
Match amount, lenderrate, creditgrade, DTI
loan.originationdate>listing.enddate

Pass #2: (224 rows matched)
Match amount, lenderrate, creditgrade, DTI, Group
loan.originationdate>listing.enddate

Pass #3: (12 rows matched)
Match amount, lenderrate, creditgrade, DTI
loan.originationdate>listing.enddate
(loan.originationdate-45)<=listing.enddate

If you would like my sql for personal use to add a listingkey to the loan table it is for sale for a $5 PayPal donation.

I am still not sure of the legal or moral arguments around publishing the sql script to the world. So you must use it for personal use only. Don’t share. Don’t publish. Your internal use only for analyzing loan opportunities. Don’t attribute specific 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.

Blog Traffic ExchangeRelated Posts

  • New Loan Funded — Secure Borrower needs funds to complete rental houses — $25,000 at 12.00% — AA Credit — DTI 25%A new loan funded (Secure Borrower needs funds to complete rental houses — $25,000 at 12.00%). I participated via my standing order: Mid DTI — AF. Which is this loan was funded as a medium debt to income ratio and was an auto-funding loan. The borrow had AA credit and……
  • 2 New Loans (Part 2/2) — Debt Consolidation — $20,000 at 18.00% — C Credit — DTI 23%A new loan funded this afternoon (Debt Consolidation (Loan #6419) — $20,000 at 18.00%). I participated via my standing order: Mid DTI — AF. Which is this loan was funded as a medium debt to income ratio and was an auto-funding loan. The borrow had C credit and 23% DTI. ……
  • Borrow Money on Prosper — Case for Unsecured Debt via Personal LoansProsper Marketplace, Inc. is a peer-to-peer (p2p) lending marketplace that facilitates 3 year fully amortized loans between lenders and a borrower. A borrower wants to borrow money and lenders want to earn better than average returns. The most typical reasons for loans on Prosper are credit card debt consolidation, small business……
  • Propser and the Greatest Economic Crises America has Ever Faced?Prosper just released it monthly survey and it included commentary from CEO Chris Larsen. What do you think, is this the “greatest economic crises America has ever faced”? (For my part there is no doubt it is in my lifetime, but I don’t see this getting to the level of……
  • UnderAppreciated Listings RSS Feed Update — Greater than $3MM in Fundable by Rate, Amount, and DTI Listings ExpiredI 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……

RateLadder.com LoanRelated WebsitesOnline StoresIf you liked this article, vote for it on del.icio.us and stumbleupon.

Categories:

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *