You are here: CME Direct Excel Integration > Excel Integration > Dragging Data

/*]]>*/

Dragging Data

With the Excel Add-in installed and Excel enabled, you have the option of adding data to Excel using functions or dragging data from a Trading Grid into Excel. Dragging data automatically generates the correct formulae to subscribe to market data.

Note: This functionality applies to Exchange and Options Trading Grids.

 You can drag a single Trading Grid cell or a group of cells.

Note: You cannot drag columns that are not supported by the CMED.MD function.

Single Cell

For Traders and Brokers, this function eliminates the need to remember the syntax for the CMED.MD function.

Note: If you select a cell that is not supported in the CMED.MD function, Excel will display an error.

The following rules apply to dragging a single cell.

  • You can only drag formulas to Excel if you have the Excel API role.
  • Supported columns are those for which the CMED.MD function can display the equivalent market data.
  • Dragging (excluding group headers and column headers) from a supported column on a Trading Grid places a formula in Excel for the CMED.MD function with the corresponding contract code, depth, and market data field name.
  • The Last Trade Time cell is formatted as a time when dragged into Excel.

 

  1. To drag Trading Grid cell into Excel:
  2. With Excel enabled, click and drag a cell from an Exchange Trading Grid into Excel.
  3. The data from the Trading Grid appears in the Excel cell, and the order's function formula appears in the fx field.

Group of Cells

For Traders and Brokers, this function eliminates the need to enter multiple CMED.MD functions and reflects how you would manually set up the data. The following rules apply to dragging a group of cells:

 

  1. To drag a group of cells into Excel:
  2. With Excel enabled, click a product header row and drag from an Exchange or Options Trading Grid into Excel.
  3. The data from the Trading Grid appears in Excel and is formatted accordingly.

Exchange Trading Grid

Note: If you change something in the Order Book, that change is reflected automatically in Excel.

Options Trading Grid

 


Copyright CME Group. All rights reserved.