Trade Log

Instructions

The Trade Log displays reports for daily executions including those completed during after-hours trading.

To See Trades

  1. For Mosaic, select the New Window button followed by searching for Trade History

    For Classic TWS, select the Account button across the top tool bar followed by Trade History

  2. The Trades window has two tabs: Trades and Summary. Advisors and other multi-client account holders have the option to see trade activity for All accounts, an individual account (including the Master) or any user-defined Account Group.

    The Trade Log in TWS.

    1 - Advisors can select an account to filter trade reports

    2 - Combos are expandable to show individual legs by clicking the "+" icon to the left of the trade.

To Add or Remove Columns from the Trades Tab

  1. Right-click in any column heading and select Layout.

  2. Check the columns you want to include; uncheck columns you want to hide.

Right-Click Features

Column Name Description

Action

The action, either Bought (Bot) or Sold (SLD)

Quantity

The number of units in the trade.

Underlying

The underlying symbol.

Comb

If checked, identifies the trade as a combo trade. Use the “+” sign to expand the combo and view individual legs.

Description

The contract description.

Price

The current market price per unit.

Currency

The currency in which the position is held.

Exchange

The exchange that executed the order.

Date

The execution date.

Time

The execution time.

Order ID

The order ID.

Order Ref

The order reference number as defined by the user on the Order Ticket. For basket orders, this field contains the name of the basket to which the order belongs.

Commissions

Commission charged on the trade.

VWAP Time

For VWAP orders, the time at which the order executed.

Comment

Displays comments relative to the order.

Account

Identifies the beneficial account number.

Confirm

Valid only for Linkage clients.

Submitter

Identifies the order submitter.

Yield

The yield-to-worst. This is the lower of yield to maturity and yields to all calls. The yield is only shown if it is offered on the exchange.

 

The text along the bottom of the window describes the sort order of fields on the Trades tab.

Email Trade Reports

You can select a group of trades and email them from your default email client. Customize the mail settings to include specific fields and use different delimiters (these separate the data in the list and may need to be changed based on how the recipient intends to use the list).

  1. From the Trades tab, select the trades you would like to email.

    • To select a group of contiguous trades, click on the first trade, hold down the Shift key and click on the last trade in the group.

    • To select a group of non-contiguous trades, press and hold the Ctrl key while you click on the desired trade lines.

  2. Right-click the trades or group of trades and select Email trades.

    The Email Trade Reports menu in TWS.

  3. In the configuration box, choose the column layout and other settings for the email.

    • Default Columns shows the columns that are on your trades window.

    • Extended Form includes all available columns.

    • Custom Columns allows you to select the columns to include in the email.

    The Email Trade Reports menu in TWS.

  4. Enter the email address(es) of the recipient(s) and send your trade reports.

Export Trade Reports

You can export today's and previous days' execution reports to a file which you can then view using MS Excel or another outside application.

  1. From within the Trade Log, on the File menu, select Export Today's (or Previous Day's) Reports.

    The Export Trade Reports menu in TWS.

  2. If applicable, select the day's report and click OK.

    • Default columns will include basic trade report columns in the exported version.

    • Check Extended Form to include the type, expiry, strike, right and premium currency fields on the exported report.

    • Check ID to include the ID field on the report

    • Check Add Volatility Link to include the volatility calculation (for Volatility orders).

    The Export Trade Reports configuration in TWS.

  3. In the Symbol drop-down choose Underlying, Local Symbol or both.

  4. If desired, changed the field delimiter (which separates each entry) from a comma to something else. Most users will not need to touch this field.

  5. In the Filename field, enter the location and filename you want to assign to the report. Note that the report will be saved as a text (.txt) file.

  6. Click OK to save the report to an outside directory.

You can open your exported report in a spreadsheet by performing a few simple steps.

  1. Open MS Excel and click File > Open.

  2. In the Files of type dropdown, select All Files (*.*).

  3. Find the location of the .txt executions file you want to open.

  4. In the Text Import Wizard, use Delimited as the file type and click Next.

  5. Select Semicolon as the delimiter and click Next.

  6. Leave the column data format as General and click Finish.

 

Additional Resources

Learn About Trader Workstation at IBKR Campus

Visit the Trader Workstation Website