Want to screen for:

Top 16 subindustries in the top 8 industries

From this set, stocks that outperformed the market in the last 4 weeks but with the smallest price increase.

So I'm looking for the stocks with the largest potential increase going forwarrd.

How do I scan for these conditions?

Thanks.

Happy New Year!

How do you quantify "top 8 subindustries" and "top 16 subindustries"?  By percent change? Over what time period?

Thank you for responding.

Over a 4 week period by percent change

I really can't think of a fully automated method of doing this. Maybe StockGuy has a better idea.

We will start by creating a Main Industry WatchList. Make sure you have a Company Name WatchList Column and click on it to use it as a Sort. Then change the WatchList to Morningstar Industry Group Averages. The Main Industries will have Company Names that both start and end with a - and have symbols that end in 0. This means they should be at the top of Morningstar Industry Group Averages WatchList when it is sorted by Company Name in ascending order.

Highlight the Main Industry Group symbols in the WatchList and then right-click on one of them to select Copy (31 syms) to... (Ctrl-C). Choose (New Personal WatchList) and call it Main Industries when prompted.

Then you need to create an Indicator Formula for a 4-Week Price Percent Change. If you set the Time Frame of the Indicator Formula to Daily you could use:

100 * (C / C20 - 1)

If you set the Time Frame of the Indicator Formula to Weekly you could use (note that these formulas will not return the same results most of the time):

100 * (C / C4 - 1)

You will want to Save the Indicator Formula you created for a 4-Week Price Percent Cange and add it as a WatchList Column so we can use it is a sort.

You shouldn't have to repeat the above steps each time you do this as long as don't delete the Main Industries WatchList or 4-Week Price Percent Change WatchList Column.

Each time you want to get a list of the top 16 Sub Industries in the top 8 Main Industries you will start by bring up your Main Industries Personal WatchList and then clicking on the 4-Week Price Percent Change WatchList Column Header to use it a sort. You may have to click on it twice to get the results in descending order with the highest price percent changes at the top of the list.

We will then click on each of the top 8 symbols in the WatchList in turn and select the Industry Info icon immediately to right of the symbol in the upper left hand corner of the chart. You will want to choose Open Main Industry WatchList.

Then sort the WatchList which comes up by symbol and scroll down until you can highlight all of the MG symbols in the list which don't end in 0. Then right-click on one of the symbols and select Copy to...

Where you copy will depend on how you want to set up your workflow. You could create a single Personal WatchList for which you delete all of of the symbols each time you do this or you could create a new Personal WatchList each time you do this. No matter which option you choose, the first Main Industry for which you do this should result in a Personal WatchList with just those symbols in it. You do not want to have other symbols already in the WatchList.

For the other 7 Main Industries, you will repeat the process of selecting the symbol and clicking on the Industry Info icon but copy the Sub Industry symbols into the same WatchList in which you already copied the first Main Industry.

You now have a Personal WatchList which has all of the Sub Industries in the 8 top performing Main Industries. You now need to sort this using the WatchList Column based on your 4-Week Price Percent Change Indicator Formula. If the sort is in descending order, then the top 16 symbols in the WatchList will be the 16 top performing Sub Industries in the 8 top performing Main Industries.

Thank you a lot

You're welcome.