Once you have data for quotes, history, or charts, you can change the symbol that is currently in the display to a different one.

  • Double-click on the symbol and change it to a new symbol or expression.
  • The entire display will change to the data for that symbol.

Ex:  In the spreadsheet below we have a history view of the current corn contract:

Excel Add 28

Double-click in the cell that contains the symbol (@c@1) and change it to a different symbol. (we changed it to QCL@1)

Excel Add 29

The display changed to the history for the current crude contract.

Category: ExcelTags: