Search Symbols Example

Select Search Symbols from the Excel dialog.

For this example, find the Natural Gas Futures using the Search Symbols feature. In the Search Text box, type ng*, then select Start Search.

Select NG Natural Gas Futures from the list, then select Next>>.

Select NG from the left column, then select Volume from the right column.

Select Next>> from the Excel dialog to continue.

Select the desired date information from the fields.

Select the destination in the Excel Workbook. Click in the cell in the Excel Workbook where you want the data to start. The entry will display in the Excel dialog. Unless merging data, it is a good idea to separate the data columns in the Excel workbook with a blank column.

Choose the Futures Contract Options then select Finish.

Select Refresh Data from the MIM menu bar to display the data.

The data displays with an empty column separating the data columns.

This completes the Search Symbols example.

Go to the next step in the lesson to see an example using the Search Descriptions option.