Example C: Screen for stocks that have a P/E 20% below their Industry median and are paying dividends.
- From the list of Categories, select the Ratios category and then the P/E sub-category.
- From the Item list, choose P/E Ratios using EPS Estimates category and highlight the P/E using F(1) Estimate item.
- Double click the P/E using F(1) Estimate item (or select the Screen by Database Item command from the Screen menu) or click the Screen by Database Item button.
- The Screen By dialog box will be displayed. From the operators pull-down menu, select the less than "<" operator. In the Compare to section, choose Group.
- From the Group pull-down menu, select X Industry as the group and select median as the aggregate.
- Next, type 0.8 in the coefficient box. The default coefficient of 1.00 represents the Industry median. Typing 0.8 will indicates the P/E 20% below the median P/E. Click OK.
- The screening item will appear in the Screening Criteria table (below the Categories and Items section). It will also be added to the Report Definition table.
Next you would like to include only stocks that pay dividends. To do this, screen for stocks with a current dividend yield above 0.
- From the list of Categories, select the Ratios category and then the Dividend and Payout sub-category.
- From the Item list, choose the Dividend Ratio category and then highlight the Current Dividend Yield (%) item.
- Double click the Current Dividend Yield (%) item (or select the Screen by Database Item command from the Screen menu) or click the Screen by Database Item button.
- The Screen By dialog box will appear. From the operators pull-down menu, select the greater than ">" operator. In the value entry box type "0" and click OK.
- The screening item will appear in the Screening Criteria table (below the Categories and Items section). It will also be added to the Report Definition table.
- Next, click the Run Query button to run the screen and view the companies that meet our criteria.