HomeReady-2-GoPortfolioRankingScreenerStockETFToolsCommunityHelp
ForumsEmail UserPollsFeature RequestsGroups


  Index  | Recent Threads  | Who's Online  | User List  | Search
  Search  
Quick Go »
Thread Status: Normal
Total posts in this thread: 3
[Request a Feature] [Post new Thread]
[Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 636 times and has 2 replies Next Thread
rcflyerco
Advanced Member


UNITED STATES
Joined: Jul 26, 2004
Posts: 42
Status: Offline

FRank of EPS5YCGr% Reply to this Post
Reply with Quote

As the first line of a screen,

FRank("EPS5YCGr%",0,1) < 50

returns sub total 0, while

FRank("EPS5YCGr%",0,1) > 50

returns 6794. If my syntax is correct, I think these lines should each select a little less than 3400 stocks.

Identical behavior occurs ranking stocks based on EPS3YCGr%, Possibly, this is a data error involving these two variables because FRank of Sales5YCGR% and Sales3YCGR%, and EPS%ChgTTM appear to work correctly.

Rick
[Apr 26, 2006 12:20:11 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 3992
Status: Offline

Re: FRank of EPS5YCGr% Reply to this Post
Reply with Quote

When you try

EPS5YCGr%=NA

You get 3718 companies that have NA. The ranking assigns the same rank to all the NA's and that ranking is somethin bigger than 50 since that is the last rank before all goes to NA's.

This is by design otherwise factors with many NA's like this one would over-penalize NA's when use in ranking systems.

Hope that was clear
----------------------------------------
Portfolio123 Staff
[Apr 26, 2006 1:03:06 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
rcflyerco
Advanced Member


UNITED STATES
Joined: Jul 26, 2004
Posts: 42
Status: Offline

Re: FRank of EPS5YCGr% Reply to this Post
Reply with Quote

Makes sense.

Thanks,
Rick
[Apr 26, 2006 11:35:13 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
[Show Thread Printable Version] [Post new Thread]

Free Trial  /  Log In
Username or Email
Password
Stay logged in
Can't remember username or password?