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 - medico

Pages: [1]
1
Investors - LC / Re: Interactive Tableau Dashboard for LC Raw Data
« on: March 25, 2016, 12:53:57 PM »
All, dashboard has been updated with FICO score, home ownership, and ROI color grading.

2
Investors - LC / Re: Interactive Tableau Dashboard for LC Raw Data
« on: March 25, 2016, 11:57:59 AM »
What do you mean type? The purpose variable is there on the left.

3
Investors - LC / Re: Interactive Tableau Dashboard for LC Raw Data
« on: March 25, 2016, 10:12:09 AM »
Definitely. I have been using home ownership as almost a first pass filter for everything.
For FICO score, i was planning on creating a linear regression and seeing what the R-squared is compared to ROI.

4
Investors - LC / Interactive Tableau Dashboard for LC Raw Data
« on: March 24, 2016, 03:21:02 PM »
So after downloading raw LC data and putting it in Tableau, I have begun creating interesting tables that help find relationships between many of the variables.  In addition, this should help create better filters for finding better loans to invest in.

The dashboard is posted on Tableau Public for everyone to use.
https://public.tableau.com/views/LendingClubROI/Dashboard1
**bold**I appreciate feedback on improvements!!!!**bold**
If you haven't used a Tableau dashboard before, everything is interactive. If you click on a grade in the grade table, all other tables will automatically filter for what you're looking for. It's a little slow after clicking, but it works.

Compared to NSR, I am using a more complete formula for ROI:
([Interest received to date]+[Post charge off gross recovery]-[Service Fee]-[Collection Recovery Fee]-[Loss Estimate]) / ([Interest received to date]/[Interest Rate])
This takes into account recoveries after charge off and detrimental collection fees.

I haven't pulled in the pre-2012 data, but will do so soon. One idea I have for the dashboard is to remove all other information except ROI. It will allow many other variables to be populated on one dashboard. Thoughts?

5
Investors - LC / Re: NSR ROI Doesn't Add Up
« on: March 24, 2016, 09:34:36 AM »
I figured it out. Using the NSR formula, I was performing the division on each loan separately, then averaging.
I've got it all working by actually following the formula... Summing the top part of the formula for all loans then summing the bottom part of the formula for all loans. Dividing each result.

6
Investors - LC / NSR ROI Doesn't Add Up
« on: March 23, 2016, 06:18:02 PM »
Using NSR filters:
  • Issue Date 01/01/2012 - 12/31/2015
  • Grade: G
  • Purpose: Renewable Energy
Give you a list of 8 loans.
You can see the individual loan information on the Annual Income table with each respective ROI.
I have also downloaded the LC raw data and been able to replicate these individual ROI numbers in Excel and Tableau.
However, the combined ROI on NSR shows (23.54). I am completely lost as to how this is calculated, since it is neither a simple average nor a loan amount weighted average.

Anybody have insight?

Pages: [1]