Example A: "Technical Investor": Screen database DBCM for companies with significant recent price action. Select those companies with a 20% price increase over the last 4 week period and a 50% price increase over the last 12 week period.
Four week %Price change is DBCM item 11 and twelve week %Price Change is DBCM Item 13. We will use the Direct Method for creating this calculation expression.
- From the Screen menu, select the Screen by Calculation Expression command or click the Screen by Calculation Expression button.
- The Calculation Expression window will be displayed.
- Type the following expression into the Calculation Expression data entry box:
i11>20 And i13>50 - Click OK.
- The Screen By dialog box will appear. Select TRUE from the menu options to include only those companies that meet both conditions (20% price increase over the last 4 week period and a 50% price increase over the last 12 week period).
- The Screening Criteria table will fill up showing the calculation. The Report Definition will also contain the calculation expression. ou may want to delete it from the Report Definition, because every company will have 1 as the data value. Instead, you may want to include a 4 week % Price Change item and a 12 week %Price Change item.
- Click the Run Query button to view the companies that passed your screen.