Below prompted me to share a spreadsheet (Do a File/Copy of it!) and technique I came up with a while back to look at note payment activity.
I used the length of all concatenated IDs to determine a small formula to extract out the Loan ID, Order ID, Note ID. This seems to work for the various lenghts (24 to 27).
I was prompted to share this based on my interaction with Fred93 below.
All the payments for a day show up as a single total, and when you click on the total, a window pops up showing the note by note detail. For me, that popup window is larger than my screen, and it has NO SCROLL BAR, and no way to download, so there's no way to ever see the numbers.
FYI, I can use the mouse scroll wheel to move down but I can not use the page scroll bar or that popup dialog box goes away. Crazy they design this stuff with one person or something.
UPDATE: You can also just click your mouse in that dialog box and then use up/down arrow keys or page up/down keys.
Visual separator
Here are some directions to populating a Google spreadsheet I came up with to peek at note payments and then take the hyperlink to the Lending Club page for a given note. AFAIK you can only look at these if you own the note so experiment (follow LC link in spreadsheet) with your own.
Steps.
1) Got to Activity page:
https://www.lendingclub.com/investor/account/1/activity/account-activity2) Click on Investor Fee
Amount or PAYMENT
Amount to get a popup dialogue. Either one brings up the same info AFAIK. Often the PAYMENT one shows up many minutes after the Investor Fees one.
3) Highlight all the IDs and values
4a) Paste into Windows notepad or equivalent
4b) Change all $ to <tab>$ --- this will make pasting in a spreadsheet go to multiple columns (tabbed data pasted)
5) You can delete range 3A:G beforehand. (3A:G without a number following G means as many rows as there is per G-sheet syntax).
6) Then cut-n-paste those lines into a spreadsheet at 3A.
7a) Highlight all cells. Click the area to the left of A and above 1. Not sure of the official name of this 'select all cells' area.
7b) Use menu option Data, then Sort Range. Pick Data has header row.
7c) Sort by column named '
COLLECTION FEE (S1Z)' 1st and select Z to A (S1Z) *AND*
7d) Sort by column named '
PRINCIPAL (S2Z)' 2nd and select Z to A (S2Z).
8.) Click on the URL for any note you are interested in reviewing (but make sure you are logged into your LC account).
Shared sheet:
https://docs.google.com/spreadsheets/d/1j29i8N7T454BFOkS9IaZl7L43Qsg2qOC8km76tEH-gQ/edit?usp=sharingShared Excel: see attachment
Example below. This is just for the heck of it so see what some transactions are doing (pay off, pay late, collections, etc).
I built a URL in the Google sheet that I can then go look at that loan.
Obviously, I added the columns on the right (following '.' column) to break the IDs up so I could build the URL. Cut-n-pasting scrunched them all together
Automatic 'Conditional Formatting' also made numbers stand out.
Related to 2 above:
Final output: (update -- Note that N5 should be a value of 8. I added a forumula to that column but it didn't affect anything else. 1:03am CTS)
