Example B: Screening on stocks vs. their Industry

Continue from Example A

Now that we have defined our investable universe, let's find companies that have an EPS growth that is above the median for their Industry and for which analysts are revising their estimates.

Define a screen for stocks that have an EPS growth above their X Industry median:

  1. From the list of Categories, select the Growth category and then the EPS Projected sub-category.
  2. From the Item list, choose the Trend category and highlight the Next 3-5 Years Est EPS Growth (%/yr) item.
  3. Double click the Next 3-5 Years Est EPS Growth (%/yr) item (or select the Screen by Database Item command from the Screen menu) or click the Screen by Database Item button.
  4. The Screen By dialog box will appear. From the operators pull-down menu, select the greater than (>) operator. In the Compare to section, choose Group.
  5. From the Group pull-down menu, select X Industry as the group and select Median as the aggregate. Leave the default "1.00" value in the coefficient box (the default coefficient of 1.00 represents the Industry median) and click OK.
  6. 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, we will search for companies with the estimate increases above 3%:

  7. From the list of Categories, select the EPS category and then the Estimate Revisions sub-category.
  8. From the Item list, choose the Estimate Revisions - Last 12 Weeks category and highlight the %Change F(1) Est. - 4 Weeks item.
  9. Double click the %Change F(1) Est. - 4 Weeks item (or select the Screen by Database Item command from the Screen menu) or click the Screen by Database Item button.
  10. The Screen By dialog box will appear. From the operators pull-down menu, select the greater than (>) operator. In the value entry box type "3" and click OK.
  11. 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.
  12. Next, click the Run Query button to run the screen and view the companies that meet our criteria.

Back | Examples | Help Home Page