The filter is an important instrument for filtering the results of the optimizer and scanner for certain values.

Filter Values

Filter buttons in the toolbar
The filtering proceeds in two steps:
  1. Click the Edit Filter button in the Toolbar under Home > Table > filter to set up a filter.

Filter Set up

When setting up the filter, you define one or more criteria that form the filter. You have the following options:
Create a new filter
  • New - Starts a new filter. An existing filter will be deleted. It is not possible to set up and save several filters. However, you can enter parallel filters combined by OR. A dialog opens. Here you can enter which column should be tested with which operator (=, >, <...) Confirm with OK.
  • Edit - Opens the dialog as explained above, in which you can edit the selected filter criteria.
  • Delete - Deletes the selected line in the filter.
  • OR - Choose this to enter other possible criteria sets. This way, you may avoid setting up new filters. Enter all important filters with OR between them. The ones that don't apply are ignored.
  • Move up/Move down - With these buttons you can move a criterion up and down in the appliance sequence.

Advanced Filter Options

Click on Show Advanced Options to display additional options:
  • Show all filtered rows - All rows of the table are shown. An additional column named Filter appears, in which rows are labeled "true" or "not true".
  • Alternatively you can combine the row display with another condition by selecting an Equilla formula in the list or entering a new one. In this case, only filtered rows that fulfill the second condition are displayed.
This option is only available for Scanner documents.

Example - Filtering for Strongest Values

  1. Open a new scanner and fill it with the 50 symbols of the "Dow Jones Industry", for example. Add the indicator Relative Strength Levy.
  2. Perform the scan.
  3. Click the Edit Filter button in the toolbar to open the filter criteria dialog.
  4. Click the New button and choose the column "RSL" for testing. That's the relative Strength Levy indicator we have entered in the scanner.
  5. Select the operator > and enter the number "1" as the value to be tested against. Confirm your settings.
As a result you get a filtered list that includes only stocks with a Relative Strength Levy of more than 1.