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.
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
![]() | Studies | A 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 Operators | Use the arithmetic operators: add, subtract, multiply, divide, power of to accomplish any mathematical formula. | |
![]() | Attribute Units | Attribute unit sets the default time frequency for any attribute expressions built in XMIM. | |
![]() | Edit Rollover | Use the choices in the Edit Rollover window to create custom futures contracts. | |
![]() | Time Offset | The Time Offset menu is used to pick a date, relative to 'today' or the current date executed within the system. | |
![]() | Profit Loss |
| |
![]() | 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. |
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 Operators | Multiple 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. | ||
![]() |
| 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. | ||
![]() |
| 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. | ||
![]() |
| The Market Event window contains predefined events created by LIM. | ||
![]() |
|
| ||
![]() |
|
|