This problem will show how to create a query within MIMICExcel, save or embed the query, and display the results in an Excel spreadsheet. For this exercise, you can show the Close of NG (Natural Gas Futures) and CL (Crude Oil, Light Sweet Futures) from June 1 to September 30 for the last two years. You want the results of this embedded query to appear in the Excel spreadsheet in cell A:1 (default location).

In MIMICExcel, queries that you save are referred to as embedded queries. This means that your queries are available within MIMICExcel and the query results can be refreshed or updated, with the results tabled to your Excel spreadsheet.