MIM Excel Add-in Details

 

MIM Excel Add-in Main Menu

MIM Excel Add-in Menu

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 - Load your own proprietary data via the MIM Excel Add-in.

  • Get Options - A feature for extracting data from the Options Facility. 

  • Get Financials - New feature coming soon for calculating COMPUSTAT reports.

  • Options - Use the Config MIM Connection to set network parameters. In the Preferences dialog box set decimal place precision, refresh control, time stamp and date formatting options.

  • Help - Information about the MIM Excel Add-in such as version number and access to the Excel web pages and training video.