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.


Topics - jz451

Pages: [1]
1
Investors - LC / Need Help Writing Automation Script
« on: July 14, 2019, 02:59:59 PM »
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.



2
Investors - LC / IGP No Contact Made
« on: January 06, 2017, 01:57:09 PM »
Over the past couple of months I have noticed that when notes of mine become late Lending Club has not made any contact with the borrower between the due date and settlement date when the ACH is being pulled, or after when the note goes into its Grace Period. Does anyone know why Lending Club is not making the effort to contact some of its borrowers?

3
Investors - LC / Portfolio Efficient Frontier
« on: October 30, 2016, 01:55:48 PM »
Has anyone made an efficient frontier model for their portfolio showing portfolios along the curve with the minimum variance for a given expected return? I'm having a hard time making a variance/covariance matrix because the yearly data I'm using for each grade  from 2012-2015 produces values that are essentially zero with little to no variance/covariance. My matrix for grades A-G looks like this with the filters I use for each grade on Folio: Similar results occur with primary market filters also.

   A                            B                    C                    D                     E                     F                    G
A   0.00000905   0.00002128   0.00002712   0.00002579   0.00003233   0.00002002   0.00002472
B   0.00002128   0.00006770   0.00007329   0.00006886   0.00007666   0.00003445   0.00005669
C   0.00002712   0.00007329   0.00008796   0.00008341   0.00009832   0.00004778   0.00006351
D   0.00002579   0.00006886   0.00008341   0.00007915   0.00009362   0.00004534   0.00005921
E   0.00003233   0.00007666   0.00009832   0.00009362   0.00011631     0.00006735   0.00008149
F   0.00002002   0.00003445   0.00004778   0.00004534   0.00006735   0.00007228   0.00008984
G   0.00002472   0.00005669   0.00006351   0.00005921   0.00008149   0.00008984   0.00012917

This martrix results in only two grades being invested instead of a mix of all seven grades. For example:

                             A             B             C               D            E
weights      20.68%   0.00%   0.00%   79.32%   0.00%
return terms   1.51%   0.00%   0.00%   13.49%   0.00%
target   15.0%
st dev   0.47%


I haven't tried using monthly data yet but I'de expect a similar result. I also tested a portfolio of five stocks and the model worked so something is wrong with the data being used.

4
Foliofn - LC / Grace Period Note Discount Pricing
« on: April 09, 2016, 10:54:20 AM »
So my first note has gone into grace period and I wanted to know how much you all discount you notes. Currently I have priced the note with a 4.14% discount. Some background of the note is that principal+interest is $20.05 and an asking price of $19.22. It has 39 payments remaining and a 26.3% YTM with the discount. The note is a grade G3 and all previous payments have been on time.  Here's the link the the note https://www.lendingclub.com/foliofn/loanPerf.action?loan_id=18314348&order_id=106399455&note_id=49195310

My plan was to increase the markup 1% until the sell data, is this a good strategy or should I be more aggressive, or passive and hold the discount for a few more days?

5
Introductions / Hi
« on: March 21, 2016, 04:16:45 PM »
Hi everyone,

I decided over the past few weeks to experiment with Lending Club as a viable investment strategy. I'm mostly going to invest using Foliofn after I backtested on NSR and found the returns and variance better than new loans. I look forward to how this will turn out.

Pages: [1]