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!
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!
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.
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?
This should work;
Yield>0
FRank("Yield",#Previous,#Asc)>=90
Walter
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.
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
deleted