The Trade Log

Introduction

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

openTradelog916.jpg

 

To see trades

Trades Tab

advisorTrades916.gif

 

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 account group “Global Fund” is selected in the image above.

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.

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 customers.

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).

emailTradesAll908.gif

 

To email trades

  1. From the Trades tab, select the trades you would like to email.
  2. Right-click the trades or group of trades and select Email trades.
  3. In the configuration box, choose the column layout and other settings for the email.
  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.

To export trade reports

From within Classic TWS:

  1. Click the Trade Log icon on the Trading toolbar to open the Trades window.
  2. On the File menu, select Export Today's (or Previous Day's) Reports.
  3. If applicable, select the day's report and click OK.

  4. In the Symbol dropdown choose Underlying, Local Symbol or both.
  5. 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.
  6. 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.

  7. 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.

To open your trade report in Excel

  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.
wizard.gif