Help Files
The Insert History Dialog Box
                  

Clicking the History icon will cause the following dialog box to appear:

 

Part of the History Dialog Box

 

 

1

SEARCH: Enter one or more words that describe the symbol or category you want. The more information you enter, the finer the search results will be. View more information about Symbol Search.

2

When you know the specific symbols you want, enter the desired symbols here. Examples:

  • Enter /CLZ11 for December 2011 Light Crude Oil Futures
  • Enter /NGS11 for November 2011 Globex Natural Gas Futures
  • Enter /HO<3> for the (Continuous) 4th Month NYMEX Heating Oil

3

Click the  HOME icon to go back to the start of the Symbol Tree. View more information about Symbol Tree.

4

Click the back arrow to go back one step in the Symbol Tree.

5

Displays any Filters saved in the Symbol Tree Settings (unpermissioned and expired contracts).

Click the Settings icon to change the View (Tree or Slider) or Filters.

6

Click the X to Clear all the selected symbols.

7

The left side displays the results of a SEARCH, or the symbols found by moving through the Symbol Tree.

8

Symbols selected to appear on your query are listed in the right side of the dialog box. The Unit of Measure and Currency is displayed for each symbol, and can be changed by clicking on them.

9

Remove a specific symbol by clicking on it once, then clicking the "X" that displays.

10

Add or delete data fields to display in the spreadsheet. You can also change the order in which they are displayed by dragging and dropping them.

11

Select the time series (Daily, Weekly, Monthly, Contract Monthly, Quarterly, Yearly, Intraday, Seasonal) and either the number of records back or date range.

12

Show or Hide today's data.

13

Additional display settings (Header, Footer and Data Options) are chosen in the Preferences area of the dialog box.

 

Related Topics

History Query
Symbology
Symbol Search
Symbol Tree