Loan to Listing Correlation — 99.8% With 100% Accuracy

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 Exchange Related Posts
  • RateLadder.com LoanNew Loan Funded — Clearing a personal credit card used for business purchases — $9,500 at 18% — A Credit — DTI 46% A new loan funded (Clearing a personal credit card used for business purchases — $9,500 at 18%).  I participated via an automatic bid Low AMT -- Extreme DTI -- Autofunding.  Which means this funded at less than 15K less than 60% DTI and was autofunding.   The borrower had A credit and......
  • blog traffic exchangePrime 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......
  • RateLadder.com LoanNew Loan Funded — Purchasing rental equipment in my hardware store — $20,000 at 24% — C Credit — DTI 29% A new loan funded (Purchasing rental equipment in my hardware store — $20,000 at 24%).  I participated via a manual bid, this was an auto funding loan.   The borrow had C credit and 29% DTI.  As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10......
  • blog traffic exchangeUnderAppreciated Listings RSS Feed Update I started my RSS feeds on March 18th...  I thought I would check in on my favorite (Underappreciated Listings)...  There have been 6,364 listings profiled, requesting to borrower $61,781,819 or $9,952.01 per loan on average. Here is the listing status break down... Status Total Amount Number Per Loan Cancelled $3,427,672......
  • New Loan ListingNew Loan Funded #6205 -- $50 @ 19.1% A new loan funded this afternoon (Debt Consolidation - Pay off cards to raise credit score  (Loan #6205) — $24,000 at 19.10%).  I participated via my standing order: High DTI — AF.  Which is this loan was funded as a high debt to income ratio and was an auto-funding loan.  The borrow had C......
Blog Traffic Exchange Related Websites
  • top_of_the_park3Diamond Peak Ski Resort, Incline Village, NV Diamond Peak Ski Resort is located in: Incline Village, NV Phone: (775) 832-1177 Website: http://www.diamondpeak.com/ About the Resort: Located just over the border from California in Incline Village, the Diamond Peak Ski Resort is a world-class facility that offers non-stop fun for skiers and snowboarders. They have gone to great......
  • piggybankThe Top 5 Financial Resources You Need to Help Manage Debt It helps to have a list of financial resources at your side; even if you do not need them right now, you might in the future.  Also, you might come across others who need resources in helping to manage their debt load.  So, with that in mind, here are five......
  • blog traffic exchangeOn Turning 29... I finished this post at 36,000 feet on an American Airlines flight...the joys of in-flight wireless internet. On Monday, November 30th, I turned 29. I spent some time reflecting on turning 29 by mapping out where I am in life, steps I am taking going forward, and some of my......
  • blog traffic exchangeWorkout For the Weekend! Push till you can't push no more! Warm Up: 20 burpees, 20 jumping jacks 20 shoulder rolls and run 400 meters Workout Routine: Shoulder press, push press or push jerk On the minute with a continuous clock running you add an extra rep every minute. Example 1st min 1 rep,......
  • timemoneySave Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all three!) this list of more than 80 top products is just what you need. Everyone's got saving money on their minds these days. Some of us are always looking to......
Online Stores If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Prosper.com, Tools



Tags:

,


0 comments ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment

aa algorithm axis azerbaijan banks benefit blog borrowers ceo Collections credit grade credit history credit information credit score curves doug fuller email friends and family good luck google income borrowers interest rate interest rates investments launch lenders lending institutions liquidity loans marketplace money mozambique peer to peer lending portfolio plan private data promissory notes quiet period registration statement risk securities and exchange securities and exchange commission spreadsheets sql student loans Zopa