### Author Topic: Percentile calculation  (Read 2855 times)

#### ThinleyWangchuk

• Full Member
• Posts: 105
##### 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: 2784
##### 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: 105
##### 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
##### 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: 1430
##### 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