MIM Excel Add-in Tour:
Get Records Function
 

Next Previous MIM Excel Add-in Main Menu

Get Records Function

The Get Records function is a fast method for fetching and analyzing data. This function takes the data that is entered on the spreadsheet and populates the relation, column, date and time fields in the program.

Problem

Look at the Close, Open and Volume for 3M (MMM), IBM and General Motors (GM) for January 1, 2001 through February 1, 2001 between 9 a.m. and 5 p.m.

Step by Step Solution
 Enter relation data on any row of the spreadsheet. On the next row enter the column data. The following row is reserved for the date fields in the first two columns and the time fields in the next two columns. The data in the spreadsheet must be aligned in a contiguous manner so that all the data will be selected. 

After entering the data in the spreadsheet you will select the cell containing the first relation name entry, then you will select "Get Records" from the menu bar. All the data entered will automatically populate the corresponding fields in the display box.

  1. Type in "MMM", "IBM" and "GM" in the first row. Type "Close", "Open" and "Volume" in the second row. Enter the dates and times in the third row.
  2. Select the first relation entry which is cell A:1 for this example.
  3. Select "Get Records" from the MIM menu.

    4. Continue to the next step.