Log in

8 Execution Report

The Execution Report message is used to:

  1. Confirm the receipt of an order
  2. Confirm changes to an existing order, i.e. accept cancel and replace requests
  3. Relay order status information
  4. Relay fill information on working orders
  5. Relay fill information on tradeable or restricted tradeable quotes
  6. Reject orders
  7. Report the post-trade fee calculations associated with a trade

Execution Reports do not replace end-of-day confirmations.

Separate Execution Reports are sent for each order in a New Order List <35=E>.

An Execution Report communicates the current state of the order as understood by the broker, using OrdStatus (39), and the purpose of the message, using ExecType (150).

In an Execution Report, OrdStatus (39) is used to convey the current state of the order. If an order simultaneously exists in more than one order state, the value with highest precedence is the value that is used in the OrdStatus (39) field. The order statuses are as follows, from highest to lowest precedence:

PrecedenceOrdStatusDescription
11Pending CancelOrder with an Order Cancel Request pending, used to confirm receipt of an Order Cancel Request. Does not indicate that the order has been canceled.
10Pending ReplaceOrder with an Order Cancel/Replace Request pending, used to confirm receipt of an Order Cancel/Replace Request. Does not indicate that the order has been replaced.
9Done for DayOrder not filled, or partially filled; no further executions possible for the trading day
8CalculatedOrder has been completed for the day, either filled or done for day. Commission or currency settlement details have been calculated and reported in this execution message
7FilledOrder completely filled, no remaining quantity
6StoppedOrder has been stopped at the exchange. Used when guaranteeing or protecting a price and quantity
5SuspendedOrder has been placed in suspended state at the request of the client
4CanceledCanceled order with or without executions
4ExpiredOrder has been canceled in broker's system due to time-in-force instructions. The only exceptions are fill-or-kill and immediate-or-cancel orders that have Canceled as their terminal order state
3Partially FilledOutstanding order with executions and remaining quantity
2NewOutstanding order with no executions
2RejectedOrder has been rejected by the sell-side. Note: an order can be rejected subsequent to order acknowledgment, i.e. an order can pass from New to Rejected status
2Pending NewOrder has been received by the sell-side's system but not yet accepted for execution. An execution message with this status will only be sent in response to a Status Request message
1Accepted for biddingOrder has been received and is being evaluated for pricing. It is anticipated that this status will only be used with the “Disclosed” BidType List Order Trading model

ExecType (150) is used to identify the purpose of the Execution Report. To transmit a change in OrdStatus (39) for an order, the broker (sell-side) should send an Execution Report with the new OrdStatus (39) value in both the ExecType (150) and the OrdStatus (39) fields to signify this message is changing the state of the order. The only exception to this rule is that when rejecting a cancel or cancel/replace request, the Order Cancel Reject <35=9> message is used both to reject the request and to communicate the current OrdStatus (39). An ExecType (150) of Pending Cancel or Pending Replace is used to indicate that a cancel or cancel/replace request is being processed. An ExecType (150) of Canceled or Replace is used to indicate that the cancel or cancel/replace request has been successfully processed.

Execution information (e.g. new partial fill or complete fill) should not be communicated in the same report as one which communicates other state changes (such as pending cancel, pending replace, canceled, replaced, accepted, done for day etc).

Any fills which occur while an order is pending and waiting to reach a new state must contain the original order parameters, prior to state change request, i.e. ClOrdID (11), OrderQty (38), Price (44), etc. These fills will cause the CumQty (14) and AvgPx (6) to be updated. An order cannot be considered replaced until it has been explicitly accepted and confirmed to have been replaced via an Execution Report with ExecType (150) = 'Replace', at which time the effect of the replacement (new quantity, price, etc.) will be seen.

Requests to cancel or cancel/replace an order are only acted upon when there is an outstanding order quantity. A request to replace the OrderQty (38) to a level lower than the CumQty (14) will be interpreted by the broker as a request to stop executing the order. A request to change the price of a filled order will be rejected.

The OrderQty (38), CumQty (14), LeavesQty (151), and AvgPx (6) fields should be calculated to reflect the cumulative result of all versions of an order. For example, if partially filled order A were replaced by order B, the OrderQty (38), CumQty (14), LeavesQty (151), and AvgPx (6) on order B's fills should represent the cumulative result of order A plus those on order B.

The general rule is: OrderQty (38) = CumQty (14) + LeavesQty (151).

There can be exceptions to this rule when ExecType (150) or OrdStatus (39) are Canceled, DoneForDay, Expired, Calculated, or Rejected. In which case, the order is no longer active and LeavesQty (151) could be 0.

Execution Reports communicate new fills with ExecType (150) = Trade. Execution Reports with ExecType (150) = Trade Cancel or Trade Correct are used to cancel or correct a previously modified execution report as follows:

  • The ExecType (150) of Trade Cancel applies at the execution level and is used to cancel an execution which has been reported in error. The canceled execution will be identified in the ExecRefID (19) field. Note: ExecType (150) of Trade Cancel should not be used to cancel a previous Execution Report with ExecType (150) of Trade Cancel (e.g. cannot cancel a cancel).
  • The ExecType (150) of Trade Correct applies at the execution level and is used to modify an incorrectly reported fill. The incorrect execution will be identified in the ExecRefID (19) field. If a single execution is corrected more than once, ExecRefID (19) should refer to the ExecID (17) of the last corrected Execution Report (same convention as ClOrdID (11) and OrigClOrdID (41)). To correct an Execution Report which was previously canceled, an Execution Report with ExecType (150)=Trade should be sent (e.g. cannot send ExecType (150)=Trade Correct for an Execution Report with ExecType (150)=Trade Cancel). Note: Data reported in the CumQty (14), LeavesQty (151), and AvgPx (6) fields represent the status of the order as of the time of the correction, not as of the time of the originally reported execution.

An ExecType (150) of Order Status indicates that the execution messages contains no new information, only summary information regarding order status. It is used, for example, in response to an Order Status request message

See "Order State Change Matrices" for examples of key state changes, processing of cancel and cancel/replace requests, and for execution cancel/corrects.

An Execution Report with ExecType (150) = Restated represents an Execution Report sent by the sellside communicating a change in the order or a restatement of the order's parameters without an electronic request from the customer. ExecRestatementReason (378) must be set. This is used for GT orders and corporate actions (see below), changes communicated verbally to the sellside either due to normal business practices or as an emergency measure when electronic systems are not available, repricing of orders by the sellside (such as making Sell Short orders compliant with uptick / downtick rules), or other reasons (Broker option). ExecRestatementReason (378) can also be used to communicate unsolicited cancels.

The field ClOrdID (11) is provided for institutions or buy-side brokers or intermediaries to affix an identification number to an order to coincide with internal systems. The OrderID (37) field is populated with the sell-side broker-generated order number (or fund manager-generated order number for CIVs). Unlike ClOrdID (11) / OrigClOrdID (41) which requires a chaining through Cancel/Replaces and Cancels, OrderID (37) and SecondaryOrderID (198) are not required to change through changes to an order.

The underlying business assumption of orders that can trade over multiple days, such as GTC and Good Till Date orders expiring on a future trading date (henceforth referred to as GT orders) is that a GT order that is not fully executed and has not been canceled and has not expired on a given day remains good for the broker to execute the following day. Note that the concept of "day" is determined by the market convention, which will be security specific. At the end of each trading day, once the order is no longer subject to execution, the broker may optionally send an Execution Report with ExecType (150)='3' (Done for Day). When the ExpireDate (432) or ExpireTime (126) of a Good Till Date order is reached, or a GTC order reaches a maximum age, the order is considered expired and the broker may optionally send an Execution Report with ExecType (150) and OrdStatus (39)=Expired (C).

In handling GT orders, the OrderQty (38), CumQty (14) and AvgPx (6) fields will represent the entirety of the order over all days. The fields DayOrderQty (424), DayCumQty (425), and DayAvgPx (426) can be used on days following the day of the first trade on a GT order. Prior to the start of business each day, for all GT orders that have partial fills on previous days, DayCumQty (425) and DayAvgPx (426) are set to zero, and DayOrderQty (424) becomes the LeavesQty (151). The following relationship holds: DayOrderQty (424) = OrderQty (38) - (CumQty (14) - DayCumQty (425)). Since (CumQty (14) - DayCumQty (425)) represents the volume traded on all previous days, DayOrderQty (424) = OrderQty (38) - Volume traded on all previous days. Note that when changing the quantity of an order, both OrderQty (38) and DayOrderQty (424) will change. Requests to change or cancel an order will be made in terms of the total quantity for the order, not the quantity open today. For example, on an order where OrderQty (38)=10000 and 2000 shares trade during the previous days, a request to change OrderQty (38) to 15000 will mean that 13000 shares will be open. See "Order State Change Matrices" for examples of canceling and changing GT orders partially filled on previous days.

A Cancel on an execution (trade bust, ExecType (150) = Trade Cancel) happening the same day of the trade will result in CumQty (14) and DayCumQty (425) each decreasing by the quantity busted, and LeavesQty (151) increasing by the quantity busted. OrderQty (38) and DayOrderQty (424) will remain unchanged. If the business rules allow for a trade bust to be reported on a later date than the trade being busted, the OrderQty (38) and DayCumQty (425) will remain unchanged, the LeavesQty (151) and DayOrderQty (424) will increase by the quantity busted, and the CumQty (14) will decrease by the quantity busted.

If bilaterally agreed between counterparties, a broker may wish to transmit a list of all open GT orders, permitting reconciliation of the open orders. Typically this transmission may occur at the end of the trading day or at the start of the following trading day. There is no expected response to such retransmission; in the event of a reconciliation problem this should be resolved manually or via the DK message. Assuming no corporate actions have occurred, the broker will send an Execution Report with ExecType (150) = Restated (D) and ExecRestatementReason (378) = GT renewal / restatement (no corporate action) (1) for each open GT order. These Execution Reports may have DayCumQty (425) and DayAvgPx (426) restated to zero, and DayOrderQty (424) restated to LeavesQty (151) if the transmission occurs at the start of the following business day. The broker has the option of changing the OrderID (37) and SecondaryOrderID (198) fields, or leaving them unchanged. If they are changed, then the buy-side should use these new ID fields when sending Order Cancel Request <35=F>, Order Cancel/Replace Request <35=G>, and Order Status Request <35=H> messages.

In the case of a corporate action resulting in the adjustment of an open GT order, the broker will send an Execution Report with ExecType (150) = Restated (D) and ExecRestatementReason (378) = GT Corporate action (0) with the order's state after the corporate action adjustment. In the case of stock splits, OrderQty (38), CumQty (14), AvgPx (6), and LeavesQty (151) will be adjusted to reflect the order's state in terms of current quantity (e.g. shares), not pre-split quantity (e.g. shares). See "Order State Change Matrices" for examples of GT order restatement with and without a corporate action.

CIV orders to be executed by the fund manager do not use the TimeInForce (59) field and only a subset of OrdStatus (39) values are expected to be used. See VOLUME 7 - "PRODUCT: COLLECTIVE INVESTMENT VEHICLES" for the CIV-specific OrdStatus (39) values.

The Execution Report message is also used for multileg instrument. See "Use of the Execution Report for Multileg Instruments" for multileg-specific details.

Structure

TagNameTypeRequiredDescription
Component
Required
37String
Required
OrderID is required to be unique for each chain of orders
198StringCan be used to provide order id used by exchange or executing system
526String
527String
11StringRequired for executions against electronically submitted orders which were assigned an ID by the institution or intermediary. Not required for orders manually entered by the broker or fund manager (for CIV orders)
41StringConditionally required for response to an electronic Cancel or Cancel/Replace request (ExecType=PendingCancel, Replace, or Canceled). ClOrdID of the previous accepted order (NOT the initial order of the day) when canceling or replacing an order
583String
693StringRequired if responding to a QuoteResponse message. Echo back the Initiator’s value specified in the message
790StringRequired if responding to and if provided on the Order Status Request message. Echo back the value provided by the requester
584StringRequired if responding to an Order Mass Status Request. Echo back the value provided by the requester
911IntCan be used when responding to an Order Mass Status Request to identify the total number of Execution Reports which will be returned
912BooleanCan be used when responding to an Order Mass Status Request to indicate that this is the last Execution Reports which will be returned as a result of the request
ComponentThe set of "Parties" (firm identification) fields defined in "Common Components of Application Messages"
229LocalMktDate
ComponentNumber of ContraBrokers repeating group instances
66StringRequired for executions against orders which were submitted as part of a list
548StringCrossID for the replacement order
551StringMust match original cross order. Same order chaining mechanism as ClOrdID/OrigClOrdID with single order Cancel/Replace
549Int Enum
17String
Required
Unique identifier of execution message as assigned by sell-side (broker, exchange, ECN) (will be 0 (zero) forExecType=I (Order Status))
19StringRequired for Trade Cancel and Trade Correct ExecType messages
150Char Enum
Required
Describes the purpose of the execution report
39Char Enum
Required
Describes the current state of a CHAIN of orders, same scope as OrderQty, CumQty, LeavesQty, and AvgPx
636Boolean EnumFor optional use with OrdStatus = 0 (New)
103Int EnumFor optional use with ExecType = 8 (Rejected)
378Int EnumRequired for ExecType = D (Restated)
1StringRequired for executions against electronically submitted orders which were assigned an account by the institution or intermediary
660Int Enum
581Int EnumSpecifies type of account
589Char Enum
590Char Enum
591Char Enum
63Char Enum
64LocalMktDateTakes precedence over SettlType value and conditionally required/omitted for specific SettlType values
544Char Enum
635String Enum
Component
Required
The set of "Instrument" (symbology) fields defined in "Common Components of Application Messages"
ComponentThe set of "FinancingDetails" (symbology) fields defined in "Common Components of Application Messages"
ComponentNumber of underlyings
54Char Enum
Required
Component
854Int Enum
ComponentThe set of "OrderQtyData" fields defined in "Common Components of Application Messages" **Note: OrderQty field is required for Single Instrument Orders unless rejecting or acknowledging an order for a CashOrderQty or PercentOrder
40Char Enum
423Int Enum
44PriceRequired if specified on the order
99PriceRequired if specified on the order
ComponentThe set of "PegInstruction" fields defined in "Common Components of Application Messages"
ComponentThe set of "DiscretionInstruction" fields defined in "Common Components of Application Messages"
839PriceThe current price the order is pegged at
845PriceThe current discretionary price of the order
847Int EnumThe target strategy of the order
848StringFor further specification of the TargetStrategy
849PercentageMandatory for a TargetStrategy=Participate order and specifies the target participation rate. For other order types optionally specifies a volume limit (i.e. do not be more than this percent of the market volume)
850FloatFor communication of the performance of the order versus the target strategy
15Currency
376String
377Boolean Enum
59Char EnumIf absent, DAY is used
168UTCTimestampTime specified on the order at which the order should be considered valid
432LocalMktDateConditionally required if TimeInForce = GTD and ExpireTime is not specified
126UTCTimestampConditionally required if TimeInForce = GTD and ExpireDate is not specified
18String EnumCan contain multiple instructions, space delimited
528Char Enum
529String Enum
582Int Enum
32QuantityQuantity (e.g. shares) bought/sold on this (last) fill. Required if ExecType = Trade or Trade Correct. If ExecType=Stopped, represents the quantity stopped/guaranteed/protected for
652Quantity
31PricePrice of this (last) fill. Required if ExecType = Trade or Trade Correct. Should represent the "all-in" (LastSpotRate + LastForwardPoints) rate for F/X orders. ). If ExecType=Stopped, represents the price stopped/guaranteed/protected at
651Price
669PriceLast price expressed in percent-of-par. Conditionally required for Fixed Income trades when LastPx is expressed in Yield, Spread, Discount or any other price type that is not percent-of-par
194PriceApplicable for F/X orders
195PriceOffsetApplicable for F/X orders
30ExchangeIf ExecType = Trade (F), indicates the market where the trade was executed. If ExecType = New (0), indicates the market where the order was routed
336String
625String
943String
29Char Enum
151Quantity
Required
Quantity open for further execution. If the OrdStatus is Canceled, DoneForTheDay, Expired, Calculated, or Rejected (in which case the order is no longer active) then LeavesQty could be 0, otherwise LeavesQty = OrderQty - CumQty
14Quantity
Required
Currently executed quantity for chain of orders
6Price
Required
424QuantityFor GT orders on days following the day of the first trade
425QuantityFor GT orders on days following the day of the first trade
426PriceFor GT orders on days following the day of the first trade
427Int EnumStates whether executions are booked out or accumulated on a partially filled GT order
75LocalMktDateUsed when reporting other than current day trades
60UTCTimestampTime the transaction represented by this ExecutionReport occurred
113Boolean Enum
ComponentThe set of "CommissionData" fields defined in "Common Components of Application Messages" Note: On a fill/partial fill messages, it represents value for that fill/partial fill. On ExecType=Calculated, it represents cumulative value for the order. Monetary commission values are expressed in the currency reflected by the Currency field
Component
ComponentThe set of "YieldData" (yield-related) fields defined in "Common Components of Application Messages"
381Amount
157Int
230LocalMktDate
158Percentage
159Amount
738AmountFor fixed income products which pay lump-sum interest at maturity
920AmountFor repurchase agreements the accrued interest on termination
921AmountFor repurchase agreements the start (dirty) cash consideration
922AmountFor repurchase agreements the end (dirty) cash consideration
258Boolean Enum
259LocalMktDate
260Price
238Amount
237Amount
118AmountOn a fill/partial fill messages, it represents value for that fill/partial fill, on ExecType=Calculated, it represents cumulative value for the order. Value expressed in the currency reflected by the Currency field
119AmountUsed to report results of forex accommodation trade
120CurrencyUsed to report results of forex accommodation trade
155FloatForeign exchange rate used to compute SettlCurrAmt from Currency to SettlCurrency
156Char EnumWhether the SettlCurrFxRate should be multiplied or divided
21Char Enum
110Quantity
111Quantity
77Char EnumFor use in derivatives omnibus accounting
210Quantity
775Int EnumMethod for booking out this order. Used when notifying a broker that an order to be settled by that broker is to be booked out as an OTC derivative (e.g. CFD or similar). If absent, regular booking is used
58String
354LengthMust be set if EncodedText field is specified and must immediately precede it
355DataEncoded (non-ASCII characters) representation of the Text field in the encoded format specified via the MessageEncoding field
193LocalMktDateCan be used with OrdType = "Forex - Swap" to specify the "value date" for the future portion of an F/X swap
192QuantityCan be used with OrdType = "Forex - Swap" to specify the order quantity for the future portion of an F/X swap
641PriceOffsetCan be used with OrdType = "Forex - Swap" to specify the forward points (added to LastSpotRate) for the future portion of an F/X swap
442Char EnumDefault is a single security if not specified
480Char EnumFor CIV - Optional
481Char Enum
513StringReference to Registration Instructions message for this Order
494StringSupplementary registration information for this Order
483UTCTimestampFor CIV - Optional
515UTCTimestampFor CIV - Optional
484Char EnumFor CIV - Optional
485FloatFor CIV - Optional
638Int Enum
639PriceOffset
851Int EnumApplicable only on OrdStatus of Partial or Filled
ComponentNumber of contract details in this message (number of repeating groups to follow)
ComponentNumber of legs A Multi-leg Execution if present and non-zero
797Boolean
ComponentRequired if any miscellaneous fees are reported. Indicates number of repeating entries. Repeating group. ** Nested Repeating Group follows **
Component
Required