• Subscribe
  • Contact Us
  • About LendIt Fintech News
  • Home
  • Menu Item
  • Menu Item
  • Menu Item
  • Menu Item

Lend Academy

LendIt Fintech News: Daily Coverage of Fintech & Online Lending


  • Editorial
  • Daily News
  • Podcast
  • Investor Forum
  • Events

A New Standard for P2P Lending Data Analysis Launches

February 20, 2012 By Peter Renton 5 Comments

Views: 944

Many investors like to do their own analysis of the raw data from Lending Club and Prosper. To do that you have to go to the download area of each site and access the data separately. Then you have to figure out what all the fields mean because both companies store their data in completely different ways.

Michael from Nickel Steamroller thought there had to be a better way. So, he has created an open standard and a central location where investors can go to download the data from Lending Club and Prosper. Best of all he has made the data available in exactly the same format for both companies. It is called P2PXML and it launched last week.

Why Use P2PXML?

Of course, investors can just go to Lendstats or Nickel Steamroller to do analysis on the p2p lending data. But these sites do not give users access to the raw data. The biggest benefit of accessing data through P2PXML is standardization which makes it much easier to use. The data is presented in exactly the same way for both companies.

Downloading the raw data has always been a time consuming and complex process. Although at Lending Club it is relatively straight forward – the loan history is a simple CSV file that anyone can download and import directly into Excel.

At Prosper, however, they provide a much richer data set and consequently it is more complicated to analyze. Their full data download contains over four gigabytes of information and is in XML format. I have never bothered looking at the raw Prosper data simply because I am on a Mac and Excel for Mac can’t open XML files.

Now, I just go to the download area of P2PXML to access the loan history of both companies – this data is updated daily.

Introducing P2P Lending Rate Groups

Rate groups is a new concept that is part of the P2PXML specification and download. This is a new development I am very excited about. It is an idea I have been mulling around for several months and when Michael discussed creating a p2p lending data export standard I thought it would be a great addition.

As we all know Lending Club and Prosper have different loan grades that represent different interest rates. Prosper targets, on average, a higher risk borrower than Lending Club and consequently has a higher average interest rate. What I have been looking for is an apples to apples comparison. How does a bucket of 12-14% loans at Lending Club compare with a bucket of 12-14% loans at Prosper? There has never been an easy way to figure this out … until now.

Now, we can ignore the loan grades and look at the underlying interest rates of the loans. Every loan is assigned a rate group by P2PXML in a 2% range starting at 0% (although there has never been any loans issued below 4% and likely never will be). For example, all loans with an interest rate between 6% and 7.99% fall into rate group R-4, 8 – 9.99% loans are R-5 and so on. Look for some interesting analysis based on rate groups in a future blog post.

As the name suggests the standard format for downloading data from p2pxml.com is XML format. But I asked Michael to also include a CSV download for people like me who don’t want to work with XML data. You can download a sample set of 1,000 records or the full data set of both companies. I should point out that this is still a work in progress and some fields don’t have any data – that is because both Lending Club and Prosper only make certain fields available. But even as it is right now it still provides useful information for investors.

Let me know what you think of this attempt to bring a standard to p2p lending data exports. And I am sure Michael will read the comments here so feel free to make suggestions as well.

Filed Under: Investing/Lending Tagged With: p2p analysis, p2pxml

Views: 944

Comments

  1. Charlie h says

    February 20, 2012 at 4:57 pm

    This should be fun digging around in.

    Reply
  2. Mike says

    February 20, 2012 at 9:38 pm

    Michael does some amazing work in this department. My hat is off to him, even if I can’t comprehend all of the information he provides.

    Reply
  3. Peter Renton says

    February 20, 2012 at 11:04 pm

    @Charlie, Indeed.

    @Mike, He sure does. One of the things I love about this space is that there are many intelligent people doing unique things. We all have different skill sets if we pool this information together we will all become better investors.

    Reply
  4. Michael says

    February 21, 2012 at 9:41 am

    @Mike
    Thanks for the compliment.

    Reply

Trackbacks

  1. An Apples to Apples Default Rate Comparison says:
    May 14, 2012 at 10:24 pm

    […] this year I wrote about the release of P2PXML, an attempt to bring an open standard to analyzing p2p loans. P2PXML is an open source project by […]

    Reply

Leave a Reply Cancel reply

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

Investor Intelligence

Peter Renton's Returns

Investor Forum

Lending Club Review

Prosper Review

Investor Resources

Most Popular Editorials

The Pure Marketplace Lending Model is Dead, the Hybrid Takes its Place

The 2018 Lending Club and Prosper Tax Guide

My Returns at Lending Club and Prosper

Map of Available States for Lending Club and Prosper Investors

Banks and Marketplace Lending Platforms: Ideal Partners?

Subscribe to the Podcast

Subscribe to the Lend Academy Podcast on iTunes
Subscribe to the Lend Academy Podcast
List of Podcast Episodes

Archives

Follow @LendAcademy Follow @LendIt

ABOUT LENDIT FINTECH NEWS

LendIt Fintech News, Powered by Lend Academy, has been bringing you all the news and information about fintech and online lending since 2010 when it was founded by Peter Renton. We not only have the industry’s most active news site, but also the largest investor forum and the first and most popular podcast.

We are a team of fintech enthusiasts who have been covering the industry for many years. With a deep knowledge of online lending, digital banking, blockchain, artificial intelligence and more our team covers the daily news and writes in-depth editorials.

Recent Editorials

  • Marcus Co-Founder Leaving for New Walmart Fintech Initiative
  • Top 10 Fintech News Stories for the Week Ending February 27, 2021
  • Podcast 287: Brad Paterson of Splitit
  • ODX and Fundation Join Forces to Form Linear Financial Technologies
  • LendIt Fintech’s Lending Innovation Summit Europe is Next Week

Copyright © 2021 · Metro Pro Theme on Genesis Framework · WordPress · Log in