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 was kind enough to point one out…
Listing 30409 was funded, and then defaulted.
When I do
select * from listing, loan
where listingnumber = 30409
and loan.listingkey = listing.[key]
I get nothing back. Is something amiss with the listing keys or is there a row missing for that loan?
Just wondering…thanks!
Then Leporello provided a little encouragement…
I do think that if they give it to you, you should use it, yes.
Although I do have to compliment you on devising an algorithm for linking about 99% of the loans!
The final result being that ProProsper is now using the Prosper provided loan to listing matching and Leporello’s earlier sql now returns a row.
Leporello then showered praise. Flattery and donations/tips will get you everywhere…
Related posts:Cool! Many thanks. So now you’re at 100% loan-to-listing correlation?
This is great!
- 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...
- State Default Rates — A Publishable Application of the RateLadder ListingKey In the past I have talked about my technique for adding a ListingKey to the Loan table of the Prosper.com data export. While I had...
- 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...
- Does Prosper’s Public Data Allow Loan to Listing Correlation? 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...
- Loan to Listing Corelation — Ongoing Debate. That is exactly my point. Other people are already doing it, just not as blatant as my example. Eric looks up a lender’s loans and...
If you liked this article, vote for it on del.icio.us and stumbleupon.
Categories:
Features, Prosper.com, Tools
Tags:
1 comment so far ↓
Best Home Business – Raising Cash an Easy Way to Fund Your Business Now…
If you don’t have much capital and you want more here is an easy way to do it. If you have $500.00 how would you like to fund your business with $100,000. Sounds too good to be true Its not here’s how….
Leave a Comment