Introduction

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 item, users can create requests for data and populate Excel worksheets with values. The requests are saved in the Excel workbook using a hidden worksheet.

If you do not have the MIM menu on your Excel menu bar, please contact your local MIM administrator for instructions on obtaining the MIM Excel Add-in.

Top
LIM Home

Installation Instructions

For installation instructions please see the chapter "MIM Excel Add-in Installation"  located in the "Client Application Installation Guide". 

Top
LIM Home

Highlights of the MIM Excel Add-in

• Data requests are created and edited using a step-by-step gui 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.

Top
LIM Home

Take a Tour

To get started with the MIM Excel Add-in, please take a tour.

Topics in the MIM Excel Add-in tour include:

• Browse data example

• Search symbols example

• Search descriptions example

• Select a recently used data item

• Merge data

• Edit data

• Run All Queries

• MIM Queries

• Show When Function

• Get Records Function

• Forward Curve

• Load Data

• Get Options

• Get Financials

• Details

Top
LIM Home

Working Example

Here's a problem that takes you step by step through the solution.

For details on the controls and options for the Add-in, see the Details section. 

Top
LIM Home

Movie

Download and run the new MIM Excel Add-in movies:

MIM Excel Add-in Movie Part I (adv_exceladd.exe) - 
Shows how to create and run MIM queries. 

MIM Excel Add-in Movie Part II (advexceladdin2b.exe) - 
Demonstrates the latest features of the Add-in: the Show When and
Get Records functions.

The TSCC codec encoder/decoder will automatically be installed onto your system. TechSmith video codec (TSSC codec) offers perfect "lossless" quality, fast compression speeds, and exceptional compression of typical desktop application activity.

Top
LIM Home