Filter Conditions

Filter conditions are simple logic statements that:

•	Compare the value in a ScanExpert Viewer Grid column to a value or a range of values. A simple example of this would be a filter that displays the subset of symbols whose RSI value is currently below 50 but greater than or equal to 10.

•

Compare the value in a ScanExpert Viewer Grid column to the value in another column. A simple example of this would be a filter that displays the subset of symbols whose Close price is currently above the 25-period moving average. In this case Close price and 25-period moving average would both be columns in the Grid.

Filters can be very simple (i.e., based on one condition) or complex (i.e., based on multiple conditions). Filters are always based on the columns of information available in the ScanExpert Viewer Grid so it is important that the script you are using contains columns (formulas) for the values that you will ultimately need in your filter. So, for example, if you know that you want to filter on a 20-period Stochastic %D as one of your conditions, then your ScanExpert script must contain a reference to a 20-period Stochastic %D. By planning ahead and carefully selecting the formulas that will be included in a script, there is no limit to the kinds of filters that can be created. (see Creating a New Script for more information).

Note: All filter conditions are cumulative. If you enter 3 filter conditions in the Filter Specifications dialog then all 3 conditions must evaluate to true in order for a symbol to be displayed in the filter results.

Filter Operators

=	Equal To. A filter condition of "=500" means that in order to satisfy the filter requirements a security must have a value of exactly 500 in the column in which this condition was entered.
!	Not Equal To. A filter condition of "!500" means that in order to satisfy the filter requirements a security must NOT have a value of 500 in the column in which this condition was entered.
>	Greater Than. A filter condition of ">200" means that in order to satisfy the filter requirements a security must have a value greater than 200 in the column in which this condition was entered.
<	Less Than. A filter condition of "<200" means that in order to satisfy the filter requirements a security must have a value less than 200 in the column in which this condition was entered.
>=	Greater Than or Equal To. A filter condition of ">75.65" means that in order to satisfy the filter requirements a security must have a value greater than or equal to 76.65 in the column in which this condition was entered.
<=	Less Than or Equal To. A filter condition of "<75.65" means that in order to satisfy the filter requirements a security must have a value less than or equal to 76.65 in the column in which this condition was entered.
COL[X]	Column Reference. Use this to refer to the value in another column where X is the column number of the column to be referenced. A filter condition of ">=COL[4]" means that the value in the current column (where this condition was entered) must be greater than or equal to the value in Column #4.
AND	Use AND to create multiple conditions for a single column. A filter condition of ">20 AND <200" means that in order to satisfy the filter requirements a security must have a value greater than 20 and less than 200 in the column in which this condition was entered.
OR	Use OR to create multiple conditions for a single column. A filter condition of "<20 OR >200" means that in order to satisfy the filter requirements a security must have a value less than 20 or greater than 200 in the column in which this condition was entered
K	Use K as a shortcut for 1000 (thousands) in a filter condition. A condition of ">3K" means greater than 3000. A condition of "<55.32K" means less than 55320.
M	Use M as a shortcut for 1000000 (millions) in a filter condition. A condition of ">3M" means greater than 3,000,000.