Author Topic: Calculate your percentile rank vs other LC accounts  (Read 10259 times)

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Calculate your percentile rank vs other LC accounts
« on: October 27, 2014, 01:56:23 PM »
https://www.peertopeerquant.com/percentile-calculator

I made this tool that calculate your percentile rank vs all other Lending Club accounts.  It uses the data Lending Club uses to generate their benchmark chart but instead of just seeing where you are on the chart it gives you an exact percentile rank.

The rank is calculated for all accounts and accounts with similar age (+/- 1 month).

Hopefully it is helpful for everyone.  I'd love to see people's scores.

lascott

  • Hero Member
  • *****
  • Posts: 1438
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Calculate your percentile rank vs other LC accounts
« Reply #1 on: October 27, 2014, 02:48:24 PM »
My Percentile Rank using your calculator.  No Folio trading.
Number of notes is > 1,500
Most A, B, and C notes are within the past 2-3 months.


« Last Edit: October 27, 2014, 04:00:56 PM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

core

  • Hero Member
  • *****
  • Posts: 1790
  • Your loss is my gain
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #2 on: October 27, 2014, 02:55:18 PM »
Doesn't LC's data ignore notes that were unloaded on Folio?  There are _lots_ of people who sell off notes before they default.

It seems to me such calculations just compare yourself against the lazy... those who can't be bothered to actively manage their accounts.  Therefore the results don't seem all that realistic.

By the way your calculator breaks if you enter >= 31 for the average age in months.

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #3 on: October 27, 2014, 03:34:50 PM »
Good score Lascott.

Doesn't LC's data ignore notes that were unloaded on Folio?  There are _lots_ of people who sell off notes before they default.

It seems to me such calculations just compare yourself against the lazy... those who can't be bothered to actively manage their accounts.  Therefore the results don't seem all that realistic.

By the way your calculator breaks if you enter >= 31 for the average age in months.

Yes, it is just comparison vs a portion of the LC community.  I don't think we will ever get a tool for measuring performance vs all accounts or only actively managed accounts.  But I wish we could.

I think the tool is still a good benchmark.  You just have to keep in mind who is in the sample.

Thanks for letting me know it breaks at >= 31 average age.  Always good to have real world testing to break things so we can fix them :) I will work on fixing that today.

kbenson99

  • Full Member
  • ***
  • Posts: 111
    • View Profile
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #4 on: October 27, 2014, 03:48:31 PM »
I Folio trade by auto selling notes with FICO scores that have an "adverse" change.  My note age is low due to having dumped a large portion of my portfolio (about 3/4) so I could try a new note selection scheme starting in December / January 2013.  Current number of notes is 1,237.



« Last Edit: October 27, 2014, 11:04:45 PM by kbenson99 »

gottodo1

  • Newbie
  • *
  • Posts: 37
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #5 on: October 28, 2014, 05:23:45 PM »
That's a neat tool, I did pretty good on this one account. I had to say <30 months though and that account the average is at 35.5... that's an odd limitation
« Last Edit: October 28, 2014, 05:30:23 PM by gottodo1 »

Randawl

  • Sr. Member
  • ****
  • Posts: 469
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #6 on: October 28, 2014, 10:37:20 PM »
It is an odd limitation.  But what's even more odd in my opinion is why Lending Club does not extend that chart to completion.  In reality, if you ever intend to put your hands on that money again one day (you know, actually spend/use it), your portfolio ages will eventually become anywhere from 36-60 months [technically about 53 months to date (since May 2010)] and everywhere in between.  But that data is not shown for those accounts.  I, for one, would like to see it.  Not that it's potentially some riveting nugget of secret data or that there are a lot of accounts of that age yet, but I'm interested nonetheless.

Lovinglifestyle

  • Hero Member
  • *****
  • Posts: 902
    • View Profile
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #7 on: October 29, 2014, 10:39:06 AM »
+1

PennySaved

  • Full Member
  • ***
  • Posts: 139
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #8 on: October 29, 2014, 11:14:59 AM »
My results:

Your Percentile:
vs All Accounts: 58
vs Similar Age Accounts: 80

Using this data:

Your Notes purchased on the Lending Club platform
Adjusted Net Annualized Return:   9.21%  (This is adjusted figure for past due notes)
Weighted Average Interest Rate:   14.60%
Weighted Average Age of Portfolio:   17.8 mos
Number of Notes:   1,844

I sold some notes on Folio last year, but not any this year.  Too time consuming for me. I am using Interest Radar to autoinvest this year.

SeanMCA

  • Full Member
  • ***
  • Posts: 200
    • View Profile
    • deBanked
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #9 on: October 29, 2014, 01:32:18 PM »
vs. similar age accounts I got 78%. Very cool tool.
I'm a merchant cash advance veteran exploring the p2p lending waters.

DanB

  • Hero Member
  • *****
  • Posts: 665
  • A lie told often enough becomes The Truth!
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #10 on: October 29, 2014, 02:04:40 PM »
When clicking the LC "understanding your returns" button, the graphics for my accounts show returns at the top of the range but not detached from it. When using your tool the graphic shows my returns detached from the rest & at 97 & 99 percentile.  Why does there "appear" to be such a substantial difference between yours & LC?

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #11 on: October 29, 2014, 03:00:39 PM »
When clicking the LC "understanding your returns" button, the graphics for my accounts show returns at the top of the range but not detached from it. When using your tool the graphic shows my returns detached from the rest & at 97 & 99 percentile.  Why does there "appear" to be such a substantial difference between yours & LC?

Can you show me a screenshot and the data you enter?  It should match the same locations on the charts so I want to look into this and fix it if it is not.

That's a neat tool, I did pretty good on this one account. I had to say <30 months though and that account the average is at 35.5... that's an odd limitation

We had that limitation because Lending Club doesn't provide any data for accounts with ages greater than 30 days.  The calculation would have no comparison.  Probably not the best user experience.

I've made a change to allow older ages but give a caveat that "vs similar age" is not accurate because we have no data on that.  We are just comparing with with other 30 month old accounts.

I hope that works better for you.

Lovinglifestyle

  • Hero Member
  • *****
  • Posts: 902
    • View Profile
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #12 on: October 29, 2014, 03:02:38 PM »
I have way more losses (-16.91% on 1126 notes) than gains on Folio, so this feel good chart is fun for me even though I know it isn't for real.

Your Percentile:
vs All Accounts: 99
vs Similar Age Accounts: 99

Age:  16.6 mos.
# of notes (not counting the 1126 solds):  6315 (4679 issued and current)

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #13 on: October 29, 2014, 05:37:49 PM »
When clicking the LC "understanding your returns" button, the graphics for my accounts show returns at the top of the range but not detached from it. When using your tool the graphic shows my returns detached from the rest & at 97 & 99 percentile.  Why does there "appear" to be such a substantial difference between yours & LC?

I found what was causing this.  Our tool uses a static image for the background chart instead of dynamically creating the chart using all the data points from the JSON file.  Our percentile tool use the data from the JSON so it is accurate, but the chart we have can be out of date.

Before investing the time in making the chart dynamic I wanted to get people's feedback on it first to see if it the tool was useful, then invest the time on it if they do.  Do you think a dynamic chart is important?

DanB

  • Hero Member
  • *****
  • Posts: 665
  • A lie told often enough becomes The Truth!
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #14 on: October 29, 2014, 05:42:49 PM »
When clicking the LC "understanding your returns" button, the graphics for my accounts show returns at the top of the range but not detached from it. When using your tool the graphic shows my returns detached from the rest & at 97 & 99 percentile.  Why does there "appear" to be such a substantial difference between yours & LC?

I found what was causing this.  Our tool uses a static image for the background chart instead of dynamically creating the chart using all the data points from the JSON file.  Our percentile tool use the data from the JSON so it is accurate, but the chart we have can be out of date.

Before investing the time in making the chart dynamic I wanted to get people's feedback on it first to see if it the tool was useful, then invest the time on it if they do.  Do you think a dynamic chart is important?

I sent you a PM before seeing this message.