Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 12/22/2004 Posts: 14
|
A percentile rank is calculated in tc2000Funds for various time frames. Why doesn't this ranking coorealate with actual performance of the fund? some funds ranking 97 to 98 over various time periods are losers while some funds ranking <50 are doing much better than the high ranking funds. Am I using this percentile wrong? Show me the math on the calculation of the percentile of the total return. Thanks.
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Total return takes into account return from dividend payouts.
- Craig Here to Help!
|
|
Registered User Joined: 12/22/2004 Posts: 14
|
pLEASE ANSWER my question and not give an obtuse , nothing answer which is obvious to all. Do you have any inferences from your reply that I missed. Do you think you answered my original question. ALSO, i ASKED FOR THE MATH TO CALUCULATE THE percentile grouping OF TOTAL RETURN. pLEASE ANSWER .
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I must not understand your question.
Are you asking how Rank is assigned in TeleChart for a condition?
- Craig Here to Help!
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Here's how Total Return 1 Year is calculated PCF form:
(C-C250)/C250*100
The value is expressed as a percentage. If you then sort all funds from highest % to lowest %, the top 1% will have a ranking of 99, the next highest 1% will have a ranking of 98, etc.
|
|
Registered User Joined: 12/22/2004 Posts: 14
|
Yes and No, I'm not asking your question about rank? Is percentile rank meaningless in selcetion of the quality of a Fund? For example MF sysmbol FBRVX has had a total return ranking of 93 to 97 for various time periods over the past 5 yrs( 1 month, quarter to date, year to date 3yrs and 5 years). Yesterday it lost money again but retained it's high ranking which to me does not make sense. Similarly CSRSS lost money the last several days but retain a ranking of 98 to 99 during these various time periods. Unwpx has a current ranking of '3' and it too lost money the past several days. Obviously 2 is not equal99 so how do you calculate each of the percentile ranks? I would like to use the total return as a ranking criteria. Am I using it incorrectly?
I have this same unanwered problem for several years now. Please refer to your acrhives of 'Ask the trainer' for the used 'bhop' and you will see my fustration!
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Checking with the data department on this as well to be sure I'm correct.
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
The data department found an issue with the Total Return - Year to Date ranking data. If a ranking number was not returned for a particular fund (fund went defunct, etc.), the record was not updated. This has been happening for some time, so there were many funds with rankings that shouldn't have had one.
I created a Year to Date return PCF, calculated it, and compared against the rankings and all looks correct now.
This same issue affected other ranking criteria as well. All should be correct now.
|
|
Guest-1 |