contents.gifindex.gif

Find Symbols Dialog

When the Find button is clicked on the Add Symbols dialog, the Find Symbols dialog is displayed. From this dialog symbols may be found for stocks, stock options and futures root symbols from a database of over 9700 stocks and options and more than 500 futures contracts. After a search has been made a selection of matches may then be added to the list of base symbols on the Add Symbols dialog.

utility00000012.gif

Defining a Search

Three basic inputs are necessary to define a search of the database they are defined as follows:

Type determines whether the database of futures contracts or the database of stocks and options are to be searched.

Criteria determines whether the Search Text is the contract symbol or contract description.

Search Text is the actual text to find in the database.

Executing a Search

Once a search has been defined, the search may be executed by merely pressing the Search button. The progress of the search is displayed on the status bar of the Excel window and the results of the search are displayed in the Items Found text box of the dialog. If the Search Text was not found in the database then the search results are displayed as #NOT FOUND.

Selecting Symbols to Add

To add the results of the search to the list of base symbols on the Add Symbols dialog simply select the items in the list box that you want and then press the Add button. Any symbols that are already on the list will not be added again.

Related Help Topics

Symbol Wizard

Symbols Dialog

Add Symbols Dialog

Qualifiers Dialog

Format Dialog

Modifying a Table or Matrix