Ranking Sectors

   Hi All,

Is there a way to Rank (similar to the Excel function "Rank") or pick the top x values of a list? 

What I am trying to do is give each sector a score and then be able to select the top 5 scores.  The score could be based on any number of things, but one example is:  the sum of the % change of that sector over the last 15 periods. 

I would like to use this as of the criteria in a scan to make sure that the security in question is in the top 5 sectors as defined above.

Thanks for your help.
Jeremy.

Author	Message / View First Unread Post Share Topic Printable Version Delicious Digg Facebook Furl Google Boomarks Google Buzz MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
jhubbard Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17 Sep 2009 Location: Sydney Posts: 10	Post Options Post Reply Quote jhubbard Report Post Quote Reply Topic: Ranking Sectors Posted: 17 Sep 2009 at 2:49pm
	Hi All, Is there a way to Rank (similar to the Excel function "Rank") or pick the top x values of a list? What I am trying to do is give each sector a score and then be able to select the top 5 scores. The score could be based on any number of things, but one example is: the sum of the % change of that sector over the last 15 periods. I would like to use this as of the criteria in a scan to make sure that the security in question is in the top 5 sectors as defined above. Thanks for your help. Jeremy.