Alert Conditions

Alert Conditions allow you to define a custom alert based on the cell's value. Alert Conditions are defined per column, and the Alert notifications they create are displayed in the Alert Window. To enable/disable Alert Conditions press down on your right mouse button inside the Market Analyzer window select the menu "Alerts".

Creating an Alert Condition

To create an Alert Condition:

The example Alert Condition in the above image will:

You can remove an Alert Condition by pressing the Remove button.

Please note setting the "Re-arm after secs" property to a value of zero means the alert will not re-arm once triggered.

Multiple Alert Conditions vs. Multiple Alerts

It is important not to confuse multiple Alert Conditions with multiple alerts.  You can have one alert per Market Analyzer column and each alert can have multiple conditions. Conditions are evaluated from top to bottom.

Assume you have an alert with the following conditions defined:

Alert if value is greater than 30
Alert if value is greater than 100

In this example, if the value of the cell was greater than 100, the first condition of "greater than 30" would trigger the alert since its first in the list of conditions to be evaluated. The "greater than 100" condition would never trigger in this example since "greater than 30" will always trigger the alert first. To ensure that both conditions trigger an alert so that you get the desired alerting behavior you want, you have to list the conditions in this order:

Alert if value is greater than 100
Alert if value is greater than 30

This will guarantee that a cell value over 100 will fall in the "greater than 100" condition and cell values between 30 and 100 will be triggered by the "greater than 30" condition.

Cell Conditions

Cell Conditions allow you to define the display behavior of a cell based on the cell's value, and are defined per column.  You can choose to alter both the color and text of a cell with Cell Conditions.

Creating Cell Conditions

To create a Cell Condition:

The example Cell Condition in the above image will:

You can remove a Cell Condition by pressing the Remove button.

Multiple Cell Conditions

Cell Conditions are evaluated from top to bottom.

Assume you have the following conditions defined:

Change cell if value is greater than 30
Change cell if value is greater than 100

In this example, if the value of the cell was greater than 100, the first condition of "greater than 30" would change the cell's color since its first in the list of conditions to be evaluated. The "greater than 100" condition would never trigger in this example since "greater than 30" will always trigger the color change first. To ensure that both conditions trigger a color change so that you get the desired alerting behavior you want, you have to list the conditions in this order:

Change cell if value is greater than 100
Change cell if value is greater than 30

This will guarantee that a cell value over 100 will fall in the "greater than 100" condition and cell values between 30 and 100 will be triggered by the "greater than 30" condition.

Filter Conditions

Filter Conditions allow you to define conditions that filter out rows from the Market Analyzer grid display based on the cell's value and are defined per column.

Creating Filter Conditions

To create a Filter Condition:

The example Filter Condition in the above image will:

You can remove a Filter Condition by pressing the Remove button.

To enable/disable filtering press down on your right mouse button in the Market Analyzer window and select the menu Row Filter. When enabled, the Market Analyzer will filter out rows from the grid display based on the Filter Conditions of the columns.