The MIM Excel Add-in software provides direct access to time series data from a MIM server. Using the MIM menu, users can extract daily futures prices and many other data series. The MIM add-in is a client application for the MIM server. The MIM server provides time series data to the enterprise over the network.
The MIM Excel Add-in creates the MIM menu on the Excel menu bar. Using the MIM menu, users can create requests for data and populate Excel worksheets with values. The requests are saved in the Excel workbook using a hidden worksheet.
Highlights of the MIM Excel Add-in:
Data requests are created and edited using a step-by-step wizard dialog.
Includes an integrated MIM schema browser and schema search to locate data.
Includes support for units of measure conversions.
Features several types of futures contract reshaping, including prompt contract offsets and several switching day policies.
Data requests are stored in the Excel workbook in a hidden sheet. Data refresh is a single click menu operation.
Workbooks with data requests can be attached to emails and used by any other user with the MIM Excel Add-in software.
The functionality of MIMIC is available while working within Excel.
The steps for creating data are:
Request data using the data browse, symbol search or description search.
Refine data using date delimiters.
Refresh the worksheet to display the data.
Specify the location on the Excel worksheet to create data.
Once the MIM Excel Add-in is installed, Excel will have a new menu item labeled MIM.
The following provides details on each menu item.
The MIM Excel Add-in menu items perform the following tasks:
Refresh Data - Refresh the data in the workbooks by downloading the data from the MIM server.
Add Data - Add a new data item to the MIM. Data requests are configured in the workbook.
Edit - Change the parameters of previously created MIM data requests.
Run All Queries - Runs all queries setup by the user.
MIM Queries - Create and edit queries in this menu.
Get Records - Run queries on multiple data blocks.
Show When - Create Show/When queries easily within one dialog menu.
Forward Curve - Create a Forward Curve chart from a user selected futures contract.
Load Data - Enter data from an Excel spreadsheet into the MIM database.
Get Options - Use Get Options to access the special columns established for analyzing options.
Get Financials - Functionality no longer available.
Options - Set network parameters and decimal place settings.
Help - Information about the MIM Excel Add-in such as version number and access to the Excel Web pages and Online Tour on the LIM Web site.