Author Topic: Easier way to get account history?  (Read 2734 times)

kuhnrl30

  • Newbie
  • *
  • Posts: 15
    • View Profile
    • R Package for Lending Club
Easier way to get account history?
« on: June 12, 2017, 03:10:50 PM »
Is there an easier way of getting your account history rather than regularly downloading the data in 30 day increments?  I'd like to use that data to track loan level cash flow against my projections but it's tedious to do on monthly basis.

I've asked LC if they'd add account history to their API and their response was essentially 'thanks for the suggestions but no'.  Is there community interest in getting this added to the API?

Does anyone have any suggestions? 

Rob L

  • Hero Member
  • *****
  • Posts: 2124
    • View Profile
Re: Easier way to get account history?
« Reply #1 on: June 12, 2017, 03:51:01 PM »
Not sure what you mean. There's "Account Activity" and there's "Order History".
Don't think I can be any help but you are interested in "Account Activity", right?

kuhnrl30

  • Newbie
  • *
  • Posts: 15
    • View Profile
    • R Package for Lending Club
Re: Easier way to get account history?
« Reply #2 on: June 14, 2017, 01:14:54 PM »
Correct- I'm looking for the account history.  Ideally I'd be able to get the history in 1 big download just like you can do for the order history. I'm pretty sure the LC website doesn't support this but is it possible in any of the 3rd party apps?

Rob L

  • Hero Member
  • *****
  • Posts: 2124
    • View Profile
Re: Easier way to get account history?
« Reply #3 on: June 14, 2017, 04:25:30 PM »
Well if you happen to be a programmer then it might be possible. This is off the top of my head and I haven't done any programming for LC purposes in a very long time. LC makes  a huge file available monthly called the payment history file (pmthist). Think it has just that for all loans since day one except it does not have anything on loans in the current quarter. You also may download another file containing all the notes you have ever owned. Guess in theory one could query the pmthist file for all notes you've ever owned and that might do it (except for notes bought in the current quarter). Finally the you could download the "account history" file (available from present day and going back 6 months) and bring the results up to date on a daily basis. Sounds like a lot of work and I'm just throwing it out there as a possibility. Could be there's a monkey in the wrench of this idea. Anyway, probably more work than what you are now doing unless you need to go back more than 6 months and don't have the file(s).

Fred93

  • Hero Member
  • *****
  • Posts: 2235
    • View Profile
Re: Easier way to get account history?
« Reply #4 on: June 14, 2017, 04:33:06 PM »
Finally the you could download the "account history" file (available from present day and going back 6 months) and

Where do you find this?

Rob L

  • Hero Member
  • *****
  • Posts: 2124
    • View Profile
Re: Easier way to get account history?
« Reply #5 on: June 14, 2017, 11:28:40 PM »
Finally the you could download the "account history" file (available from present day and going back 6 months) and

Where do you find this?

https://www.lendingclub.com/account/lenderActivity.action

sensij

  • Newbie
  • *
  • Posts: 31
    • View Profile
    • Email
Re: Easier way to get account history?
« Reply #6 on: June 15, 2017, 11:36:35 AM »
Finally the you could download the "account history" file (available from present day and going back 6 months) and

Where do you find this?

https://www.lendingclub.com/account/lenderActivity.action

For me, that link provides only a maximum of 31 days of activity at once, not 6 months.

Rob L

  • Hero Member
  • *****
  • Posts: 2124
    • View Profile
Re: Easier way to get account history?
« Reply #7 on: June 15, 2017, 11:56:23 AM »
Finally the you could download the "account history" file (available from present day and going back 6 months) and

Where do you find this?

https://www.lendingclub.com/account/lenderActivity.action

For me, that link provides only a maximum of 31 days of activity at once, not 6 months.

Yes, sorry I was unclear. You can go back 6 months but only download a month a time.

yojoakak

  • Hero Member
  • *****
  • Posts: 763
    • View Profile
    • Check out my Greasemonkey/Tampermonkey script for LendingClub here
    • Email
Re: Easier way to get account history?
« Reply #8 on: June 18, 2017, 11:23:54 PM »
My Greasemonkey script (LCAC) adds a button to Download those 6 months of activity with one click (or rather: one click + select all, copy and paste into a spreadsheet or file). It's not ideal, but it seems to work.
« Last Edit: June 18, 2017, 11:26:45 PM by yojoakak »

kuhnrl30

  • Newbie
  • *
  • Posts: 15
    • View Profile
    • R Package for Lending Club
Re: Easier way to get account history?
« Reply #9 on: June 20, 2017, 03:43:07 PM »
My Greasemonkey script (LCAC) adds ....

I've never heard of Greasemonkey before but this looks like a step in the right direction.  At least I won't have to merge several files together anymore.  Thanks for pulling it together.

Is it possible for the output to be a downloaded .csv instead of sending the results to a new tab?