TimeAndSale Sale Conditions
Overview
Sale Conditions, or Trade Conditions, are flags that dxFeed obtains from exchanges and data vendors. Sale Conditions provide you with a code that contains the principal trading terms and details about the type of trade. Sales condition codes may differ between exchanges, thus below is a list of decodes for different data vendors.
Statistics
Exchanges distinguish trades in different ways. For example, they may use time: opening of trading, during trading, or additional trading time.
Exchanges also calculate important daily statistics for their instruments, including:
Open: the trade’s opening price
High: the day’s highest price
Low: the day’s lowest price
Last: the day’s last price
Close: the closing price
Volume: the total trading volume
Some trade types don't affect this statistic, such as those that:
Aren't counted in the volume of trades
Don't update maximum and minimum prices
Aren't considered the official opening of trades and don't affect the opening price
These analytics also disregard some transactions, because they have zero effects on trading. For example, they don’t consider the previous days’ transactions.
Every exchange has different trading rules for statistics and its own Sale Conditions coding. For instance, US exchanges provide four independent symbols as Sale Conditions. Meanwhile, symbols’ descriptions aren’t identical to that of other US exchanges and depend on exchange rules. For other regions, the Sale Conditions format may be also different. Find descriptions for each exchange in the relevant sections.
Raw exchange sale conditions
Below are tables detailing the raw exchange sale conditions for various exchanges, with a specific focus on updating OHLC values and mapping to the dxFeed TimeAndSale.isValidTick flag.
Value | Description |
---|---|
1 | YES, if it is the only qualifying last; OR If it is that Participant’s first qualifying last; OTHERWISE NO |
2 | YES, if it is the only qualifying last; OTHERWISE NO |
3 | YES, if it is the only qualifying last; OR If it is from the same participant as the last; OR If it is from the PRIMARY MARKET for that Security; OTHERWISE NO |
4 | YES, if it is the first qualifying or only qualifying trade of the day; OTHERWISE NO. (In instances of multiple Market Center Opening Trades, the latest trade takes precedence) |
5 | UTDF subscribers should update consolidated last sale field if received prior to the End of Last Sale Eligibility Control Message (16:01:30). After End of Last Sale Eligibility Control Message is received the transaction would only update the market center-specific last sale value but not the consolidated last sale value. A Sold Last transaction should only impact the consolidated last sale price for an issue if the market center reporting the sold last transaction also reported the transaction setting the current last sale price |
NYSE & NYSE American (CTS)
NYSE CTS code | Sale Condition | Consolidated | Participant | Volume | isValidTick | Description | ||||
---|---|---|---|---|---|---|---|---|---|---|
Open | Last | High/Low | Open | Last | High/Low | |||||
Space or @ | REGULAR TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | A trade made without stated conditions is deemed regular way for settlement on the third business day following the transaction date |
C | CASH TRADE (Same Day Clearing) | N | N | N | N | N | N | Y | N | A transaction that calls for the delivery of securities and payment on the same day the trade took place |
E | AUTOMATIC EXECUTION | 4 | Y | Y | 4 | Y | Y | Y | Y | A sale condition code that identifies a NYSE trade that has been automatically executed without the potential benefit of price improvement |
F | INTERMARKET SWEEP ORDER | 4 | Y | Y | 4 | Y | Y | Y | Y | Intermarket sweep order means a limit order for an NMS stock that meets the following requirements: When routed to a trading center, the limit order is identified as an intermarket sweep order; Simultaneously with the routing of the limit order identified as an intermarket sweep order, one or more additional limit orders, as necessary, are routed to execute against the full displayed size of any protected bid, in the case of a limit order to sell, or the full displayed size of any protected offer, in the case of a limit order to buy, for the NMS stock with a price that is superior to the limit price of the limit order identified as an intermarket sweep order. These additional routed orders also must be marked as intermarket sweep orders |
H | PRICE VARIATION TRADE | N | N | N | N | N | N | Y | N | The Price Variation Trade sale condition code is used to denote a regular market session trade transaction that carries a price that is significantly away from the prevailing consolidated or primary market value at the time of the transaction |
I | ODD LOT TRADE | N | N | N | N | N | N | Y | N | Odd lot is an order amount for a security that is less than the normal unit of trading for that particular asset. Odd lots are considered to be anything less than the standard units of trade of 1, 10 or 100 shares |
K | RULE 127 (NYSE Only) or RULE 155 (NYSE MKT only) | 4 | Y | Y | 4 | Y | Y | Y | Y | To qualify as a 155 print, a specialist arranges for the sale of the block at one clean-up price or at the different price limits on his book. If the block is sold at a clean-up price, the specialist should execute at the same price all the executable buy orders on his book. This Sale Condition is only applicable for AMEX trades |
L | SOLD LAST (Late Reporting) | 4 | 3 | Y | 4 | Y | Y | Y | N | Sold Last sale condition modifier is used when a trade prints in sequence but is reported late OR the trade is printed by Amex in conformance to the One or Two Point Rule. A Sold Last transaction should only impact the consolidated last sale price for an issue if the market center reporting the sold last transaction also reported the transaction setting the current last sale price |
M | MARKET CENTER OFFICIAL CLOSE | N | N | N | N | Y | Y | N | N | Indicates the Official closing value as determined by a Market Center. This transaction report will contain the market center generated closing price |
N | NEXT DAY TRADE (Next Day Clearing) | N | N | N | N | N | N | Y | N | A transaction that calls for the delivery of securities between one and four days (to be agreed by both parties to the trade – the number of days are not noted with the transaction) after the trade date |
O | MARKET CENTER OPENING TRADE | 4 | 1 | Y | Y | 2 | Y | Y | Y | The transaction or group of transactions reported as a result of a single-priced opening event by the Market Center |
P | PRIOR REFERENCE PRICE | 4 | 2 | Y | 4 | 2 | Y | Y | N | An executed trade that relates to an obligation to trade at an earlier point in the trading day or that refers to a prior referenced price. This may be the result of an order that was lost or misplaced or was not executed on a timely basis |
Q | MARKET CENTER OFFICIAL OPEN | 4 | N | N | Y | N | Y | N | N | Indicates the “Official” opening value as determined by a Market Center. This transaction report will contain the market center generated opening priceDirect data recipients that maintain individual market center open values should use this value as the official market center opening value and populate data displays accordingly |
R | SELLER | N | N | N | N | N | N | Y | N | A Seller’s option transaction is a special transaction that gives the seller the right to deliver the stock at any time within a specific period, ranging from not less than four calendar days to not more than sixty calendar days |
T | FORM T (EXTENDED HOURS TRADE) | N | Y | N | N | Y | N | Y | Y | A trade executed before or after the regular US market hours. Please note that the Dot-T modifier should be appended to all transactions that occur during the pre- and post-market sessions. The volume of Form-T trades will be included in the calculation of consolidated and market center volume. The price information in Dot-T trades will not be used to update high, low and last sale data for individual securities or indices since they occur outside of normal trade reporting hours |
U | EXTENDED HOURS SOLD (Out of Sequence) | N | N | N | N | N | N | Y | N | Trade reports used to identify extended trading hours trades that are reported more than 90 seconds after execution |
V | CONTINGENT TRADE | - | N | N | N | N | N | Y | N | A Sale Condition code used to identify a transaction where the execution of the transaction is contingent upon some event |
B | AVERAGE PRICE TRADE | N | N | N | N | N | N | Y | N | A trade where the price reported is based upon an average of the prices for transactions in a security during all or any portion of the trading day. Please note that the Nasdaq market center also uses this value to report stopped stock situations |
X | CROSS/PERIODIC AUCTION TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | A Cross/Periodic auction trade a trade transaction resulting from a market center’s crossing session or auction trade |
Z | SOLD (Out of Sequence) | 4 | 2 | Y | 4 | 2 | Y | Y | N | Sold Out of Sequence is used when a trade is printed (reported) out of sequence and at a time different from the actual transaction time |
4 | DERIVATIVELY PRICED | 4 | 2 | Y | 4 | 2 | Y | Y | N | A transaction that constituted the trade-through was the execution of an order at a price that was not based, directly or indirectly, on the quoted price of the NMS stock at the time of execution and for which the material terms were not reasonably determinable at the time the commitment to execute the order was made |
5 | MARKET CENTER REOPENING TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | The transaction or group of transactions reported as a result of a single-priced re-opening event by the Market Center |
6 | MARKET CENTER CLOSING TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | The transaction or group of transactions reported as a result of a single-priced closing event by the Market Center |
7 | QUALIFIED CONTINGENT TRADE | - | N | N | N | N | N | Y | N | A transaction consisting of two or more component orders executed as agent or principal where the execution of one component is contingent upon the execution of all other components at or near the same time and the price is determined by the relationship between the component orders and not the current market price for the security |
8 | RESERVED | N | N | N | N | N | N | Y | N | |
9 | CORRECTED CONSOLIDATED CLOSE (PER LISTING MARKET) | 4 | Y | Y | N | N | N | N | N | Allowed to be used only by the Listing Market and may be used to adjust the consolidated last sale price. The Corrected Consolidated Close is eligible to set the High, Low and Last for the consolidated statistics and will not update the participant records. Volume will always be reported as zero |
We have different categories that are specific for each positions. If a Sale Condition is not required from any one of the categories, the unused Sale Condition Char should be space-filled. The Category hierarchy in the four Char Sale Condition field is currently as follows:
Category 1 Settlement Type | Category 2 Reason for Trade-Through Exemption / Other Reason | Category 3 Extended Hours / Sequence Type | Category 4 SRO Trade Detail |
---|---|---|---|
Space | Space (No Trade Through Exempt Reason) | Space (Not Extended Hours or Sold Out of Sequence) | Space (No SRO Required Trade Detail) |
C (Same Day Clearing) | F Inter-market Sweep Order | L Sold Last (Late Reporting) | B Average Price Trade |
N Next Day Trade (Next Day Clearing) | O Market Center Opening Trade | T Extended Hours Trade | E Automatic Execution |
R Seller | 4 Derivatively Priced | U Extended Hours Sold (Out of Sequence) | H Price Variation Trade |
5 Market Center Reopening Trade | Z Sold (Out of Sequence) | I Odd Lot Trade | |
6 Market Center Closing Trade | K Rule 127 (NYSE only) or Rule 155 (NYSE American only) | ||
7 Qualified Contingent Trade | M Market Center Official Close | ||
8 Reserved | P Prior Reference Price | ||
9 Corrected Consolidated Close Price as per Listing Market | Q Market Center Official Open | ||
V Contingent Trade | |||
X Cross / Periodic Auction Trade |
Sale Conditions within the same category are mutually exclusive (e.g., Sale Conditions C, N or R cannot be used in combination).
Sale Condition U (Extended Hours Sold – Out of Sequence) cannot be used in combination with any of the Sale Conditions listed in Category 2 – Reason for Trade-Through Exemption (Rule 611).
Sale Conditions L (Sold Last – Late Reporting), O (Market Center Opening Trade), P (Prior Reference Price), and Z (Sold – Out of Sequence), are mutually exclusive of each other (i.e., these sale conditions cannot be used in combination).
Nasdaq (UTDF)
Nasdaq UTDF code | Sale Condition | Consolidated | Participant | Volume | isValidTick | Description | ||||
---|---|---|---|---|---|---|---|---|---|---|
Open | Last | High/Low | Open | Last | High/Low | |||||
Space | REGULAR TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | A trade made without stated conditions is deemed regular way for settlement on the third business day following the transaction date |
A | ACQUISITION | 4 | Y | Y | 4 | Y | Y | Y | Y | A transaction made on the Exchange as a result of an Exchange acquisition |
B | BUNCHED TRADE | 4 | Y | Y | N | Y | Y | Y | Y | A trade representing an aggregate of two or more regular trades in a security occurring at the same price either simultaneously or within the same 60-second period, with no individual trade exceeding 10,000 shares |
C | CASH TRADE (Same Day Clearing) | N | N | N | N | N | N | Y | N | A transaction that calls for the delivery of securities and payment on the same day the trade took place |
D | DISTRIBUTION | 4 | Y | Y | 4 | Y | Y | Y | Y | Sale of a large block of stock in such a manner that the price is not adversely affected |
E | PLACEHOLDER FUTURE USE | N | N | N | N | N | N | N | Y | |
F | INTERMARKET SWEEP ORDER | 4 | Y | Y | 4 | Y | Y | Y | Y | Intermarket sweep order means a limit order for an NMS stock that meets the following requirements: When routed to a trading center, the limit order is identified as an intermarket sweep order; Simultaneously with the routing of the limit order identified as an intermarket sweep order, one or more additional limit orders, as necessary, are routed to execute against the full displayed size of any protected bid, in the case of a limit order to sell, or the full displayed size of any protected offer, in the case of a limit order to buy, for the NMS stock with a price that is superior to the limit price of the limit order identified as an intermarket sweep order. These additional routed orders also must be marked as intermarket sweep orders |
G | BUNCHED SOLD TRADE | 4 | 1 | Y | 4 | 1 | Y | Y | N | A bunched trade that is reported late |
H | PRICE VARIATION TRADE | N | N | N | N | N | N | Y | N | The Price Variation Trade sale condition code is used to denote a regular market session trade transaction that carries a price that is significantly away from the prevailing consolidated or primary market value at the time of the transaction |
I | ODD LOT TRADE | N | N | N | N | N | N | Y | N | Odd lot is an order amount for a security that is less than the normal unit of trading for that particular asset. Odd lots are considered to be anything less than the standard units of trade of 1, 10 or 100 shares |
K | RULE 127 (NYSE Only) or RULE 155 (NYSE MKT only) | 4 | Y | Y | 4 | Y | Y | Y | Y | To qualify as a 155 print, a specialist arranges for the sale of the block at one clean-up price or at the different price limits on his book. If the block is sold at a clean-up price, the specialist should execute at the same price all the executable buy orders on his book. This Sale Condition is only applicable for AMEX trades |
L | SOLD LAST (Late Reporting) | 4 | 5 | Y | 4 | Y | Y | Y | N | Sold Last sale condition modifier is used when a trade prints in sequence but is reported late OR the trade is printed by Amex in conformance to the One or Two Point Rule. A Sold Last transaction should only impact the consolidated last sale price for an issue if the market center reporting the sold last transaction also reported the transaction setting the current last sale price |
M | MARKET CENTER OFFICIAL CLOSE | N | N | N | N | Y | Y | N | N | Indicates the Official closing value as determined by a Market Center. This transaction report will contain the market center generated closing price |
N | NEXT DAY TRADE (Next Day Clearing) | N | N | N | N | N | N | Y | N | A transaction that calls for the delivery of securities between one and four days (to be agreed by both parties to the trade – the number of days are not noted with the transaction) after the trade date |
O | MARKET CENTER OPENING TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | The transaction or group of transactions reported as a result of a single-priced opening event by the Market Center |
P | PRIOR REFERENCE PRICE | 4 | 1 | Y | 4 | 1 | Y | Y | N | An executed trade that relates to an obligation to trade at an earlier point in the trading day or that refers to a prior referenced price. This may be the result of an order that was lost or misplaced or was not executed on a timely basis |
Q | MARKET CENTER OFFICIAL OPEN | N | N | N | Y | N | Y | N | N | Indicates the “Official” opening value as determined by a Market Center. This transaction report will contain the market center generated opening priceDirect data recipients that maintain individual market center open values should use this value as the official market center opening value and populate data displays accordingly |
R | SELLER | N | N | N | N | N | N | Y | N | A Seller’s option transaction is a special transaction that gives the seller the right to deliver the stock at any time within a specific period, ranging from not less than four calendar days to not more than sixty calendar days |
S | SPLIT TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | An execution in two markets when the specialist or Market Maker in the market first receiving the order agrees to execute a portion of it at whatever price is realized in another market to which the balance of the order is forwarded for execution |
T | FORM T (EXTENDED HOURS TRADE) | N | Y | N | N | Y | N | Y | Y | A trade executed before or after the regular US market hours. Please note that the Dot-T modifier should be appended to all transactions that occur during the pre- and post-market sessions. The volume of Form-T trades will be included in the calculation of consolidated and market center volume. The price information in Dot-T trades will not be used to update high, low and last sale data for individual securities or indices since they occur outside of normal trade reporting hours |
U | EXTENDED HOURS SOLD (Out of Sequence) | N | N | N | N | N | N | Y | N | Trade reports used to identify extended trading hours trades that are reported more than 90 seconds after execution |
V | STOCK-OPTION TRADE | N | N | N | N | N | N | Y | N | The Stock-Option Trade sale condition code is used to identify cash equities transactions which are related to options transactions and therefore potentially subject to cancellation if market conditions of the options leg(s) prevent the execution of the stock-option order at the price agreed upon |
W | AVERAGE PRICE TRADE | N | N | N | N | N | N | Y | N | A trade where the price reported is based upon an average of the prices for transactions in a security during all or any portion of the trading day. Please note that the Nasdaq market center also uses this value to report stopped stock situations |
X | CROSS/PERIODIC AUCTION TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | A Cross/Periodic auction trade a trade transaction resulting from a market center’s crossing session or auction trade |
Y | YELLOW FLAG REGULAR TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | Market Centers will have the ability to identify regular trades being reported during specific events as out of the ordinary by appending a new sale condition code Yellow Flag (“Y”) on each transaction reported to the Nasdaq SIP. The new sale condition “.Y” will be eligible to update all market center and consolidated statistics |
Z | SOLD (Out of Sequence) | 4 | 1 | Y | 4 | 1 | Y | Y | N | Sold Out of Sequence is used when a trade is printed (reported) out of sequence and at a time different from the actual transaction time |
1 | STOPPED STOCK (REGULAR TRADE) | 4 | Y | Y | 4 | Y | Y | Y | Y | In accordance with Amex Rule 109, a stopped stock transaction may occur under several circumstances, including when an Amex Specialist executes market-at-the-close orders in a stock, where the Specialist is holding simultaneously both buy and sell market-at-the-close orders. The Specialist is required, under section (d) of the rule, to report the "pair off" transaction as stopped stock. In addition a stopped stock transaction may occur when a Broker, trying to get a better price for the customer’s market order than the currently available price, asks the Specialist to "stop the stock". The Specialist guarantees the Broker the current "stopped" price but does not immediately execute the order. The order is used by the Specialist to improve the quote in order to obtain a better price. If the next trade is at the "stopped" price, the order is "elected" and executed by the Specialist at the stopped price rather than at an improved price. The execution at the stopped price is designated as stopped stock |
2 | RESERVED (Ex "STOPPED STOCK — SOLD LAST") | 4 | 5 | Y | 4 | Y | Y | Y | Y | In accordance with Amex Rule 109, a stopped stock transaction may occur under several circumstances, including when an Amex Specialist executes market-at-the-close orders in a stock, where the Specialist is holding simultaneously both buy and sell market-at-the-close orders. The Specialist is required, under section (d) of the rule, to report the "pair off" transaction as stopped stock. In addition a stopped stock transaction may occur when a Broker, trying to get a better price for the customer’s market order than the currently available price, asks the Specialist to "stop the stock". The Specialist guarantees the Broker the current "stopped" price but does not immediately execute the order. The order is used by the Specialist to improve the quote in order to obtain a better price. If the next trade is at the "stopped" price, the order is "elected" and executed by the Specialist at the stopped price rather than at an improved price. The execution at the stopped price is designated as stopped stock |
3 | RESERVED (Ex "STOPPED STOCK — SOLD (OUT OF SEQUENCE)") | 4 | 1 | Y | 4 | 1 | Y | Y | Y | In accordance with Amex Rule 109, a stopped stock transaction may occur under several circumstances, including when an Amex Specialist executes market-at-the-close orders in a stock, where the Specialist is holding simultaneously both buy and sell market-at-the-close orders. The Specialist is required, under section (d) of the rule, to report the "pair off" transaction as stopped stock. In addition a stopped stock transaction may occur when a Broker, trying to get a better price for the customer’s market order than the currently available price, asks the Specialist to "stop the stock". The Specialist guarantees the Broker the current "stopped" price but does not immediately execute the order. The order is used by the Specialist to improve the quote in order to obtain a better price. If the next trade is at the "stopped" price, the order is "elected" and executed by the Specialist at the stopped price rather than at an improved price. The execution at the stopped price is designated as stopped stock |
4 | DERIVATIVELY PRICED | 4 | 1 | Y | 4 | 1 | Y | Y | N | A transaction that constituted the trade-through was the execution of an order at a price that was not based, directly or indirectly, on the quoted price of the NMS stock at the time of execution and for which the material terms were not reasonably determinable at the time the commitment to execute the order was made |
5 | MARKET CENTER REOPENING TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | The transaction or group of transactions reported as a result of a single-priced re-opening event by the Market Center |
6 | MARKET CENTER CLOSING TRADE | 4 | Y | Y | 4 | Y | Y | Y | Y | The transaction or group of transactions reported as a result of a single-priced closing event by the Market Center |
7 | RESERVED | N | N | N | N | N | N | Y | N | |
8 | RESERVED | N | N | N | N | N | N | N | Y | |
9 | CORRECTED CONSOLIDATED CLOSE (PER LISTING MARKET) | 5 | Y | Y | N | N | N | N | N | Allowed to be used only by the Listing Market and may be used to adjust the consolidated last sale price. The Corrected Consolidated Close is eligible to set the High, Low and Last for the consolidated statistics and will not update the participant records. Volume will always be reported as zero |
OTCBB (TDDS)
OTCBB TDDS symbol | Sale Condition | Consolidated | Participant | Volume | isValidTick | Description | ||
---|---|---|---|---|---|---|---|---|
Last | High/Low | Last | High/Low | |||||
@ | REGULAR TRADE | Y | Y | Y | Y | Y | Y | Indicates a trade with no associated conditions |
C | CASH TRADE (Same Day Clearing) | N | N | N | N | Y | N | A transaction that calls for the delivery of securities and payment on the same day the trade took place |
I | ODD LOT TRADE | N | N | N | N | Y | N | Odd lot is an order amount for a security that is less than the normal unit of trading for that particular asset. Odd lots are considered to be anything less than the standard units of trade of 1, 10 or 100 shares |
N | NEXT DAY TRADE (Next Day Clearing) | N | N | N | N | Y | N | A transaction that calls for the delivery of securities between one and four days (to be agreed by both parties to the trade – the number of days are not noted with the transaction) after the trade date |
P | PRIOR REFERENCE PRICE | 2 | Y | 2 | Y | Y | N | An executed trade that relates to an obligation to trade at an earlier point in the trading day or that refers to a prior referenced price. This may be the result of an order that was lost or misplaced or was not executed on a timely basis |
R | SELLER | N | N | N | N | Y | N | A Seller’s option transaction is a special transaction that gives the seller the right to deliver the stock at any time within a specific period, ranging from not less than four calendar days to not more than sixty calendar days |
T | FORM T (EXTENDED HOURS TRADE) | Y | N | Y | N | Y | Y | A trade executed before or after the regular US market hours. Please note that the Dot-T modifier should be appended to all transactions that occur during the pre- and post-market sessions. The volume of Form-T trades will be included in the calculation of consolidated and market center volume. The price information in Dot-T trades will not be used to update high, low and last sale data for individual securities or indices since they occur outside of normal trade reporting hours |
U | EXTENDED HOURS SOLD (Out of Sequence) | N | N | N | N | Y | N | Trade reports used to identify extended trading hours trades that are reported more than 90 seconds after execution |
X | STOCK-OPTION TRADE | Y | Y | Y | Y | Y | Y | The Stock-Option Trade sale condition code is used to identify cash equities transactions which are related to options transactions and therefore potentially subject to cancellation if market conditions of the options leg(s) prevent the execution of the stock-option order at the price agreed upon |
W | AVERAGE PRICE TRADE | N | N | N | N | Y | N | A trade where the price reported is based upon an average of the prices for transactions in a security during all or any portion of the trading day. Please note that the Nasdaq market center also uses this value to report stopped stock situations |
Z | SOLD (Out of Sequence) | 2 | Y | 2 | Y | Y | N | Sold Out of Sequence is used when a trade is printed (reported) out of sequence and at a time different from the actual transaction time |
S | STOPPED STOCK (REGULAR TRADE) | Y | Y | Y | Y | Y | Y | In accordance with Amex Rule 109, a stopped stock transaction may occur under several circumstances, including when an Amex Specialist executes market-at-the-close orders in a stock, where the Specialist is holding simultaneously both buy and sell market-at-the-close orders. The Specialist is required, under section (d) of the rule, to report the "pair off" transaction as stopped stock. In addition a stopped stock transaction may occur when a Broker, trying to get a better price for the customer’s market order than the currently available price, asks the Specialist to "stop the stock". The Specialist guarantees the Broker the current "stopped" price but does not immediately execute the order. The order is used by the Specialist to improve the quote in order to obtain a better price. If the next trade is at the "stopped" price, the order is "elected" and executed by the Specialist at the stopped price rather than at an improved price. The execution at the stopped price is designated as stopped stock |
Eurex
TradeCondition (set) | |
---|---|
Value | Sale Condition |
U | Exchange Last |
R | Opening Price |
AX | High Price |
AY | Low Price |
AJ | Official Closing Price |
AW | Last Auction Price |
BD | Previous Closing Price |
XR | Retail price |
AW = Last Auction Price cannot be combined with any other value and has its own entry in order to convey the auction type through TrdType (828).
BB = Midpoint price is used to report prices resulting from Volume Discovery Orders (VDO) executed at midpoint (applicable for cash market products only).
TradeCondition (set) that is only present for MDEntryType 2 = Trade | ||
---|---|---|
Value | Sale Condition | Description |
a | Volume only | Used for coherent entries from direct matching of complex instruments (mutually exclusive with U).Trade Volume Reporting (T7 EMDI), Derivatives Only |
k | Out of sequence | Mutually exclusive with U. It is used for trades entered manually by Market Supervision, CLIP trades outside BBO which are reported as Liquidity Improvement Cross and for simple instrument Off-Book trades which are part of a basket trade |
SA | Special Auction | Indicates a Special Auction Price and is only applicable for trading model Continuous Auction Specialist. For federal bonds the Special Auction indicator is used for prices determined with Bundesbank participation |
BC | Trading On Terms Of Issue | Only applicable for cash market products |
TC | Trade At Close | Used for trade prices resulting from Trade At Close security trading phase and is applicable for cash market instruments only |
OPRA
For OPRA, Sale Condition may contain two letters:
The first letter represents the session indicator. See the table below.
OPRA code | Description |
---|---|
- | RTH (Regular OPRA Session) |
X | Indicates an issue |
1 | Indicates Monday |
2 | Indicates Tuesday |
3 | Indicates Wednesday |
4 | Indicates Thursday |
5 | Indicates Friday |
The second letter represents the trade type. See the table below.
OPRA code | Type | Description |
---|---|---|
A | CANC | Transaction previously reported (other than as the last or opening report for the particular option contract) is now to be cancelled |
B | OSEQ | Transaction is being reported late and is out of sequence; i.e., later transactions have been reported for the particular option contract |
C | CNCL | Transaction is the last reported for the particular option contract and is now cancelled |
D | LATE | Transaction is being reported late, but is in the correct sequence; i.e., no later transactions have been reported for the particular option contact |
E | CNCO | Transaction was the first one (opening) reported this day for the particular option contract. Although later transactions have been reported, this transaction is now to be cancelled |
F | OPEN | Transaction is a late report of the opening trade and is out of sequence; i.e., other transactions have been reported for the particular option contract |
G | CNOL | Transaction was the only one reported this day for the particular option contract and is now to be cancelled |
H | OPNL | Transaction is a late report of the opening trade, but is in the correct sequence; i.e., no other transactions have been reported for the particular option contract |
I | AUTO | Transaction was executed electronically. Prefix appears solely for information; process as a regular transaction |
J | REOP | Transaction is a reopening of an option contract in which trading has been previously halted. Prefix appears solely for information; process as a regular transaction |
S | ISOI | Transaction was the execution of an order identified as an Intermarket Sweep Order. Process like normal transaction |
a | SLAN | Single Leg Auction Non ISO Transaction was the execution of an electronic order which was “stopped” at a price and traded in a two sided auction mechanism that goes through an exposure period. Such auctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism |
b | SLAI | Single Leg Auction ISO Transaction was the execution of an Intermarket Sweep electronic order which was “stopped” at a price and traded in a two sided auction mechanism that goes through an exposure period. Such auctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism marked as ISO |
c | SLCN | Single Leg Cross Non ISO Transaction was the execution of an electronic order which was “stopped” at a price and traded in a two sided crossing mechanism that does not go through an exposure period. Such crossing mechanisms include and not limited to Customer to Customer Cross and QCC with a single option leg |
d | SCLI | Single Leg Cross ISO Transaction was the execution of an Intermarket Sweep electronic order which was “stopped” at a price and traded in a two sided crossing mechanism that does not go through an exposure period. Such crossing mechanisms include and not limited to Customer to Customer Cross |
e | SLFT | Single Leg Floor Trade Transaction represents a non-electronic trade executed on a trading floor. Execution of Paired and Non-Paired Auctions and Cross orders on an exchange floor are also included in this category |
f | MLET | Multi Leg autoelectronic trade Transaction represents an electronic execution of a multi leg order traded in a complex order book |
g | MLAT | Multi Leg Auction Transaction was the execution of an electronic multi leg order which was “stopped” at a price and traded in a two sided auction mechanism that goes through an exposure period in a complex order book. Such auctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism |
h | MLCT | Multi Leg Cross Transaction was the execution of an electronic multi leg order which was “stopped” at a price and traded in a two sided crossing mechanism that does not go through an exposure period. Such crossing mechanisms include and not limited to Customer to Customer Cross and QCC with two or more options legs |
i | MLFT | Multi Leg floor trade Transaction represents a non-electronic multi leg order trade executed against other multi-leg order(s) on a trading floor. Execution of Paired and Non-Paired Auctions and Cross orders on an exchange floor are also included in this category |
j | MESL | Multi Leg autoelectronic trade against single leg(s) Transaction represents an electronic execution of a multi Leg order traded against single leg orders/ quotes |
k | TLAT | Stock Options Auction Transaction was the execution of an electronic multi leg stock/options order which was “stopped” at a price and traded in a two sided auction mechanism that goes through an exposure period in a complex order book. Such auctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism |
l | MASL | Multi Leg Auction against single leg(s) Transaction was the execution of an electronic multi leg order which was “stopped” at a price and traded in a two sided auction mechanism that goes through an exposure period and trades against single leg orders/ quotes. Such auctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism |
m | MFSL | Multi Leg floor trade against single leg(s) Transaction represents a non-electronic multi leg order trade executed on a trading floor against single leg orders/ quotes. Execution of Paired and Non-Paired Auctions on an exchange floor are also included in this category |
n | TLET | Stock Options autoelectronic trade Transaction represents an electronic execution of a multi leg stock/options order traded in a complex order book |
o | TLCT | Stock Options Cross Transaction was the execution of an electronic multi leg stock/options order which was “stopped” at a price and traded in a two sided crossing mechanism that does not go through an exposure period. Such crossing mechanisms include and not limited to Customer to Customer Cross |
p | TLFT | Stock Options floor trade Transaction represents a non-electronic multi leg order stock/options trade executed on a trading floor in a Complex order book. Execution of Paired and Non -Paired Auctions and Cross orders on an exchange floor are also included in this category |
q | TESL | Stock Options autoelectronic trade against single leg(s) Transaction represents an electronic execution of a multi Leg stock/options order traded against single leg orders/ quotes |
r | TASL | Stock Options Auction against single leg(s) Transaction was the execution of an electronic multi leg stock/options order which was “stopped” at a price and traded in a two sided auction mechanism that goes through an exposure period and trades against single leg orders/ quotes. Such auctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism |
s | TFSL | Stock Options floor trade against single leg(s) Transaction represents a non-electronic multi leg stock/options order trade executed on a trading floor against single leg orders/ quotes. Execution of Paired and Non -Paired Auctions on an exchange floor are also included in this category |
t | CBMO | Multi Leg Floor Trade of Proprietary Products Transaction represents execution of a proprietary product non-electronic multi leg order with at least 3 legs. The trade price may be outside the current NBBO |
u | MCTP | Multilateral Compression Trade of Proprietary Products Transaction represents an execution in a proprietary product done as part of a multilateral compression. Trades are executed outside of regular trading hours at prices derived from end of day markets. Trades do not update Open, High, Low, and Closing Prices |
v | EXHT | Extended Hours Trade Transaction represents a trade that was executed outside of regular market hours. Trades do not update Open, High, Low, and Closing Prices |
CME Group
For CME available Sale Conditions:
'B' == Block Trade
'P' == Exchange for Physical
'R' == Exchange for Risk
ICE Futures
For ICE the first letter of Sale Condition indicates IsSystemPricedLeg (Indicate if it is a system priced leg, ‘Y’ or ‘N’). Space == 'N'. S and C == 'Y'.
SystemPricedLegType Description | SystemPricedLegType code |
---|---|
N/A | Space |
System Priced Crack Spread Leg | C |
System Priced Leg | S |
The second letter represents the trade type:
Trade Type Description | Trade Type |
---|---|
Normal | Space |
Block | K |
EFS | S |
EFP | E |
EFP/EFS | O |
EOO | Q |
EFM | I |