Lending Club Changes the Browse Notes Download File

Many Lending Club investors just use the filtering on LendingClub.com to make their investments. Other investors, like me, download all the in-funding notes into a CSV file and do their filtering in Excel. If you are part of the first group then this change will not apply to you. For those of us who download the CSV file from the Browse Notes screen then you will notice some big changes starting today.

Lending Club published this post on their blog last night; here is an excerpt from that post:

The additional data includes loan details and status, third-party reported credit attributes, and information reported by the borrower. This detailed information can be downloaded by logged in users from any page of our Browse Notes section by clicking on the “Download All” link on the bottom right corner of the page.

If you don’t know where to find this download link Lending Club also provided this useful graphic to help you locate it.

Download in-funding notes from the Browse Notes screen

There are some very useful additional fields in this file, some that I have been wanting for a long time such as loan listing URL and additional credit data. In reality, this change is mostly about additional credit data with a few small tweaks elsewhere. Unfortunately, this new data is not available in the big loan history file so we won’t be able to do much analysis on this other data just yet.

I have a bunch of macros that I run inside Excel that helps me with filtering so these will all have to be rewritten before I can use them again. While this is somewhat of a hassle I like that investors are getting more data on borrowers now. To check out the new layout right now here is a direct link to download the new CSV file.

Peter Renton is the chairman and co-founder of LendIt Fintech, the world’s first and largest digital media and events company focused on fintech.

LendIt Fintech conducts three conferences a year for the leading fintech markets of the USA, Europe, and Latin America. LendIt also provides cutting-edge content all year long via audio, video, and written channels.

Peter has been writing about fintech since 2010 and he is the author and creator of the Fintech One-on-One Podcast, the first and longest-running fintech interview series.

Peter has been interviewed by the Wall Street Journal, Bloomberg, The New York Times, CNBC, CNN, Fortune, NPR, Fox Business News, the Financial Times, and dozens of other publications.

Subscribe
Notify of
11 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Lou lamoureux
Lou lamoureux
Mar. 14, 2012 6:05 am

Do you know if they have plans to add that info to the “big loan history file”?
Lou

Bryce M.
Bryce M.
Mar. 14, 2012 6:01 pm

Outstanding. I had asked for loan title, as there are a few keywords that can be added to my probability model now. Can’t wait for them to update the history, too, with all of the credit stuff, to do some more soul searching =).

Ahhhh! Loan listing links—one click and done to invest! Super sweet!

hector perez
hector perez
Mar. 20, 2012 7:21 am

hey peter–are you planning at all to update the excel macro on your p2p lending wealth system? i’ve found it invaluable for filtering.

Em
Em
Apr. 15, 2012 10:21 am

Are the loan in the CSV still hours or days out of date? I used to look at the CSV data but half the time the loans would already be 100% fully funded on the site.

John
John
Jun. 4, 2012 8:57 pm

Has anyone been able to get the file to download without manually logging in? By writing code to download it or by linking a database to it?