Try TT Now

You can perform these procedures:

Tip

  • To quickly identify cells with OLE Links, assign a specific color to the cell using the Formatting option in Using the Autotrader Context Menu.
  • To automatically open Excel with a saved workspace, create links from Autotrader to Excel. If you only have links from Market Grid to Excel, the links save but do not automatically open Excel with a workspace.

Linking Excel spreadsheets to Autotrader

To link Excel spreadsheets to Autotrader:

  1. Open the Excel spreadsheet from which you want to link cells to Autotrader.

    Tip: If you opened a new Excel worksheet, save and rename the worksheet before you begin linking cells. X_TRADER uses the worksheet name to associate the link.

  2. Locate your cells in the spreadsheet.
  3. Open Autotrader.
  4. Populate the window with the contracts you want to trade.
  5. In the Excel spreadsheet, right-click the cell that you want to copy into Autotrader.
  6. Click Copy.
  7. In the X_TRADER window, right-click on the cell in which you want to create the Excel link, point to Links, and then click Paste.

    The cell now hosts the OLE link to Excel.

  8. To use these links in the future, on the X_TRADER Control Panel, click File and select Save.

    ...do you want X_Trader to save the external files?

  9. Click Yes.

You successfully linked Excel spreadsheets to Autotrader.

Using Excel Spreadsheets with Direct Order Entry

To use Excel spreadsheets to enter direct orders:

  1. Create a profile.
  2. Assign it a Profile Base Price of Direct Order Entry, and set any other needed trading parameters.
  3. Populate Autotrader with the contract(s) you want to trade.
  4. Assign the Direct Order Entry profile to the contract(s).
  5. Link your program that uses the OLE standard (i.e., Excel spreadsheet) into the cells of the Scratch section.

Tip: If you opened a new Excel worksheet, save and rename the worksheet before you begin linking cells. X_TRADER uses the worksheet name to associate the link.

  1. Make sure that you have a link or formula to generate values for each Scratch section cell (i.e., sBidQty, sBidPrc, sAskPrc, sAskQty).
  2. To use these links in the future, save your workspace.
  3. You can start trading.

You successfully used Excel spreadsheets to enter direct orders.

Using Excel Spreadsheets with Direct Order Entry

To delete OLE links from Autotrader:

  1. In Autotrader, right-click the cell that contains the link you want to delete.
  2. Point to Links and click Delete.

You successfully deleted OLE Links from the Autotrader.

Switching Between Flow and Contracts on the ICE Exchange

You can use Autotrader to trade energy products on the ICE exchange. If you use Autotrader or Excel links, switching between Flow and Contracts can create incorrect equations. If you try to switch between Flow and Contracts while Autotrader is active, a dialog box appears and states:

Warning! Changing this property may impact Excel and Autotrader formulas!

If you click Yes, X_TRADER deactivates Autotrader and removes Autotrader orders from the market.