P2P Lending / NFT Lending Forum

Hi All,

Been a while since last posting as I haven't been as active investing, but have lurked from time to time.

For those of you have have written scripts for automating loan selection using the API I need some of your assistance. My script will select loans using a model I have backtested to classify which new loans will "Pay in Full". So far I am able to get the cash balance and have written the code for transforming the data, but need help with how to retrieve the data and for placing an order. Here's some questions I have:

1. What platform did you use to run the script? I'm planning to use AWS but wanted to see what others have used.

2. I'm new to web scraping using Python, so running Get/Post calls using Requests isn't intuitive to me when there's no examples in the LC API documentation. For those willing may I see your script sans selection filters/models to get a better idea of the structure for writing a script that functions properly?

3. For retrieving the data, is there a way to get a subset of the variables or am I only able to retrieve all variables? Also, I noticed when trying to convert the JSON to a dataframe, it's formatted as an overall dictionary with a list of loans and each loan is a dictionary of the data as you can see in the attached image. What's the best way to properly turn it into a dataframe so each loan is a separate row with the variables as columns?

Thanks for the help.

I looked into it when I saw it on TV. It's basically a marketplace to buy/sell rental proeprties. It's not worth it since most of the properties are trash. You're better off looking on the MLS the traditional way and hiring a proeprty management company.

Been a rough month had a surge for my small account in notes being delinquent.

Combined ANAR:  9.64%
Weighted Average Interest Rate:   20.4%
Weighted Average Age of Portfolio: 26.47 mos
Number of Notes: 214

A (0.0%) B (0.0%) C (2.9%) D (39.3%) E (43.4%) F (9.3%) G (5.1%)
36 (0.2%) 60 (99.8%)

vs All Accounts: 94.69
vs Similar Age Accounts: 99.52
vs Similar Age and WAIR Accounts: 98.73

Adjusted Net Annualized Return:   10.82%
Weighted Average Interest Rate:   20.43%
Weighted Average Age of Portfolio:   25.51 mos
Number of Notes: 218

Grade A(0%) B (0%) C(2.6%) D(37%) E(44.9%) F(8.9%) G(6.5%)

Term  36(0.2%) 60(99.8%)

Combined Adjusted Net Annualized Return:  10.94%
Weighted Average Interest Rate: 20.6%
Weighted Average Age of Portfolio: 24.46 mos
Number of Notes: 211

Grade
A (0.0%) B (0.0%) C (2.3%)
D (36.5%) E (43.0%) F (10.7%) G (7.4%)

Term
36 (0.3%) 60 (99.7%)

vs All Accounts: 96.91
vs Similar Aged Accounts: 99.83
vs Similar Aged and WAIR Accounts: 100

After looking at the filing I find it striking that the engineering/product development costs have risen and that G&A have gone up as well. If they stayed flat year-over-year they could have saved $17 million.Makes you wonder what they are spending money to develop/engineer and where the administrative costs are going.

Adjusted Net Annualized Return:    11.47%
Weighted Average Interest Rate:    20.93%
Weighted Average Age of Portfolio:    23.79 mos
Number of Notes:    195

Grade
A (0%) B (0%) C (2.5%) D (34.4%) E (41.2%) F (11.4%) G (10.0%)

Term
Payments  36 (0.4%) 60 (99.6%)

vs All Accounts: 97.76
vs Similar Age Accounts: 99.83
vs Similar Age and WAIR Accounts: 100.00

I started the process of investing $2500 this month into my account which is going to result in a big change to my results over the next couple of months as I slowly churn through the cash.

Combined ANAR:  11.50%
Weighted Average Interest Rate:  21.24%
Weighted Average Age of Portfolio:   23.31 mos
Number of Notes:   169

A(0.0%) B (0.0%) C(0.0%) D(31.4%) E(42.1%) F(13.5%) G(13.0%)
36(0.5%) 60(99.5%)

vs All Accounts: 97.79
vs Similar Age Accounts: 99.81
vs Similar Age and WAIR Accounts: 99.02

All you have to do is provide your credit card info and it will let you look at more than three filters. I had the same problem months ago when they changed that.

I received it about an hour ago. I think it's a good idea, just like a credit card the clock is still ticking until the borrower decides to pay. It might have an added benefit of more loans paying on time if people know they have to pay more for paying late vs spending money elsewhere.

The first thing I would do if you haven't done so already is create an account for NSR and input your payment info (only way to use more than three criteria filters at a time) and play around with the criteria you want to filter until you have some filters you feel comfortable using. For me I have filters broken down for each grade.

Here's the criteria I'de play around with.

Year (start/end date of analysis)
Subgrade
FICO score
Term
Home Ownership
Income
Revolving Balance
DTI
# Inquiries
Employment Length

Analyzing the filter you provided starting in 2014 it yields  7.1% and a loss rate of 2.9% w/ avg age of 19.4 months. So it yields a lower rate than what you had in the past, but your loss rate is going to go down as well, with a break down by year of the following:

            Yield       Avg Rate    Loss Rate    Months
2014    7.63%    11.19%     3.23%         32.09
2015    6.37%    10.01%     2.85%         19.86
2016    7.07%    10.13%     2.37%         10.13

I combined grades A,B,C together, but I would really say that the yield overall will increase if you filter grades separately and weight each grade according to what you want, for example you want more C loans so say a weighting of 20% A, 30% B, 50% C.

In the end it is up to you what you want to do and would suggest using NSR to play around with the filters until you find something yo are happy with.

Yes I have added $500 work on notes on Folio, about 25 notes with the added notes changing the composition of the portfolio. I'm going into less risky notes in the D-E range, and have another $2500 I might be moving into my account in the coming months.

If they are forgetting to log when they contact the borrower, then that is a bigger problem altogether, and a failure of internal controls and compliance on LC's part. I've had several notes I've had to sell because the notes go into grace period and there is no log of contact from the time the payment is due to the supposed settlement date and after that date.  At some point I am going to call customer service to see what is up about that, because from this and logs with multiple calls but no message left is simply frustrating. When I worked at Springleaf, now OneMain, from last June to September all late borrowers got left a message if they didn't answer the phone.https://forum.lendacademy.com/index.php?topic=3551.msg39562#msg88888888Quote"> from: rawraw on February 01, 2017, 04:41:51 PM

For anyone who buys/sells on Folio do any notes have a value in boxes 1g and 1f. 1g on the tax form says "Wash sale rule disallowed", yet on the LC tax guide for 1099-B it says those boxes are for buying notes at a premium/discount. So does this mean that anyone who buys notes won't have these boxes reported since notes are considered simular to each other? 

edit: Just looked at the tax guide included with this years statement and last years. Looks like premium/discount when buying on folio aren't reported by LC. Box 1f and 1g were changed from "Code" and "Adjustment" to "Accrued Market Discount" and "Wash Sale Not Allowed", both of which are blank on all notes sold.

Not so far, but November was really bad for me.