BullScan: Ranking Sectors

Print Page | Close Window

Ranking Sectors

Printed From: BullCharts Forum
Category: BullCharts
Forum Name: BullScan
Forum Discription: For discusssions on BullScan
URL: http://www.bullcharts.com.au/forum/forum_posts.asp?TID=577
Printed Date: 18 May 2024 at 6:18pm
Software Version: Web Wiz Forums 9.69 - http://www.webwizforums.com

Topic: Ranking Sectors

Posted By: jhubbard
Subject: Ranking Sectors
Date 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.