|
Insert Historical Quotes
- Open an Excel spreadsheet.
- Click the History icon from the ExcelTools toolbar. (If you have not saved your credentials, you will be asked to log in.)
Result: The Insert History dialog box appears.
- Select symbols to appear on the query. There are three ways to do this:
- When you know the specific symbology, type directly into the symbol field at the top right of the dialog box, pressing ENTER when done. View detailed information on symbology.
Examples:
- Enter /GCL - front month for Globex NYMEX Crude Oil
- Enter /CL[0] OR /CL<0> for NYMEX Crude Oil Day session - Front Month
- 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
B. SEARCH: Enter a phrase to search for in the field marked "Search" at the top left of the dialog box. View detailed instructions for using Search.
C. Use the Symbol Tree to navigate through the exchanges and categories to find the desired symbol. View detailed instructions for using the Symbol Tree.
- For any symbol, you may change the Unit of Measure or Currency. View detailed instructions for performing unit and currency conversions.
- Select the data fields you wish to include on the query.
- To select more fields, click "Add", then click on the data field(s) you want from the Field Selector (sorted alphabetically).
- To remove a selected field, hover over the field and the click the "X". (This places the field back into the Field Selector.)
- By default, the symbols will be displayed in the spreadsheet from left to right in the order in which they are entered into the symbol field grid. You can drag/drop the symbols to change the order in which they appear:

NOTE: The Data Fields area "remembers" the last set of fields you selected for a query and will display those fields by default.
- The combo box at the bottom of the dialog is used to set the time frequency and amount of the historical data to extract. It also allows you to show or hide today's data (typically used in a Static query). View detailed instructions for setting the time series.

- Optionally choose additional display settings by clicking the Preferences link. View detailed information about the Historical Preferences.
- When done, click OK.
|