MIM Excel Add-in Training Guide

MIM Excel Add-in Training Guide

MIM Excel Add-in Training Guide

Build Number: 2.6.0

Publication Date: August 24, 2007

Copyright © 2001-2007 by Logical Information Machines, Inc.

Table of Contents

Getting Started

Objectives
Installing the MIM Excel Add-in
Overview

Refresh Data

Refresh Data from the MIM Menu Bar

Auto-Refresh Data

Visual Basic Instructions for Auto-Refresh

Find a New Data Item

Browse Data Example

Search Symbols Example

Search Descriptions Example

Recently Used Data Item Example

Merge Example

Merge Example - Dates and Data Retrieval Options Must Match
Merge Example - Restoring Date Fields to Number Fields

Working Example

Problem
Step by Step Solution

MIM Queries/Run All Queries

Step-by-Step Solution

Query List Dialog
Create Query Dialog
Run All Queries

Get Records Function

Problem
Step-by-Step Solution

Show When Function

Problem
Step-by-Step Solution

Forward Curve

How to Use the Data Loader

Enter Data on the Spreadsheet
Load Data from the MIM Menu

Get Options and the Options Facility

Introducing the Options Facility

Options Data Offerings
Tools for Extracting Options Data
Columns for Options Data
Get Options

Using MIMICExcel

Objectives
Market Brief

Step-by-Step Solution

Creating an Embedded Query in MIMICExcel
Narrowing the Date Range using Advanced Refresh
Using the Query Manager in MIMICExcel
Exporting an Embedded Query

Problem Solvers

XmimGetData

Option & Help Settings

MIM>Options

Options>Configure MIM Connection
Options>Preferences

Help>About MIM Excel Add-In
Help>Goto MIM Excel Website

		Next
		Getting Started