Query Builder Window

The Query Builder window consists of the Edit pane and the SHOW WHEN panes. If you are familiar with the query language, you may type a query directly into the Edit pane. The SHOW WHEN panes allow you to create syntax through menu-driven selections. The following shows the components that make up the SHOW and WHEN statement portions of the Query Builder window.

Query Builder SHOW Statement

To build a query from scratch, the user must enter a symbol and column and select the Add Attribute to Query button. If you need to clear the Symbol and Column fields then select the Restart Attribute button and start over. Once the Add Attribute to Query button is selected, the query will display in the Editpane. Use the buttons listed under the SHOW statement portion of the Query Builder window to modify the query. The following gives a description of the buttons and their functions. For more information see the "SHOW/WHEN" chapter in the XMIM User Guide.

Table: SHOW Buttons

StudiesA study is a mathematical or statistical calculation of a data series. Some of the studies are macros which may be modified, saved and renamed using the macro editor.
Arithmetic OperatorsUse the arithmetic operators: add, subtract, multiply, divide, power of to accomplish any mathematical formula.
Attribute UnitsAttribute unit sets the default time frequency for any attribute expressions built in XMIM.
Edit RolloverUse the choices in the Edit Rollover window to create custom futures contracts.
Time OffsetThe Time Offset menu is used to pick a date, relative to 'today' or the current date executed within the system.
Profit Loss
Use the choices in the Profit Loss window to show statistics resulting from an ORDER query block.
IF-THEN-ELSE Statement (SHOW)This language structure lets you assign values to your Attribute in the SHOW statement based on time, date, event or price conditions.


Query Builder WHEN Statement

Once the SHOW portion of the query is built, use the following buttons to build the WHEN portion of the query statement. The following gives a description of the buttons and their functions. For more information see the "SHOW/WHEN" chapter in the XMIM User Guide.

Table: WHEN Buttons

Logical OperatorsMultiple WHEN conditions in your query can be linked together into a complex condition using the And, Or, Xor, And Not, Or Not, Xor Not logical operators.

Date Time Condition

Use the settings in the Date Time Condition window to set either date or time conditions. Use the date choices to set historical date criteria. Use the time choices to set a particular time or range of times during the trading day.
Custom Event
Use the settings in the Custom Event window to search for conditions, events and patterns in price series. This menu is often used to specify certain market conditions.
Market Event
The Market Event window contains predefined events created by LIM.
IF-THEN-ELSE Statement (WHEN)
This language structure lets you assign values to a condition in your WHEN statement based on time, date, event or price conditions.
Repeat

This time saving feature is selected when you wish to repeat the WHEN condition statement for a continuous period of time.