The Trade Log displays reports for daily executions including those completed during after-hours trading.
To see trades
Click the Trade Log icon on the trading toolbar, or from the Account menu select Trade Log.
Trades Tab
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
Right-click in any column heading and select Layout.
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).
To email trades
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.
Right-click the trades or group of trades and select Email trades.
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.
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:
Click the Trade Log icon on the Trading toolbar to open the Trades window.
On the File menu, select Export Today's (or Previous Day's) Reports.
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).
In the Symbol dropdown choose Underlying, Local Symbol or both.
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.
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.
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
Open MS Excel and click File > Open.
In the Files of type dropdown, select All Files (*.*).
Find the location of the .txt executions file you want to open.
In the Text Import Wizard, use Delimited as the file type and click Next.
Select Semicolon as the delimiter and click Next.
Leave the column data format as General and click Finish.
