This allows the user to modify data requests that have been previously setup with MIM>Add Data. There will be a list of items, assuming requests have been setup previously.
We will continue with the merge example. We just finished showing how to change the date field to a number field. Now, we will edit the data so that the data is not merged but displays in a new target cell. (We are not merging the data as the date fields do not match.)
Do the following to change the HO Volume data request so that the data is not merged.
Select Edit from the MIM menu.
Select HO Volume Sheet1!$B$1 from the Edit display list, then select the Edit button.
From the Recently used Data Item list, select HO Volume and select Next>>.
Do the following to change the destination on the Excel spreadsheet for the HO Volume data:
Select the Next>> button until you get to the destination dialog.
Uncheck the Merge Data and Time columns into a single column for adjacent data requests box. Select cell C:1. The CL Volume is in columns A and B. The data for HO Volume will be in columns C and D.
After editing the HO Volume data, close the Edit dialog by selecting the Close button.
From the MIM menu, run Refresh Data. The data displays showing the CL Volume for one year and the HO Volume for one month.
This concludes the Edit Data lesson.
It might be interesting to access the daily closing price for the natural gas contract for the last 200 values available in the database. Using the Excel Add-in, let's Add Data for the close of NG for the last 200 days of data.
Open the Excel program. From the menu bar, select MIM>Add Data.
The next step is to select Search Symbols and locate the NG symbol.
Enter
ng*and select Start Search.
Select NG from the list and select Next>>.
Select NG from the left-hand column and Close from the right-hand column. Select Next>>.
From the Get data from field, select the last 200 days. Select Next>>.
The data is setup to display in the first cell of the spreadsheet. Select Next>>.
Choose the Futures Contract Options. For this example, keep the defaults. Select Finish.
From the MIM menu, select Refresh Data.
The query runs and displays the data, i.e., the closing amounts for the NG future for the last 200 days.
This concludes the Working Example. Next, see how to use the MIM Queries/Run All Queries option.