Creating Cell and Filter Conditions
Market Analyzer columns can have cell and filter conditions applied to them for a more convenient display of information.
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
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
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 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.
Applying conditions to specific instruments
When setting up Cell and Filter conditions, the default behavior is to apply these conditions to all instruments in the Market Analyzer.
However, you can optionally reconfigure these conditions to apply to instruments with specific names. For example, if you had a Market Analyzer setup with several different instruments (as per the screen shot above), but only wanted your Cell conditions to work on only the Futures instruments, you can redefine your conditions to only include those instruments by:
4. Press OK on the Instruments window
5. Your Apply to field will now list the instrument names you selected earlier, indicating that conditions will only be triggered on instruments contained in this list.
6. Press OK Conditions window
Your Market Analyzer window will now only apply these conditions to the instruments which mach the name you configured