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

Fred

  • Hero Member
  • *****
  • Posts: 1421
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #15 on: October 29, 2014, 09:03:37 PM »
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.

Your tool is faster compared to LC's, which I think is due to the static chart image. 

However, I would still like to see the chart image to reflect the latest data from LC.  Therefore, perhaps generating the chart image once daily would be enough.  Or weekly?  Not sure how often LC updates the JSON data.

rawraw

  • Hero Member
  • *****
  • Posts: 2795
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #16 on: October 30, 2014, 06:28:25 AM »
Your Percentile:
vs All Accounts: 87
vs Similar Age Accounts: 94

Pretty cool.

SeanMCA

  • Full Member
  • ***
  • Posts: 200
    • View Profile
    • deBanked
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #17 on: October 30, 2014, 10:29:57 AM »
Quote
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.

Wait, does similar age here refer to the length of time accounts with lending club have been open? I thought it referred to the weighted average age of the portfolio.
I'm a merchant cash advance veteran exploring the p2p lending waters.

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #18 on: October 30, 2014, 10:47:46 AM »
Your tool is faster compared to LC's, which I think is due to the static chart image. 

However, I would still like to see the chart image to reflect the latest data from LC.  Therefore, perhaps generating the chart image once daily would be enough.  Or weekly?  Not sure how often LC updates the JSON data.

Glad you noticed the speed.  We cache the entire JSON file for 24 hours to speed up processing so we don't even need to wait for LC to give us the data.

If we do generate the chart dynamically we would want to keep the speed so we would probably do it daily too.  Having 24,000 points in html/css might slow things down even if the JSON doesn't need to be processed.  I will have to play with it to find the best combination of speed and accuracy.

Feedback is good so far so it is probably worth the time to improve it.

thezfunk

  • Sr. Member
  • ****
  • Posts: 316
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #19 on: October 30, 2014, 11:13:32 AM »
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)

I am also in the 99 percentile category and like you have a loss running on Folio where i dump the notes that go bad or are predicted to go bad of -8.5 or so.  It's getting better as I am getting more proactive about putting a note on Folio instead of waiting for it to get really bad.

Lovinglifestyle

  • Hero Member
  • *****
  • Posts: 902
    • View Profile
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #20 on: October 30, 2014, 02:37:46 PM »

I am also in the 99 percentile category and like you have a loss running on Folio where i dump the notes that go bad or are predicted to go bad of -8.5 or so.  It's getting better as I am getting more proactive about putting a note on Folio instead of waiting for it to get really bad.

PeerCube has my Folio account at -8.76 (half as bad as LC's NAR).  I like knowing the numbers--it helps to keep me motivated toward early  management.  I don't use an automatic method--yet.  Thanks for sharing!

rawraw

  • Hero Member
  • *****
  • Posts: 2795
    • View Profile
Re: Calculate your percentile rank vs other LC accounts
« Reply #21 on: October 30, 2014, 02:58:16 PM »
My Folio returns are 8% NAR based on FICO drops.

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #22 on: October 30, 2014, 06:10:47 PM »
Maybe LC will give a handy JSON comparison tool for Folio and overall performance.  When they do we will be sure to add a percentile tool for that too.

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 #23 on: October 31, 2014, 10:42:43 AM »
Re: Our model has a percentile score of 98 vs all accounts. And 92 vs accounts with the same age.

You may want to keep those those 2 number for each x.y
Quote
Weighted Average Age of Portfolio:   x.y mos

That way you can graph the change over the weeks.
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

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #24 on: October 31, 2014, 11:38:50 AM »
Re: Our model has a percentile score of 98 vs all accounts. And 92 vs accounts with the same age.

You may want to keep those those 2 number for each x.y
Quote
Weighted Average Age of Portfolio:   x.y mos

That way you can graph the change over the weeks.

That is a very good suggestion.  I will do that for sure.  Spreadsheet created now.

turing

  • Full Member
  • ***
  • Posts: 222
    • View Profile
    • PeerToPeerQuant.com
    • Email
Re: Calculate your percentile rank vs other LC accounts
« Reply #25 on: November 07, 2014, 04:31:02 PM »
I've implemented some of your suggestions.

1) Percentile vs Similar Age and Similar WAIR


2) Chart dynamically generated (no longer static image)

3) See similar accounts (age & wair) on the chart

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 #26 on: November 07, 2014, 04:38:25 PM »
Appears to be working. Thanks.

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