API Documentation


C
A
N
C
E
L
L
A
T
E
R
P
T
A
U
T
O
E
X
E
C
O
P
E
N
R
P
T
V
O
L
U
M
E
H
I
G
H
L
O
W
L
A
S
T
NxCore Trade Conditions NYSE
AMEX
NASD OPRA CAN
NxID Name Properties Comment Exchange Code
0 Regular



X X X X Regular Trade @ @

1 FormT



X


Form T. Before and After Regular Hours. note: NYSE/AMEX previously used code 'T' for BurstBasket. T T

2 OutOfSeq
X

X X X * Report was sent Out Of Sequence. Updates last if it becomes only trade (if the trade reports before it are canceled, for example). Z Z B
3 AvgPrc



X


Average Price for a trade. NYSE/AMEX stocks. Nasdaq uses AvgPrc_Nasdaq-- main difference is NYSE/AMEX does not conditionally set high/low/last. W


4 AvgPrc_Nasdaq



X


Average Price. Nasdaq stocks. Similar to AvgPrc, but does not set high/low/last.
W

5 OpenReportLate
X

X X X * NYSE/AMEX. Market opened Late. Here is the report. It may not be in sequence. Nasdaq uses OpenReportOutOfSeq. *update last if only trade. O


6 OpenReportOutOfSeq
X

X X X
Report IS out of sequence. Market was open, and now this report is just getting to us.
O F
7 OpenReportInSeq
X

X X X X Opening report. This is the first price.


H
8 PriorReferencePrice
X

X X X * Trade references price established earlier. *Update last if this is the only trade report.
P

9 NextDaySale



X


NYSE/AMEX:Next Day Clearing. Nasdaq: Delivery of Securities and payment one to four days later.
*As of September 5, 2017, the NYSE will no longer accept orders with Cash, Next Day or Seller's Option instructions.
N* N

10 Bunched



X X X X Aggregate of 2 or more Regular trades at same price within 60 seconds and each trade size not greater than 10,000.
B

11 CashSale



X


Delivery of securities and payment on the same day.
*As of September 5, 2017, the NYSE will no longer accept orders with Cash, Next Day or Seller's Option instructions.
C* C
c
12 Seller



X


Stock can be delivered up to 60 days later as specified by the seller. After 1995, the number of days can be greater than 60. note: delivery of 3 days would be considered a regular trade.
*As of September 5, 2017, the NYSE will no longer accept orders with Cash, Next Day or Seller's Option instructions.
R* R

13 SoldLast
X

X X X * Late Reporting. *Sets Consolidated Last if no other qualifying Last, or same Exchange set previous Trade, or Exchange is Listed Exchange. L L D
14 Rule127



X X X X NYSE only. Rule 127 basically denotes the trade was executed as a block trade. J


15 BunchedSold
X

X X X * Several trades were bunched into one trade report, and the report is late. *Update last if this is first trade.
G

16 NonBoardLot



X


Size of trade is less than a board lot (oddlot). A board lot is usually 1,00 shares. Note this is Canadian markets.


E
17 POSIT



X X X
POSIT Canada is an electronic order matching system that prices trades at the mid-point of the bid and ask in the continuous market.


P
18 AutoExecution

X
X X X X Transaction executed electronically. Soley for information. Only found in OPRA -- options trades, and quite common.

I
19 Halt







Temporary halt in trading in a particular security for one or more participants.



20 Delayed



X


Indicates a delayed opening


?
21 Reopen



X X X X Reopening of a contract that was previously halted.

J
22 Acquisition



X X X X Transaction on exchange as a result of an Exchange Acquisition
A

23 CashMarket



X X X X Cash only Market. All trade reports for this session will be settled in cash. note: differs from CashSale in that the trade marked as CashSale is an exception -- that is, most trades are settled using regular conditions. A

?
24 NextDayMarket



X X X X Next Day Only Market. All trades reports for this session will be settled the next day. Note: differs from NextDay in that the trade marked as NextDay is an exception -- that is, most trades are settled using regular conditions. D


25 BurstBasket



X X X X Specialist bought or sold this stock as part of an execution of a specific basket of stocks. F


26 OpenDetail
X





107-113, 130, 160 Deleted an existing Sale Condition (Note: the code may be repurposed at a future date): 'G' - 'Opening/Reopening Trade Detail'

This trade is one of several trades that made up the open report trade. Often the open report has a large size which was made up of orders placed overnight. After trading has commenced, the individual trades of the open report trade are sent with this condition. Note it doesn't update volume, high, low, or last because it's already been accounted for in the open report.

DEL


27 IntraDetail
X





This trade is one of several trades that made up a previous trade. Similar to OpenDetail but refers to a trade report that was not the opening trade report. H


28 BasketOnClose
X

X


A trade consisting of a paired basket order to be executed based on the closing value of an index. These trades are reported after the close when the index closing value is known.



29 Rule155



X X X X AMEX only rule 155. Sale of block at one clean-up price. K K

30 Distribution



X X X X Sale of a large block of stock in a way that price is not adversely affected.
D

31 Split



X X X X Execution in 2 markets when the specialist or MM 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.
S

32 RegularSettle



X X X X RegularSettle Space


33 CustomBasketCross



X


One of two types:
  • 2 paired but seperate orders in which a market maker or member facilitates both sides of a remaining portion of a basket.
  • A split basket plus an entire basket where the market maker or member facilitates the remaining shares of the split basket.
t


34 AdjTerms



X X X X Terms have been adjusted to reflect stock split/dividend or similar event.

K
35 Spread



X X X X Spread between 2 options in the same options class.

L
36 Straddle



X X X X Straddle between 2 options in the same options class.

M
37 BuyWrite



X X X X This is the option part of a covered call.

P
38 Combo



X X X X A buy and a sell in 2 or more options in the same class.

Q
39 STPD



X X X X Traded at price agreed upon by the floor following a non-stopped trade of the same series at the same price.

N
40 CANC X






Cancel a previously reported trade - it will not be the first or last trade record. note: If the most recent report is Out of seq, SoldLast, or a type that does not qualify to set the last, that report can be considered in processing the cancel.

A
41 CANCLAST X






Cancel the most recent trade report that is qualified to set the last.

C
42 CANCOPEN X






Cancel the opening trade report.

E
43 CANCONLY X






Cancel the only trade report. There is only one trade report, cancel it.

G
44 CANCSTPD X






Cancel the trade report that has the condition STPD.

O
45 MatchCross



X X X X

CTS and UTP: Cross Trade

A Cross Trade a trade transaction resulting from a market center's crossing session.


X
X


46 FastMarket



X X X X Term used to define unusually hectic market conditions.



47 Nominal



X X X X Nominal price. A calculated price primarily generated to represent the fair market value of an inactive instrument for the purpose of determining margin requirements and evaluating position risk. Common in futures and futures options.



48 Cabinet


X



A trade in a deep out-of-the-money option priced at one-half the tick value. Used by options traders to liquidate positions.



49 BlankPrice







Sent by an exchange to blank out the associated price (bid, ask or trade).



50 NotSpecified







An unspecified (generalized) condition.


?
51 MCOfficialClose







The Official closing value as determined by a Market Center. M
M


52 SpecialTerms



X X X X Indicates that all trades executed will be settled in other than the regular manner.
?

53 ContingentOrder



X X X X The result of an order placed by a Participating Organization on behalf of a client for one security and contingent on the execution of a second order placed by the same client for an offsetting volume of a related security.



54 InternalCross




X X X X A cross between two client accounts of a Participating Organization which are managed by a single firm acting as portfolio manager with discretionary authority to manage the investment portfolio granted by each of the clients. This was originally from Toronto Stock Exchange (TSX). Information located here.


?
55 StoppedRegular




X X X X Stopped Stock  Regular Trade.
1

56 StoppedSoldLast




X X X Stopped Stock  SoldLast Trade
2

57 StoppedOutOfSeq
X


X X
Stopped Stock -- Out of Sequence.
3

58 Basis



X X X X A transaction involving a basket of securities or an index participation unit that is transacted at prices achieved through the execution of related exchange-traded derivative instruments, which may include index futures, index options and index participation units in an amount that will correspond to an equivalent market exposure.



59 VWAP



X


Volume Weighted Average Price. A transaction for the purpose of executing trades at a volume-weighted average price of the security traded for a continuous period on or during a trading day on the exchange.



60 SpecialSession



X


Occurs when an order is placed by a purchase order on behalf of a client for execution in the Special Trading Session at the last sale price.



61 NanexAdmin







Used to make volume and price corrections to match official exchange values.



62 OpenReport



X X X
Indicates an opening trade report. O


63 MarketOnClose


X X X X The Official closing value as determined by a Market Center.



64 SettlePrice







Settlement Price



65 OutOfSeqPreMkt
X

X


An out of sequence trade that exectuted in pre or post market -- a combination of FormT and OutOfSeq. U


66 MCOfficialOpen







Indicates the 'Official' opening value as determined by a Market Center. This transaction report will contain the market center generated opening price. Q
Q


67 FuturesSpread



X X X X Execution was part of a spread with another futures contract.



68 OpenRange




X X
Two trade prices are used to indicate an opening range representing the high and low prices during the first 30 seconds or so of trading.




69 CloseRange




X X
Two trade prices are used to indicate an opening range representing the high and low prices during the last 30 seconds or so of trading.



70 NominalCabinet







Nominal Cabinet



71 ChangingTrans



X X X X Changing Transaction



72 ChangingTransCab







Changing Cabinet Transaction



73 NominalUpdate







Nominal price update



74 PitSettlement







Sent with a "pit session" settlement price to the electronic session, for the purpose of computing net change from the next day electronic session and the prior session settlement price.



75 BlockTrade



X X X X An executed trade of a large number of shares, typically 10,000 shares or more.



76 ExgForPhysical



X X X X Exchange Future for Physical



77 VolumeAdjustment



X


An adjustment made to the cumulative trading volume for a trading session.



78 VolatilityTrade



X X X X Volatility trade



79 YellowFlag



X X X X Appears when reporting exchnge may be experiencing technical difficulties.
Y

80 FloorPrice



X X X X Distinguishes a floor Bid/Ask from a member Bid Ask on LME



81 OfficialPrice



X X X X Official bid/ask price used by LME.



82 UnofficialPrice



X X X X Unofficial bid/ask price used by LME.



83 MidBidAskPrice



X X X X A price halfway between the bid and ask on LME.



84 EndSessionHigh




X

End of Session High Price.



85 EndSessionLow





X
End of Session Low Price.



86 Backwardation



X X X X A condition where the immediate delivery price is higher than the future delivery price. Opposite of Contango.



87 Contango



X X X X A condition where the future delivery price is higher than the immediate delivery price. Opposite of Backwardation.



88 Holiday



X X X X In Development



89 PreOpening



X


The period of time prior to the market opening time (7:00 A.M. - 9:30 A.M.) during which orders are entered into the market for the Opening.



90 PostFull












91 PostRestricted












92 ClosingAuction












93 Batch












94 Trading












95 IntermarketSweep



X X X X A trade resulting from an Intermarket Sweep Order Execution. For more information on intermarket sweeps, please see the SEC NMS regulation (June 29, 2005 - PDF).
From that report:
"The intermarket sweep exception enables trading centers that receive sweep orders to execute those orders immediately, without waiting for betterpriced quotations in other markets to be updated."
F F S
96 Derivative



X X X * Derivatively priced. 4 4

97 Reopening



X X X X Market center re-opening prints. 5 5

98 Closing



X X X * Market center closing prints. Can be used to get closing auction information for exchanges that report it, such as NYSE. 6 6

99 CAPElection



X X X
CTA Docs

78, 110, 111, 113 & 136 Redefined: Existing code 'I' in the Sale Condition field to denote the following change in value: From - Cap Election Trade To - Odd Lot Trade

A trade resulting from an sweep execution where CAP orders were elected and executed outside the best bid or affer and appear as repeat trades.

DEL


100 SpotSettlement



X X X X




101 BasisHigh



X X X





102 BasisLow



X X X





103 Yield







Applies to bid and ask yield updates for Cantor Treasuries



104 PriceVariation








H



105 ContingentTrade (formerly StockOption)




X



Effective July 2015 ~ A Sale Condition used to identify a transaction where the execution of the transaction is contingent upon some event.
SIAC Trader Update: February 25, 2015 (PDF)

Previously: StockOption

V V


106 StoppedIM



X X X
Transaction order which was stopped at a price that did not constitute a Trade-Through on another market. Valid trade do not update last

R
107 Benchmark












108 TradeThruExempt






X This condition will be assigned for Tapes A/B and UTP when no Trade Through Exempt reason is given, and the Trade Through Exempt indicator is set. For Tapes A/B and UTP, these trades are eligible to update O/H/L/L/V. For OPRA, these trades only update volume.

X
109 Implied



X


These trades are result of a spread trade. The exchange sends a leg price on each future for spread transactions. These trades do not update O/H/L/L but they update volume. We are now sending these spread trades for Globex exchanges: CME, NYMEX, COMEX, CBOT, MGE, KCBT and DME.



110 OTC












111 MktSupervision












112 RESERVED_77












113 RESERVED_91












114 ContingentUTP












115 OddLot



X



This indicates any trade with size between 1-99. I I

116 RESERVED_89












117 CorrectedCSLast




X X X This allows for a mechanism to correct the official close on the consolidated tape. 9
9


118 OPRAExtHours







OPRA extended trading hours session. Equivalent to the OPRA "Session Indicator" with ASCII value of 'X' (Pre-Market extended hours trading session)(Obselete, see condition 148).

X

119 RESERVED_78












120 RESERVED_81












121 RESERVED_84












122 RESERVED_878












123 RESERVED_90












124 QualifiedContingentTrade



X


Effective July 2015 ~ A transaction consisting of two or more component orders, executed as agent or principal, that meets each of the following elements:
  1. At least one component order is for an NMS stock.
  2. All components are effected with a product or price contingency that either has been agreed to by the respective counterparties or arranged for by a broker-dealer as principal or agent.
  3. The execution of one component is contingent upon the execution of all other components at or near the same time.
  4. The specific relationship between the component orders (e.g. the spread between the prices of the component orders) is determined at the time the contingent order is placed.
  5. The component orders bear a derivative relationship to one another, represent different classes of shares of the same issuer, or involve the securities of participants in mergers or with intentions to merge that have been announced or since cancelled.25
  6. The Exempted NMS Stock Transaction is fully hedged (without regard to any prior existing position) as a result of the other components of the contingent trade. 26

7
7


125 SingleLegAuctionNonISO



X X X X 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. a

126 SingleLegAuctionISO



X X X X 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. Suchauctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism marked as ISO. b

127 SingleLegCrossNonISO



X X X X 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. c

128 SingleLegCrossISO



X X X X 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. d

129 SingleLegFloorTrade



X X X X 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. e

130 MultiLegAutoelectronicTrade



X X X X Transactionrepresents an electronic execution of a multi leg order traded in a complex order book. f

131 MultiLegAuction



X X X X 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. g

132 MultiLegCross



X X X X 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. h

133 MultiLegFloorTrade



X X X X 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. i

134 MultiLegAutoElecTradeAgainstSingleLeg



X X X X Transaction represents an electronic execution of a multi Leg order traded against single leg orders/quotes. j

135 StockOptionsAuction



X X X X 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. k

136 MultiLegAuctionAgainstSingleLeg



X X X X 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. l

137 MultiLegFloorTradeAgainstSingleLeg



X X X X 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. m

138 StockOptionsAutoElecTrade



X X X X Transaction represents an electronic execution of a multi leg stock/options order traded in a complex order book. n

139 StockOptionsCross



X X X X 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. o

140 StockOptionsFloorTrade



X X X X 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. p

141 StockOptionsAutoElecTradeAgainstSingleLeg



X X X X Transaction represents an electronic execution of a multi Leg stock/options order traded against single leg orders/quotes. q

142 StockOptionsAuctionAgainstSingleLeg



X X X X 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 periodand trades against single leg orders/ quotes. Such auctions mechanisms include and not limited to Price Improvement, Facilitation or Solicitation Mechanism. r

143 StockOptionsFloorTradeAgainstSingleLeg



X X X X 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. s

144 MultiLegFloorTradeOfProprietaryProducts



X X X X 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. t

145 BidAggressor



X X X X Aggressor of the trade is on the buy side.

146 AskAggressor



X X X X Aggressor of the trade is on the sell side.

147 MultilateralCompressionTradeofProprietaryDataProducts



X 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. u

148 ExtendedHoursTrade



X Transaction represents a trade that was executed outside of regular market hours. v

NxID Name Properties Comment Exchange Code

C
A
N
C
E
L
L
A
T
E
R
P
T
A
U
T
O
E
X
E
C
O
P
E
N
R
P
T
V
O
L
U
M
E
H
I
G
H
L
O
W
L
A
S
T
NxCore Trade Conditions
NYSE
AMEX
Nasd OPRA CAN