• 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

Lending Club Changes the Browse Notes Download File

March 14, 2012 By Peter Renton 11 Comments

Views: 948

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.

Filed Under: Investing/Lending Tagged With: download, Excel, Lending Club

Views: 948

Comments

  1. Lou lamoureux says

    March 14, 2012 at 6:05 am

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

    Reply
  2. Peter Renton says

    March 14, 2012 at 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.

    Reply
  3. Bryce M. says

    March 14, 2012 at 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!

    Reply
  4. Peter Renton says

    March 14, 2012 at 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.

    Reply
  5. hector perez says

    March 20, 2012 at 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.

    Reply
  6. Peter Renton says

    March 20, 2012 at 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.

    Reply
  7. Em says

    April 15, 2012 at 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.

    Reply
  8. Peter Renton says

    April 15, 2012 at 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.

    Reply
  9. John says

    June 4, 2012 at 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?

    Reply
    • Peter Renton says

      June 5, 2012 at 4:35 am

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

      Reply

Trackbacks

  1. Lending Club Returns Continue Upward Trajectory At 11.61% says:
    March 21, 2012 at 7:43 am

    […] the downloadable “browse notes” file will now have even more details available for lenders to peruse.  Most of the new additions have […]

    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

  • Top 10 Fintech News Stories for the Week Ending January 16, 2021
  • Podcast 281: Sean De Clercq of Kickfurther
  • Upgrade Launches a Rewards Checking Account
  • Affirm’s IPO Takes Off Like a Rocket Ship
  • Fintech Lenders and Banks Are Ready for PPP Round Two

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