Screening for yields greater than S&P 500

Please help with instructions for screening for stocks with a yield that is greater than the S&P 500 (or other index). If not, is there a way to screen for stocks that are greater than the average of the universe that I’m using in a screen? I’ve tried the following formula, which runs without errors, but it returns nothing.

Yield > Close(0,#SPYield)

Thanks for the help!

It depends on what top level universe you are using. The universe you selected may not have any. I found 8 stocks in the SP500 that meet your equation.
The thing I am not sure about is that if you create a screen and use showvar to actually see the value, it is 5.91. Which looks really high and hence the few stocks that meet it. So I don’t know if this value is correct or what it really represents…I found elsewhere on another site that the current SP500 dividend is 2.14%, which sounds more like it.


From the documentation at: TIME SERIES IDS->S&P 500 IDs

So name is misleading. Should have been called something like #SPESTYIELD. There are several ways to calculate the SP500 Yield

Using median (~2.09%): FMedian(“yield”,#sp500)

Using the aggregate & Cap Weighting Avg(~2.2%): Aggregate(“yield”, #sp500, #CapAvg, 0, #Exclude, FALSE )

Using the aggregate and simple Avg (~2.1%): Aggregate(“yield”, #sp500, #Avg, 0, #Exclude, FALSE )

Type these rules in a screen to see the values (the starting uinverse doe not matter with the #SP500 scope:

ticker(“ibm”)
showvar(@ycapavg, Aggregate(“yield”, #sp500, #CapAvg, 0, #Exclude, FALSE ) )
showvar(@yavg, Aggregate(“yield”, #sp500, #Avg, 0, #Exclude, FALSE ) )
showvar(@ymedian, FMedian(“yield”,#sp500))

NOTE: values are all quite similar!

Thank you!

Last question - So #SPESTYIELD is an earnings yield calculation, not referencing dividends at all?