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.

Related Posts

• New 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......
• 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......
• New 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......
• UnderAppreciated 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 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......

Related Websites

• Diamond 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......
• The 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......
• On 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......
• Workout 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,......
• Save 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

• Deals White Pass Washington Skiing Vacation
• Match Holders Tobacciana Collectibles
• Deals Stevens Pass Washington Skiing Vacation

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


Categories:

Prosper.com, Tools

Tags:

azerbaijan, mozambique