Home
Uncategorized
Lending Club Changes the Browse Notes Download File

Lending Club Changes the Browse Notes Download File

Peter Renton·
Uncategorized
··1 min read

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 head and shoulders

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.

Tags
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

0
Peter Renton
Author
Peter Renton
Mar. 14, 2012 1:56 pm

@Lou, I chatted with LC about that today and while they said a project is “in the works” for additions to the download file, nothing is imminent.

0
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!

0
Peter Renton
Author
Peter Renton
Mar. 14, 2012 6:58 pm

@Bryce, Indeed. I think the only thing they took out was job title which I know disappointed some investors. But I can understand that because if you know the employer and the job title it doesn’t take much detective work to find out the identity of the borrower.

0
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.

0
Peter Renton
Author
Peter Renton
Mar. 20, 2012 12:51 pm

@Hector, Yes, I am in the process of updating the Excel macro – it will be available within a few days. I will be send out an email to all P2P Lending Wealth System owners when it is ready to go.

0
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.

0
Peter Renton
Author
Peter Renton
Apr. 15, 2012 10:45 pm

@Em, No. I would say the CSV is completely up to date. Make sure you use the link on the Browse Notes screen to Download the CSV file there and not the In-Funding Loan Data CSV in the Statistics (that one is out of date). They really should remove that latter one or at least have it link to the same file.

0
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?

0
Peter Renton
Author
Peter Renton
Jun. 5, 2012 4:35 am
Reply to  John

@John, I know Lendstats is able to access this file so I imagine it would be not that difficult to just write a script to log yourself in and grab the file. It is a bit out of my area of expertise but it doesn’t sound very difficult.

0