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