Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - lascott

Pages: 1 2 3 [4] 5 6 ... 96
46
We are excited to share our latest news with all of you. Liquid P2P and Interest Radar are coming together to better serve our users and improve secondary market liquidity for the retail investor. 
With this partnership, Ricardo and l saw the opportunity combine our strengths under a single platform to deliver a more comprehensive investing tool that gives you powerful, automated access to the returns you want and the liquidity you need.
Liquid P2P and Interest Radar Announce Strategic Partnership
POSTED ON FEBRUARY 20, 2019 BY LIQUID TEAM
Newcomer/veteran team aims to improve Lending Clubís secondary market liquidity with patent-pending technology
Liquid P2P and Interest Radar are pleased to announce that they have entered into a strategic partnership. The two third-party investing services for online peer-lending giant Lending Club will combine strengths under a single platform to deliver a more comprehensive automated tool with a patent-pending liquidity solution.
The collaboration brings together Liquid P2Pís innovative technology with Interest Radarís market presence and long-trusted expertise as the first platform to automate investing for Lending Club more than six years ago.
Continue reading our joint press release: https://blog.liquidp2p.com/liquid-p2p-and-interest-radar-announce-strategic-partnership/

This is confusing considering this past thread where we thought BlueVestment and Interest Radar "merged".

Title: BlueVestment and Interest Radar to Merge
https://forum.lendacademy.com/index.php/topic,3245.0.html

Quote
Weíre very pleased to announce that BlueVestment and Interest Radar (IR) have agreed to merge, effective June 13th, 2015.  Our name will remain BlueVestment and IRís founder, Ricardo Basto, will join the BlueVestment team as our Chief Credit Officer. We have selected the BlueVestment as our future platform and we intend on sunsetting IR as key functionality is added to BlueVestment.

47
General Discussion / Re: RealtyShares annual summary issues?
« on: February 27, 2019, 10:15:24 AM »

48
Investors - LC / Re: Six month review of my Lending Club account
« on: February 23, 2019, 05:07:33 PM »
You might like to do XIRR and annually/year (here: https://forum.lendacademy.com/index.php/topic,3742.msg33511.html#msg33511 )

49
Investors - LC / Re: Tue 02/12/19 payments about 3 times higher than normal
« on: February 20, 2019, 03:53:45 PM »
Thanks much everyone and for the link to the notice.  I'm happy to watch my daily payments be above the basic payment with regular full payments. Also like Lending Clubs seemingly more aggressive collection process. Something better than nothing.

50
Investors - LC / Re: Recovery Payment Received for Charged Off Loans
« on: February 19, 2019, 12:43:41 PM »
Could you dump them into a single column so its easier to get into excel to match?  Doesn't go in cleanly as is.  Curious where this is going.
I think I got them all. I didn't have any.

187383
365044
446879
545408
628186
667933
722727
786973
801181
820963
834642
888558
985214
1125962
1334517
1390923
1469058
1548720
1587199
1606429
2234851
2286330
3158374
3216977
3635121
3919282
4255787
4282031
6707722
7059592
7648944
8614949
9845644
10597591
12987029
19256502
24055069
30836182
32069035
32280008
33201307
35004113
35733650
36099806
37741722
39531903
39977574
40776754
41071468
41388698
44056470
46764136
48181956
48556047
51978290
55987171
57015193
60025467
60246818
63919895
64037882
64967871
65611490
65821312
66491455
67446038
70702343
70841513
71744763
75304312
75427297
76403791
80662890
84051666
88084249
88402158
90244701
90835542
91575843

51
Investors - LC / Tue 02/12/19 payments about 3 times higher than normal
« on: February 15, 2019, 10:56:18 PM »
On Tue 02/12/19 payments in both my taxable and ROTH IRA were about 3 times higher than normal.  Not obvious why on that Tue.

Anyone else notice this?

52
Investors - LC / Re: Notes Disappeared
« on: February 07, 2019, 04:48:06 PM »
Not sure I made it clear but I monitor my portfolio on a monthly basis. My total number of notes is constant Feb - Dec, but the past two years the January total number of notes dropped from the prior December. It's an end of year thing. There doesn't seem to be any special payment, etc. to indicate I'm receiving my principal back for the missing notes. Could be lumped in with "Principal Received" but that amount is in line with my expectations without any added money. If the amount is small I couldn't tell.

The only thing that looks a little screwy is the change in the number of charged off notes. That's definitely lower than expected, by about the 5 that went missing. Should have been 13-15 and it was only 8. Seems the notes are going from charged off to missing.
My bad. My note count has changed the past couple months. Up and then down.  Not sure why notes are in purgatory at different times.


53
Investors - LC / Re: Notes Disappeared
« on: February 06, 2019, 08:21:12 PM »
In Feb 2017 I bought my last note, bringing my total 9016. I haven't sold any since that time.
My statement in Jan 2018 showed a total of 9015 notes, so one went missing entering the new year.
I just received my Jan 2018 statement and it shows a total of 9010 notes; 5 more went missing entering this new year.
This was discussed on the forum before but I don't know where.
Wonder what's going on?
I thought some were 'repurchased'. You can do a search for that word and find some threads. HTH  Hmm ... or did they just cancel some and refund. I can't recall.
Also tax guide changed as I pointed out in a new thread the other day. I think it may have been for this. At least 'repurchased' was mentioned in the new guide.

54
I have not but thank you for taking the time to do this.  A few months (or more) ago when LC made that horrific visual change and removed some Download button, they also screwed up the Account Activity page.  I used to be able to simply copy and paste that popup-box into Excel and add up all Principal, Interest, Fees, etc. for every day.  I emailed them about the changes and they basically said they didn't care that copy and paste no longer worked.
You're welcome.  The above would end up being very similar except for the step of doing the change all $ to <tab>$.

I think the shared Google sheet could also be downloaded to Excel easily enough. UPDATE: Added Excel spreadsheet to the original post.

55
Has anyone tried the steps and spreadsheet?  Did it work as expected? When I parsed the concatenated IDs I think my formulas covered all the possible lengths.

56
Investors - LC / 2018 Tax Guide for Retail Investors - 1F and 1G
« on: February 04, 2019, 12:40:59 PM »
FYI, I did a comparison of 2017 and 2018 Tax Guide for Retail Investors and saw they made changes for 1F and 1G. Their example of how to transfer their form to your tax form didn't include it but it would be straight forward.  Some other minor text changed related to 'repurchased' notes.  See below.

https://draftable.com/compare/CHoNotUgUmYf - If this link doesn't work just compare your 2017 and 2018 guides yourself at draftable.com

2017


2018



Aside: Has anyone downloaded their LC data into TurboTax yet? I'm planning on working on my taxes soon and was curious. Timing has been a little odd in the past years as I recall.

57
Investors - LC / Re: Possible to see how many payments remaining?
« on: February 04, 2019, 11:51:40 AM »
... date of first payment, but not how many are left. ...

So why would you use the rough math of:
(loan_term_in_months) - ( (today() - "date of first payment") / (365.2425/12) )

58
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.
Quote
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-activity
2) 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=sharing
Shared 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)

59
Foliofn - LC / Re: taxes...?
« on: February 01, 2019, 11:42:12 PM »
Yes, you got it pretty much right.  Interest is ordinary income.  Sale and default are capital gain/loss.

LC sends you a form 1099.
You copy the numbers to your tax forms.
You don't need to itemize every loan.

so just to confirm this again
- buy secondary note $20
- receive payments $19.60
- sell secondary note $1

i'm up 0.60
i owe taxes on 0.60 at the capital gains rate

so we're all kind of incented to sell the last 1 or 2 loan payments?
Look at the interest part of the payment on the last 1 or 2 loan payments.  You are going to sell this for $1 ?!?  and do it consistently on 100s ... 1000s of notes to make a profit that is worth it



60
Investors - LC / Re: Recoveries: More than usual?
« on: January 29, 2019, 11:53:29 PM »
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.

NOTE: For the heck of it I cut-n-paste those transactions; then paste into notepad; change all $ to <tab>$; the cut-n-paste those into a spreadsheet. Example below. 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.  Based on my column names you can see I sort by a couple columns. 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.


Pages: 1 2 3 [4] 5 6 ... 96