The Execution Report message is used to:
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:
Precedence | OrdStatus | Description |
---|---|---|
11 | Pending Cancel | Order with an Order Cancel Request pending, used to confirm receipt of an Order Cancel Request. Does not indicate that the order has been canceled. |
10 | Pending Replace | Order 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. |
9 | Done for Day | Order not filled, or partially filled; no further executions possible for the trading day |
8 | Calculated | Order 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 |
7 | Filled | Order completely filled, no remaining quantity |
6 | Stopped | Order has been stopped at the exchange. Used when guaranteeing or protecting a price and quantity |
5 | Suspended | Order has been placed in suspended state at the request of the client |
4 | Canceled | Canceled order with or without executions |
4 | Expired | Order 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 |
3 | Partially Filled | Outstanding order with executions and remaining quantity |
2 | New | Outstanding order with no executions |
2 | Rejected | Order 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 |
2 | Pending New | Order 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 |
1 | Accepted for bidding | Order 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:
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.
Tag | Name | Type | Required | Description |
---|---|---|---|---|
Component | ||||
37 | String | OrderID is required to be unique for each chain of orders | ||
198 | String | Can be used to provide order id used by exchange or executing system | ||
526 | String | |||
527 | String | |||
11 | String | Required 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) | ||
41 | String | Conditionally 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 | ||
583 | String | |||
693 | String | Required if responding to a QuoteResponse message. Echo back the Initiator’s value specified in the message | ||
790 | String | Required if responding to and if provided on the Order Status Request message. Echo back the value provided by the requester | ||
584 | String | Required if responding to an Order Mass Status Request. Echo back the value provided by the requester | ||
911 | Int | Can be used when responding to an Order Mass Status Request to identify the total number of Execution Reports which will be returned | ||
912 | Boolean | Can 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 | ||
Component | The set of "Parties" (firm identification) fields defined in "Common Components of Application Messages" | |||
229 | LocalMktDate | |||
Component | Number of ContraBrokers repeating group instances | |||
66 | String | Required for executions against orders which were submitted as part of a list | ||
548 | String | CrossID for the replacement order | ||
551 | String | Must match original cross order. Same order chaining mechanism as ClOrdID/OrigClOrdID with single order Cancel/Replace | ||
549 | Int Enum | |||
17 | String | Unique identifier of execution message as assigned by sell-side (broker, exchange, ECN) (will be 0 (zero) forExecType=I (Order Status)) | ||
19 | String | Required for Trade Cancel and Trade Correct ExecType messages | ||
150 | Char Enum | Describes the purpose of the execution report | ||
39 | Char Enum | Describes the current state of a CHAIN of orders, same scope as OrderQty, CumQty, LeavesQty, and AvgPx | ||
636 | Boolean Enum | For optional use with OrdStatus = 0 (New) | ||
103 | Int Enum | For optional use with ExecType = 8 (Rejected) | ||
378 | Int Enum | Required for ExecType = D (Restated) | ||
1 | String | Required for executions against electronically submitted orders which were assigned an account by the institution or intermediary | ||
660 | Int Enum | |||
581 | Int Enum | Specifies type of account | ||
589 | Char Enum | |||
590 | Char Enum | |||
591 | Char Enum | |||
63 | Char Enum | |||
64 | LocalMktDate | Takes precedence over SettlType value and conditionally required/omitted for specific SettlType values | ||
544 | Char Enum | |||
635 | String Enum | |||
Component | The set of "Instrument" (symbology) fields defined in "Common Components of Application Messages" | |||
Component | The set of "FinancingDetails" (symbology) fields defined in "Common Components of Application Messages" | |||
Component | Number of underlyings | |||
54 | Char Enum | |||
Component | ||||
854 | Int Enum | |||
Component | The 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 | |||
40 | Char Enum | |||
423 | Int Enum | |||
44 | Price | Required if specified on the order | ||
99 | Price | Required if specified on the order | ||
Component | The set of "PegInstruction" fields defined in "Common Components of Application Messages" | |||
Component | The set of "DiscretionInstruction" fields defined in "Common Components of Application Messages" | |||
839 | Price | The current price the order is pegged at | ||
845 | Price | The current discretionary price of the order | ||
847 | Int Enum | The target strategy of the order | ||
848 | String | For further specification of the TargetStrategy | ||
849 | Percentage | Mandatory 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) | ||
850 | Float | For communication of the performance of the order versus the target strategy | ||
15 | Currency | |||
376 | String | |||
377 | Boolean Enum | |||
59 | Char Enum | If absent, DAY is used | ||
168 | UTCTimestamp | Time specified on the order at which the order should be considered valid | ||
432 | LocalMktDate | Conditionally required if TimeInForce = GTD and ExpireTime is not specified | ||
126 | UTCTimestamp | Conditionally required if TimeInForce = GTD and ExpireDate is not specified | ||
18 | String Enum | Can contain multiple instructions, space delimited | ||
528 | Char Enum | |||
529 | String Enum | |||
582 | Int Enum | |||
32 | Quantity | Quantity (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 | ||
652 | Quantity | |||
31 | Price | Price 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 | ||
651 | Price | |||
669 | Price | Last 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 | ||
194 | Price | Applicable for F/X orders | ||
195 | PriceOffset | Applicable for F/X orders | ||
30 | Exchange | If ExecType = Trade (F), indicates the market where the trade was executed. If ExecType = New (0), indicates the market where the order was routed | ||
336 | String | |||
625 | String | |||
943 | String | |||
29 | Char Enum | |||
151 | Quantity | 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 | ||
14 | Quantity | Currently executed quantity for chain of orders | ||
6 | Price | |||
424 | Quantity | For GT orders on days following the day of the first trade | ||
425 | Quantity | For GT orders on days following the day of the first trade | ||
426 | Price | For GT orders on days following the day of the first trade | ||
427 | Int Enum | States whether executions are booked out or accumulated on a partially filled GT order | ||
75 | LocalMktDate | Used when reporting other than current day trades | ||
60 | UTCTimestamp | Time the transaction represented by this ExecutionReport occurred | ||
113 | Boolean Enum | |||
Component | The 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 | ||||
Component | The set of "YieldData" (yield-related) fields defined in "Common Components of Application Messages" | |||
381 | Amount | |||
157 | Int | |||
230 | LocalMktDate | |||
158 | Percentage | |||
159 | Amount | |||
738 | Amount | For fixed income products which pay lump-sum interest at maturity | ||
920 | Amount | For repurchase agreements the accrued interest on termination | ||
921 | Amount | For repurchase agreements the start (dirty) cash consideration | ||
922 | Amount | For repurchase agreements the end (dirty) cash consideration | ||
258 | Boolean Enum | |||
259 | LocalMktDate | |||
260 | Price | |||
238 | Amount | |||
237 | Amount | |||
118 | Amount | On 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 | ||
119 | Amount | Used to report results of forex accommodation trade | ||
120 | Currency | Used to report results of forex accommodation trade | ||
155 | Float | Foreign exchange rate used to compute SettlCurrAmt from Currency to SettlCurrency | ||
156 | Char Enum | Whether the SettlCurrFxRate should be multiplied or divided | ||
21 | Char Enum | |||
110 | Quantity | |||
111 | Quantity | |||
77 | Char Enum | For use in derivatives omnibus accounting | ||
210 | Quantity | |||
775 | Int Enum | Method 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 | ||
58 | String | |||
354 | Length | Must be set if EncodedText field is specified and must immediately precede it | ||
355 | Data | Encoded (non-ASCII characters) representation of the Text field in the encoded format specified via the MessageEncoding field | ||
193 | LocalMktDate | Can be used with OrdType = "Forex - Swap" to specify the "value date" for the future portion of an F/X swap | ||
192 | Quantity | Can be used with OrdType = "Forex - Swap" to specify the order quantity for the future portion of an F/X swap | ||
641 | PriceOffset | Can be used with OrdType = "Forex - Swap" to specify the forward points (added to LastSpotRate) for the future portion of an F/X swap | ||
442 | Char Enum | Default is a single security if not specified | ||
480 | Char Enum | For CIV - Optional | ||
481 | Char Enum | |||
513 | String | Reference to Registration Instructions message for this Order | ||
494 | String | Supplementary registration information for this Order | ||
483 | UTCTimestamp | For CIV - Optional | ||
515 | UTCTimestamp | For CIV - Optional | ||
484 | Char Enum | For CIV - Optional | ||
485 | Float | For CIV - Optional | ||
638 | Int Enum | |||
639 | PriceOffset | |||
851 | Int Enum | Applicable only on OrdStatus of Partial or Filled | ||
Component | Number of contract details in this message (number of repeating groups to follow) | |||
Component | Number of legs A Multi-leg Execution if present and non-zero | |||
797 | Boolean | |||
Component | Required if any miscellaneous fees are reported. Indicates number of repeating entries. Repeating group. ** Nested Repeating Group follows ** | |||
Component |