Options, Exercises and Expirations

The Option Exercises, Assignments and Expirations section includes any exercise, assignment and expiration activity for stocks, options, futures, futures options and structured products; as well as cash settlement for index options and structured products.

Field Descriptions

The data is grouped by Assignments, Exercises and Expirations, then by currency and then by option contract. Assignments and Exercises also display the underlying for each contract.

Column 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 financial instrument.
FX Rate to Base The conversion rate from asset currency to base currency.
Symbol The option contract and, for Assignments and Exercises, the underlying symbol of the contract.
Symbol The symbol of the contract.
Description The description of the contract.
Conid The conid of the contract.
Security ID The security ID of the contract.
Security ID Type The security ID type of the contract.
CUSIP The CUSIP of the contract.
ISIN The ISIN of the contract.
FIGI The FIGI of the contract.
Underlying Conid The underlying conid of the contract.
Underlying Symbol The underlying symbol of the contract.
Issuer The company that issued the contract. For structured products only.
Date The date of the assignment, exercise or expiration.
Transaction Type Assignment, Exercise or Expiration. Assignment underlying Transaction Types are either Sell (call option) or Buy (put option). Exercise underlying Transaction Types are Sell (put option) or Buy (call option).
Quantity The number of units for the transaction.
Trade Price The transaction price.
Close Price The closing price of the contract.
Proceeds Calculated by multiplying the quantity and the transaction price. The proceeds figure will be negative for buys and positive for sales.
Comm/Tax The total amount of commission and tax for the transaction.
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 P/L Calculated by adding the proceeds of the closing trade plus commissions and then adding the basis.
MTM P/L The difference between the transaction price and closing price multiplied by the quantity.
Trade ID The ID of the trade.


Totals by currency:

  • Total Proceeds
  • Total Comm/Tax
  • Total Realized P/L
  • Total MTM P/L