With XmimGetData you can pass the results of a MIM query into the cell of a worksheet. There are four input parameters for XmimGetData:

relation, column, start date, end date (optional)

The following is an example of how to enter the string:

=XmimGetData(“HO”, “Close”, “6/1/2004”, “6/30/2004”)

where:

Select MIM>Refresh Data from the Excel menu bar to return a value back into the selected cell on the worksheet.

The following graphic shows the XmimGetData string entry and how the data result is returned back into the selected cell. The MIM query equivalent to this entry would be Show Close of HO When date is 6/1/2004 to 6/30/2004.

The user can also just pass the start date and no end date. The graphic below shows an example of only entering a starting date:

Each argument can be passed to XmimGetData directly or indirectly. In the example above the argument is passed directly as the symbol, column and date information is entered directly in the string field.

To pass an argument indirectly, a user can specify the relation, column, start and end dates on another location in the spreadsheet. In the example below, the user is indirectly referencing the argument strings in cells D1, E1, D2 and E2.

An argument may be passed both directly and indirectly by entering some of the information in the string field and referencing some of the information from the worksheet cells. In the example below, the relation name CL and the column name Close is entered in the string field. The start date 3/1/2004 is referenced in cell D2 and the end date 3/15/2004 is referenced in cell E2.