Author Topic: $ of Outstanding Lending Club Loans  (Read 4426 times)

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
$ of Outstanding Lending Club Loans
« on: October 21, 2014, 03:30:57 PM »
Anyone know the loan volume outstanding for Lending Club per year?  Not the amount issued but actually outstanding.

I can only find the $ amount issued per year.

I'm looking for something like:

2007 = $x
2008 = $y
2009 = $z
...
2014 = $2,659 million (https://www.lendingclub.com/info/demand-and-credit-profile.action)
« Last Edit: October 21, 2014, 03:39:13 PM by turing »

Fred93

  • Hero Member
  • *****
  • Posts: 2122
    • View Profile
Re: $ of Outstanding Lending Club Loans
« Reply #1 on: October 21, 2014, 04:50:03 PM »
Well 2007,8,9 were all 36 month loans, so they're all either paid off or charged off by now.

You can get this data by processing the big loan file, or use nickelsteamroller or somebody else who does same for you.

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: $ of Outstanding Lending Club Loans
« Reply #2 on: October 21, 2014, 05:10:56 PM »
Well 2007,8,9 were all 36 month loans, so they're all either paid off or charged off by now.

You can get this data by processing the big loan file, or use nickelsteamroller or somebody else who does same for you.

I don't think PeerCube or NickelSteamRoller can do it because they always show as of today.  I would need to know as of 12/31/2013, 12/31/2012, 12/31/2011, etc.  Correct me if I am wrong.

It should definitely be possible with the big loan file because it lists last payment date and principal outstanding.  No sense re-inventing the wheel if someone else had already compiled this info.  I might need to if nobody else has.

Fred

  • Hero Member
  • *****
  • Posts: 1421
    • View Profile
Re: $ of Outstanding Lending Club Loans
« Reply #3 on: October 21, 2014, 09:32:04 PM »
The table below is end-balance of loans by vintage and status.  Is this what you are looking for?

« Last Edit: October 21, 2014, 09:38:31 PM by Fred »

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: $ of Outstanding Lending Club Loans
« Reply #4 on: October 22, 2014, 12:08:07 PM »
Thank you, but that is not really what I'm looking for.

Another way to word my question is how much principal still needs to be paid for all loans on Lending Club at the end of each year.  If a loan has been charged off or fully paid it wouldn't count because it is no longer outstanding.

I can get that number for right now using PeerCube and NickelSteamRoller, but I don't see any sites that have historic data on this.

Fred

  • Hero Member
  • *****
  • Posts: 1421
    • View Profile
Re: $ of Outstanding Lending Club Loans
« Reply #5 on: October 22, 2014, 12:19:58 PM »
I can get that number for right now using PeerCube and NickelSteamRoller, but I don't see any sites that have historic data on this.

The table was generated using payment history file.

If you, PeerCube, or NickelSteamRoller has history file, it's just a matter of constructing the right query (and subqueries).

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: $ of Outstanding Lending Club Loans
« Reply #6 on: October 23, 2014, 12:43:33 PM »
Ok.  Thanks Fred.  I will play around with it more.  Will probably just download the files again and try to make some queries on that in Access database.

rawraw

  • Hero Member
  • *****
  • Posts: 2756
    • View Profile
Re: $ of Outstanding Lending Club Loans
« Reply #7 on: October 23, 2014, 03:13:45 PM »
you could probably do this in PowerPivot.

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: $ of Outstanding Lending Club Loans
« Reply #8 on: October 23, 2014, 05:27:37 PM »
you could probably do this in PowerPivot.

I've never done a PowerPivot before.  I might look into it a bit.  Thanks for suggestion.

I only have an old school version of Excel and do most spreadsheet stuff in Google Docs. 

rawraw

  • Hero Member
  • *****
  • Posts: 2756
    • View Profile
Re: $ of Outstanding Lending Club Loans
« Reply #9 on: October 23, 2014, 05:38:04 PM »
Oh...  Power pivot requires 2007 Excel

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: $ of Outstanding Lending Club Loans
« Reply #10 on: October 23, 2014, 05:44:33 PM »
Oh...  Power pivot requires 2007 Excel

My wife has Excel 2010.  Office suite might be the only bit of tech where my wife has better than I do :)

rawraw

  • Hero Member
  • *****
  • Posts: 2756
    • View Profile
Re: Re: $ of Outstanding Lending Club Loans
« Reply #11 on: October 23, 2014, 05:48:24 PM »
Oh...  Power pivot requires 2007 Excel

My wife has Excel 2010.  Office suite might be the only bit of tech where my wife has better than I do :)
Okay. Power pivot can link fields across tables and build a pivot table based on it. So probably all you need for this

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: $ of Outstanding Lending Club Loans
« Reply #12 on: October 24, 2014, 01:38:40 PM »
Thank you.  I really appreciate it.