Author Topic: Percentile calculation  (Read 3066 times)

ThinleyWangchuk

  • Full Member
  • ***
  • Posts: 106
    • View Profile
Percentile calculation
« on: September 29, 2014, 05:33:16 PM »
How do you calculate the percentile of a portfolio (v. other lenders)...
What net return would you consider being in the 99th percentile?
« Last Edit: September 29, 2014, 05:50:35 PM by DonDaVinci »

rawraw

  • Hero Member
  • *****
  • Posts: 2793
    • View Profile
Re: Percentile calculation
« Reply #1 on: September 29, 2014, 10:22:39 PM »
You'd have to have an set of returns to compare.  I would use Excel's percentilerank function.  Or I guess you could use a Z-Test if it is normally distributed

ThinleyWangchuk

  • Full Member
  • ***
  • Posts: 106
    • View Profile
Re: Percentile calculation
« Reply #2 on: September 29, 2014, 10:44:55 PM »
Is there a file that has this data (net returns)?

brycemason

  • Hero Member
  • *****
  • Posts: 801
    • View Profile
    • P2P-Picks.com
    • Email
Re: Percentile calculation
« Reply #3 on: September 30, 2014, 12:01:16 AM »
No, there is no publicly available file that has every investor's returns in it. The closest thing you can get is LC's nice "Understanding My Returns" chart from its account overview page.

lascott

  • Hero Member
  • *****
  • Posts: 1433
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Percentile calculation
« Reply #4 on: September 30, 2014, 01:07:43 AM »
How do you calculate the percentile of a portfolio (v. other lenders)...
What net return would you consider being in the 99th percentile?
Based on the chart from your  "Understanding My Returns" you can see that return number will vary quite a bit by the average age of the portfolio.  Did you know about "Understanding My Returns" when starting the thread?  What is your the goal?  I would be more focused on consistent returns over the long haul and if there is a little of an economic downturn.
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