Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Proper use of total return Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bhop
Posted : Tuesday, March 6, 2007 12:55:19 PM
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.
Craig_S
Posted : Tuesday, March 6, 2007 1:05:51 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Total return takes into account return from dividend payouts.

- Craig
Here to Help!
bhop
Posted : Tuesday, March 6, 2007 2:17:08 PM
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 .
Craig_S
Posted : Tuesday, March 6, 2007 2:24:18 PM


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!
StockGuy
Posted : Tuesday, March 6, 2007 3:00:49 PM

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.
bhop
Posted : Tuesday, March 6, 2007 3:06:28 PM
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!
StockGuy
Posted : Tuesday, March 6, 2007 3:10:28 PM

Administration

Joined: 9/30/2004
Posts: 9,187
Checking with the data department on this as well to be sure I'm correct.
StockGuy
Posted : Thursday, March 8, 2007 9:47:04 PM

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.
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.