The first step in creating an advanced MIM query is to select MIM Queries from the MIM menu.
The next step in creating an advanced MIM query is to enter the information in the Query List dialog box.
Type an entry in the Name field, then select Create. A description of the user and the queries can be entered in the Description field. This description field becomes active in the next display after selecting Create.
After you create a query, you can return to this dialog box to run the query, later edit the query, create a new query, delete the query or copy the query. Close will return you to the Excel worksheet.
Enter the following query in the Create Query dialog box. Enter a Description then select OK.
A query can be developed and tested using the XMIM, then copy/pasted into this query box.
Select Close to close the Query List dialog box.
The following options can be set:
Execution Units - Pick the time frame units for the data (seconds, minutes, days, years, etc.).
Current Tick Data - If you have a real-time feed connected to the MIM server, check Current Tick Data. (Consult your LIM System Administrator as this is not common.)
Summary Stats - In order for the MIM to generate summary statistics to go along with the data request, check Summary Statistics. The statistics included are: Sum, Average, Average Positive, Average Negative, Percent Positive, Percent Negative, Highest, Lowest, Standard Deviation, Z stat, and Variance.
Clear Worksheet - Clears the worksheet of any data before displaying the new query data. Note: If several queries have been created, they will execute in alphabetical order and only the first one should have this box checked. If the second, third, etc. query had Clear Worksheet checked, then the first query’s results will be erased.
Print Data Headers - This option prints the assigned label names at the top of the columns in the spreadsheet.
Decimal Places - Set the decimal place. The default is set to 5.
Target Cell - Select the bar next to the destination cell:
The Create Query dialog closes and the Excel Worksheet opens. Select the desired cell to store the data and then select the
button to return to the Create Query dialog.
After creating queries, you can run them all at once by selecting the Run All Queries from the MIM menu. After running a query, you can go back and edit the query or make a new query by selecting MIM Queries from the MIM menu.
An example of a portion of the resulting data for the query:
Clear the spreadsheet before continuing to the next example.