exclude stocks from the ranking

Research
1

Hello I would like to make a ranking for stocks like the following:

Rule one:
First I want to make a filter which excludes all Shares which for the last year had a performance of more than 50%. So if a share raised up for 80% during the last 12 month I want to exclude it. If a stock raised up for 30% during the last 12 month I would like to include this stock in my ranking.

Rule two:
All included stocks should now be ranked like the following:
So this ranking rule is subordinated of the first rule:
The higher the performances during the last year, the higher should be the ranking.

So the result of this ranking system is the following:
The stock with 50% performances of the last year is the best. The stock with for example -90% performance of the last year is the worst. Stocks higher than 50% are excluded.

I was able to implement the Rule two: I made a stock factor Node with Pr52W%Chg.
But I was not able to implement the rule one. I tried the following: I made a stock formula node “Pr52W%Chg < 0.5” and checked Ranking Method "0/1 Boolean values. So I hoped that this would be a filter to only take the stocks with a performance < 50%. I do not know if this is the right way. The problem now is to implement the rule two as a sub rule of rule one. Rule one has now a weight of 100%. Now I marked the rule one and tried to add a new node (for Rule two). But the tab “add node” is not active (available).

Can you help me?

Thank you.

2

Hi Origon,

welcome to P123!

I would suggest you use the regular rules in the screen or simulation to include or exclude stocks from your universe.
For example, if you want to work with Pr52W%Chg, you can insert the following

Pr52W%Chg < 50

This rule alone yields the following result when rebalancing every three months and choosing all S&P500 stocks.
Afterwards you can use a ranking to further separate the wheat from the chaff.

3

Welcome aboard as well.
Since you are new to P123, I suggest reading the Tutorials in Help->Library before you do anything. This will save you a lot of time later.
Also, I like to use the Port/Simulator tool instead of the screener. It is more complicated but gives more control and it is easier to create a tradeable port from. You can read about this in the tutorials.