Frank with dividend yield not working in Screener

Research
1

Hi,

in the screener, I would like to rank stocks by dividend yield, e.g.:
Frank(“Yield”,#Previous,#DESC) <= 10

However, this returns no stocks at all. Can you help me with this?

Thanks!

2

What are you trying to do? Assumin “All fundamentals” as the universe, 0bout 60% of the stocks have 0 Yield . All these stocks get lumped together and get the lowest rank of probably around 60 , the rest get rank between 60-100.

3

Let’s say, out of all the stocks that pay a dividend, I want to own the bottom 10 % yielding stocks.
I could filter out the 0 yield stocks in a previous filter.

How can I accomplish this with portfolio123?

4

This should work;

Yield>0
FRank("Yield",#Previous,#Asc)>=90

Walter

5

Since you’re excluding all zero dividend stocks, another option is to modify your universe to require a dividend yield be above 0 and then base your screen on that modified universe. Then FRank should work closer to intuition.

6

Here’s a one liner that will give you the 10 stocks that pay the lowest yield. The trick is to assign NA to 0 yield and use FOrder

FOrder(“eval(Yield=0,NA,Yield)” , #All, #ASC) <=10

7

deleted