Enter the symbol NG, then press Enter. Verify that Close is selected for the Column. Change the Units to BBL, so you will be comparing the same units of measure as the Crude Oil Light Sweet Futures (CL).

Add a new row by selecting the Add Row button. Then, enter the symbol CL and press Enter. Verify that Close is selected for the Column.

For the start date, uncheck Relative and enter the date 06/01/2001.

For the end date, uncheck Today and enter the date 09/30/2003.

In the Worksheet Options pane, uncheck Skip all NaN, and then from the Missing Data NaNs pull-down, select Fill Blank. This choice will fill all missing data with a blank. This option is very useful when working in Excel with formulas where the results are calculated values from the query results.

Select the Table button. The first time you select the Table button, MIMICExcel displays the Embed Query window, and asks you to save and embed your query:

Enter a name for your query in the Name field and a description for the query in the Description field. Leave the Location field for now, but note that you can change the location by selecting the Browse button to the right of this field. Next, select OK. The Embed Query and MIMICExcel windows close, and the results of the query appear in your Excel spreadsheet:

In MIMIC, table data is displayed in the Table window. In MIMICExcel, table data is displayed in your Excel spreadsheet.

You can open MIMICExcel again to view your query by selecting the Enter MIMIC button. You can also run the query again to update the data in your spreadsheet by selecting the Refresh MIMIC Queries button or by selecting MIMIC>Refresh MIMIC Queries from the Excel menu bar:

Now, save your Excel spreadsheet. From the Excel menu bar, select File>Save. Create a name for your spreadsheet and save it to your Desktop. Your spreadsheet will be saved with an Excel .xls file extension.

If you do not save your Excel spreadsheet, you will lose the data in your spreadsheet as well as any queries you have created in MIMICExcel.

Highlight the contents of the spreadsheet, right-click and select Clear Contents.

Next, put your cursor in the cell where you want the data to display. For this example, select cell A:1.

To narrow the date range, turn on the Advanced Refresh Mode option by selecting MIMIC>Advanced Refresh Mode from the Excel menu bar. Then, select the Refresh MIMIC Queries button or select MIMIC> Refresh MIMIC Queries from the menu bar. Enter a start and end date of 10/10/2001 and 10/22/2001. Select Active Worksheet Only, then select OK to continue.

The following shows the results of the date range:

Save your Excel spreadsheet.

Make sure that you save your Excel spreadsheet before exiting Excel. The next time you open the Excel spreadsheet you will be able to refresh the queries, and when you open MIMICExcel you will be able to see any queries that were created.

Open your Excel spreadsheet.

Within Excel, select the Enter MIMIC button. MIMICExcel opens.

From the MIMICExcel toolbar, select the Query Manager button. The Query Manager window displays with your previously saved query:

Select Edit, and then Cancel on the next pop-up window. MIMICExcel displays the details of the query.

You can only access an embedded query by using the Query Manager. You cannot open a query from the menu bar or from the MIMIC toolbar.

If you make changes to a query, you can save it with a new name, thus creating a new query, or save it with the same query name. If you save it with the same query name, MIMICExcel will ask you to overwrite the query. Each time you create a new embedded query, you must save the Excel spreadsheet.

From the menu bar within MIMICExcel, select File>Save or File>Save As, or select the Save button from the toolbar. The Save window appears:

Enter a name for the query and select Save.

You must save each embedded query as its own LLC worksheet.