Hi, how do I write a buy rule in a Screen to limit the # of stocks from any GICS/Industry/Sector?
Thanks.
Hi, how do I write a buy rule in a Screen to limit the # of stocks from any GICS/Industry/Sector?
Thanks.
You could run a rank-sort (i.e., FRank(); FOrder(), etc…) using an #industry scope parameter and then choose the top ‘n’ stocks from each scope.
Thanks but wouldn’t that set a minimum # of stocks for an industry? And possibly elevate some stocks from that industry into the buy list to the exclusion of what would otherwise be the top-ranked stocks?
I want to set the maximum number of stocks for an industry. I have a 10-stock screen and currently it selects 7 out of those 10 stocks from just one industry. I want more diversification by capping the maximum stocks for any industry to, say, 4.
indweight, secweight
sglinski is right. Indweight and Secweight work, but you’d have to use them in a portfolio sim. I know of no way to accomplish your intent in the screener.
SecCount/IndCount in a screen. Rule must be the last rule in the screen.
Thanks. IndCount works - sort of. The screen doesn’t elevate the next highest-ranked stocks from other industries into the buy list, as I had hoped. But it’s a start.
Thanks again for all the assistance,
Ed