Is it possible to target stocks in the 3rd quartile for example?
Let us say I want to get all stocks in a sector ranked by Net Profit Margin…but want to target 25% of them below the median?
Thanks
I saw an example…can be done using two Frank
FRank(…)>(100-(50))
&
FRank(…)<(100-(75))
Or, maybe, Between(FRank(…),50,75) would be more efficient.
I believe that the following may work to target the 25% below the median
1st rule: frank(“…”)<50 // this will get everything below the median
2nd rule: frank (“…”,#previous)>50 //this will get the top 50% of the previous rule or the 3rd quartile.
Best,
Aleksey
Frank is a very powerful tool. If it were available in Custom Series much of the work of the main screen would be passed as a “getseries” and take load off the main screen. Please vote for FRank in Custom Series here: http://www.portfolio123.com/feature_request.jsp?featureReqID=1210