Trades

The trades section shows all trades, sorted by asset class, then by currency, then by symbol. Realized and MTM profit and loss is shown for all realized (closed) trades. For the purpose of cost basis and realized profit or loss, commissions are netted. For MTM profit or loss, commissions are not netted and are included as a separate line in the MTM Performance Summary in Base section.

Field Description
Account ID The account number.
Account Alias Account alias, if there is one.
Model Model, if applicable.
Currency The currency denomination.
Asset Class The asset class of the instrument traded.
FX Rate to Base The conversion rate from asset currency to base currency.
Symbol The symbol of the instrument traded.
Description The description of the instrument traded.
Conid The conid of the instrument traded.
ListingExchange The exchange the instrument traded.
UnderlyingConID The underlying ConID of the contract traded.
Security ID The security ID of the instrument traded.
Security ID Type The security ID type of the instrument traded.
CUSIP The CUSIP of the instrument traded.
ISIN The ISIN of the instrument traded.
FIGI The FIGI of the instrument traded.
UnderlyingListingExchange The underlying exchange the contract traded.
Underlying Conid The underlying conid of the contract traded.
Underlying Symbol The underlying symbol of the contract traded.
Issuer The company that issued the contract. For structured products only.
Trade ID The ID of the trade.
Report Date The date of the statement.
Trade Date The date of the execution.
Trade Time The time of the execution.
Settle Date Target The settle date of execution.
Transaction Type The transaction type.
Exchange The exchange where the transaction took place.
Quantity The number of units for the transaction.
Trade Price The transaction price.
Multiplier The multiplier of the contract traded.
Trade Money Trade money is calculated by multiplying the trade price and quantity.
Proceeds Calculated by multiplying the quantity and the transaction price. The proceeds figure will be negative for buys and positive for sales.
Taxes The total amount of tax for the transaction.
IB Commission The total amount of commission for the transaction.
IB Commission Currency The currency denomination of the trade.
Close Price The closing price of the instrument traded.
Open/Close Indicator The indicator denotes if the trade is an opening or closing trade.
Notes/Codes The note/code abbreviation.
Cost Basis The basis of an opening trade is the inverse of proceeds plus commission and tax amount. For closing trades, the basis is the basis of the opening trade.
Realized PNL Realized P/L can be calculated by the proceeds of the closing trade plus commissions and then adding the basis.
MTM PNL The difference between the transaction price and closing price multiplied by the quantity.
Strike The strike price of the contract if applicable.
Expiry The expiration of the contract if applicable.
Put/Call Put or call.
Principal Adjustment Factor The IB calculated principal adjustment for Treasury Inflation-Protected Securities (TIPS).
Buy/Sell Buy or sell.
IB Order ID The IB order ID.
IB Execution ID The IB execution ID.
Brokerage Order ID The Brokerage order ID. Available on daily (single-day) activity flex queries only.
Order Reference The order reference number as defined by the user on the order ticket. Available on daily (single-day) activity flex queries only.
Volatility Order Link The volatility order link. Available on daily (single-day) activity flex queries only.
Order Placement Time The time at which the order was submitted.
Clearing Firm ID The clearing firm ID.
Exchange Order ID The exchange order ID.
External Execution ID The external execution ID.
Order Time The order time of the transaction.
Open Date Time The date and time of the initial trade.
Holding Period Date Time (Wash Sales) If wash sale, then the holding period date and time will display.
When Realized (Wash Sales) The date of the disallowed loss.
When Reopened (Wash Sales) The date when the position was re-opened.
Original Trade Price The original trade price that was cancelled.
Original Trade Date The original trade date that was cancelled.
Original Trade ID The original trade ID that was cancelled.
Original Order ID The original order ID that was cancelled.
Clearing Firm ID The original clearing firm ID.
Level of Detail Executions, orders or closed lots.
Change in Price The change in price from the current and cancelled trade.
Change in Quantity The change in quantity from the current and cancelled trade.
Net Cash Net cash is calculated by adding the proceeds plus tax plus commissions.
Order Type The order type used during the trade.
Trader ID Trader ID is an alias that identifies the person who executed a trade without revealing his or her username. A prefix of "M" indicates a username associated with the Master account. A prefix of "C" indicates a username associated with a client or sub account.
Is API Order Indicates if the order was submitted by the IB TWS API.
Commodity Commodity type.
Delivery Physical delivery type.
Weight Weight of delivery.
Fineness Fineness of commodity.
Serial Number Serial number of commodity.

 

Level of Detail

As part of setting up the Trades section for your Activity Flex Query, you select one or more Levels of Detail for trade data in this section from among the following choices:

  • Symbol Summary
  • Executions
  • Orders
  • Asset Class
  • Closed Lots
  • Wash Sales