|
|
|
|
|
|
|
POSITION
FROM TO
|
FIELD NAME AND FORM
|
SAMPLE DATA
|
FORMAT
|
DESCRIPTION AND COMMENTS
|
R-EX
|
|
1
|
3
|
Message Identifier
|
P or 1
|
AN
|
Message Identifier
CME:
TRX – Inbound record from firm or Outbound message from CME
CBOT:
Use one-character CBOT Record Type (Card Code):
1 – Futures for Clearing & Bookkeeping
J – Futures for Clearing Only
A – Futures for Bookkeeping Only
3 – Futures/Options Correction (MisClear)
4 – Futures Delete
P – Options for Clearing & Bookkeeping
Q – Options for Clearing Only
B – Options for Bookkeeping Only
K – Options Correction
L – Options Delete
H – Options Transfer
U – Options Adjustments
E – Options Exercise
|
CB
|
|
4
|
4
|
Message Version
|
N/A
|
N
|
Message Version: “1” for ETC transactions
|
C
|
|
5
|
12
|
Message Time
|
10120600
|
N
|
Time of TREX Record Creation (HHMMSS00)
|
CB
|
|
13
|
20
|
TOPS Special ID
|
|
AN
|
TOPS Combination terminal id and sequence number
|
CB
|
|
21
|
24
|
Message Length
|
0211
|
N
|
Message Length of main record and special blocks
|
CB
|
|
25
|
25
|
Action Code
|
A
|
A
|
Action Code
A = Add C = Change D = Delete
S = SIMEX Confirm B = InterExchange Out-trade (cleared locally but did not clear InterExchange match)
|
CB
|
|
26
|
26
|
Trade Route Indicator
|
N/A
|
N
|
CBOT: Identifies how transactions are processed for the executing firm.
1 = Clearing only
2 = Bookkeeping only
3 = Clearing and bookkeeping
CME: Identifies source of trade submission on outbound messages only.
1 = Firm assigned Trade IDs
3 = CME assigned Trade IDs from ETC, TES, GLOBEX, C21 EFP, Eurodollar bundles, FLEX and out of range or duplicate firm trades.
|
CB
|
|
27
|
34
|
Trade Date
|
19981103
|
N
|
Date transactions executed. If this field is blank, it will be interpreted as the current date. " As of” trades (out-trades) must have the correct trade date entered.
Format: CCYYMMDD
|
CB
|
35
|
39
|
Exchange ID
|
51
|
AN
|
Exchange where trades are executed:
CME or 02 - Chicago Mercantile Exchange
IMM or 16 - CME Int'l Monetary Market
BOT or 01 - Chicago Board of Trade
MACE or 03 - Mid-Am Commodity Exchange
51 – CBOT Evening (Project A)
53 – MidAm Evening
TOPS Only Exchanges:
06 – CSCE
04 – COMEX
08 – KCBT
09 – Minneapolis
13 – FINEX
07 – NYMEX
11 – WCE
15 – NYFE
|
CB
|
|
40
|
44
|
Clearing Member Firm
|
835
|
AN
|
Clearing firm number
|
CB
|
|
45
|
49
|
Executing Broker
|
835
|
AN
|
Executing Broker ID
|
CB
|
|
50
|
51
|
Transaction Type Code
|
1
|
AN
|
Trade type code, valid entries are:
CME:
2 = GLOBEX Trades
5 = GLOBEX Spread Trades
6 = Spread Trades
7 = TMS Transfer (FLEX, GUS, GGU)
8 = Transfer trades between different firms and origin
9 = Cash Exchange trades used for bookkeeping processing and CFTC reporting of a purchase or sale of cash commodities. Used only if the account has or had a reportable position with this commodity.
L = Legged spread
CBOT:
3 = Mis-clears
6 = Spread transactions
7 = In-House Transfer trades between origin
8 = Transfer trades between different firms
9 = Cash Exchange trades used for bookkeeping, processing and CFTC reporting of a purchase or sale of cash commodities. Used only if the account has or had a reportable position within this commodity.
F = From Option Transfer
L = Legged spread
T = To Option Transfer
D = Differential Spread (for Futures only)
|
CB
|
|
52
|
52
|
Buy/Sell Code
|
1
|
AN
|
Buy/Sell Code
B or 1 = Buy, S or 2 = Sell
|
CB
|
|
53
|
57
|
Commodity Code
|
17
|
AN
|
Commodity Code (left justified)
|
CB
|
|
58
|
65
|
Contract Year/Month
|
19981200
|
AN
|
Contract Year/Month (CCYYMMDD)
|
CB
|
|
66
|
66
|
Put/Call Indicator
|
P
|
A
|
Put/Call Code; P = Put, C = Call (Blank = Futures)
|
CB
|
|
67
|
74
|
Strike Price
|
0100
|
AN
|
Option Exercise Price
|
CB
|
|
75
|
75
|
Strike Price Sign
|
-
|
AN
|
RESERVED FOR FUTURE USE
Strike Price Sign indicating value entered as positive or negative amount
Blank or "+" = Positive, "-" = Negative
|
CB
|
|
76
|
80
|
Opposite Clearing Member Firm
|
275
|
AN
|
Opposite Firm Number
CBOT: For Trade ID Matching (Modified Contra):
Trade ID Match code must be 2-3 characters, minimum of 2, must contain at least 1 alpha, 1 numeric character.
|
CB
|
|
81
|
85
|
Opposite Broker
|
N/A
|
AN
|
Opposite Broker Number/Symbol
|
CB
|
|
86
|
99
|
Trade Price
|
0964200
|
AN
|
Price (right justified) APS ROUNDED AVERAGE PRICE
|
CB
|
|
100
|
100
|
Trade Price Sign
|
+
|
AN
|
RESERVED FOR FUTURE USE
Trade Price Sign indicating value entered as positive or negative amount
Blank or "+" = Positive, "-" = Negative
|
CB
|
|
101
|
105
|
Quantity
|
3
|
N
|
Quantity of contracts traded:
Note: For CME, the current value cannot exceed 9999
|
CB
|
|
106
|
108
|
Time Bracket Code
|
N/A
|
AN
|
Time Bracket Code (left justified)
|
CB
|
|
109
|
118
|
Account Number
|
12345678
|
AN
|
Account for which trade was executed
|
CB
|
|
119
|
119
|
CTI Code
|
1
|
N
|
Customer Type Indicator:
1 = Broker/trader trading for own account.
2 = Broker/trader trading for clearing member firm's house account. (A "2" in this field will cause a record to be rejected if submitted for customer accounts-see Origin.)
3 = Broker/trader trading for the account of another broker/trader present on the trading floor or an account controlled by such broker/trader.
4 = Broker/trader trading for any other customer's account or for the account of a broker/trader not present on the floor.
|
CB
|
|
120
|
121
|
Origin Code
|
N/A
|
N
|
Origin Code for customer or house accounts:
(right justified)
CME:
1 = Customer (always 1 for ETC)
2 = Non-Customer
CBOT:
1 = Customer
2 = Non-Customer
3 = House Floor Broker (Options Only)
4 = Floor Broker (Options Only)
|
CB
|
|
122
|
129
|
Card/Order ID
|
N/A
|
AN
|
Card/Order Number (right justified)
For outbound CME/ETC records, format =XXX99999
Where XXX = Trader Symbol
99999= Card sequence number
|
CB
|
|
130
|
131
|
Fee Code
|
N/A
|
AN
|
Clearing/Exchange Fee
Not used on outbound ETC record.
CME:
E = Equity Members, Clearing Members*
L = Lessee/106.F. Employees
B = CBOE Member (trading S&P products only)
H = 106.H./J. Firms
C = Non-Member (customer)
M = Member rate for futures side of BK broker combination trades.
* A 106.F. member, who is an owner of a clearing member firm and whose seat is assigned for clearing privileges, is entitled to equity rates and therefore should use the fee code of E.
If this field is blank, the default value is determined by the CTI code as follows:
CTI Code Rate
1 Equity, Lessee/106.F. Employee, 106.H./J., or Customer Rate
1, 3, 4 Customer Rate
However, please note that a valid FEE type must be entered for APS and GUS Transactions. If not, the trade record will not route to GUS or APS.
CBOT:
C = Customer
F = Full and associate members trading for their own account and as floor brokers
I = GIM, IDEM and COM membership interest holders
M = All other ownership types
1 = 1st year delegate trading for his own account
2 = 2nd year delegate trading for his own account
3 = 3rd year delegate trading for his own account
4 = 4th year delegate trading for his own account
5 = 5th year delegate trading for his own account
9 = 6th year and beyond delegate trading for his own account
If this field is blank, the default value is determined by the CTI code as follows:
CTI Code Exchange Fee Default
1, 2 Based on membership designation of executing broker
3 9
4 C
Note: For Clearing Corporation bookkeeping subscribers, the system uses the Margin class classification or the CBOT Broker/ Delegate file to determine the default fee. For options trades, exercises, transfers and adjustments, leave column blank.
|
CB
|
|
132
|
132
|
RESERVED FOR FUTURE USE
|
|
|
|
|
|
133
|
138
|
CTR Card Sequence Number
|
X00100 or 093000
|
AN
|
CME:
CTI = 1,2,3 or 4 = (X ### or - ###)
CBOT:
CTI = 1: Card Sequence = ####
CBOT Approved CTI = 2&4:
Card Sequence Number (X ### or - ###)
All other timing information must be reflected in Regulatory Block R1.
|
CB
|
|
139
|
139
|
Open/Close Indicator
|
O
|
A
|
Open/Close Indicator
CBOT - options trades only
CME - FLEX option trades only
O = Opening Trade
C = Closing (offsetting) trade
X = Closing (offsetting) variable cabinet trade
|
CB
|
|
140
|
145
|
Trade ID Seq. Number
|
002075
|
N
|
Trade record ID assigned by member firm or clearing organization. (right justified, zero filled)
CME:
1 - 64,999 - firm assignment*
65,000 - 81,999 – CME TES assignment
NOTE - On all confirm records with this range of CME assigned trade IDs, this field will be blank. The CME assigned trade ID will appear in the M1 block. The CME will only assign 5 digit Trade Ids.
*GUS/MQM NOTE - For Pending Give-Up MQM records, CME assigns trade Ids beginning in the 50,000 range.
81,000 - 81,999 – FLEX Products System
82,000 - 84,999 - C21 EFP Trade Entry System
85,000 - 89,999 – TOPS assignment
90,000 - 94,999 - ETC assignment
95,000 - 99,999 – GLOBEX trade, GLOBEX GUS and GLOBEX APS
CBOT:
1-59,999 - reserved for BOTCC and/or Firm assignment
60,000 – 74,999 for Project A
75,000 – 79,999 reserved for future use
80,000 – 89,999 Order Route
90,000 – 99,999 AUDIT
|
CB
|
|
146
|
148
|
Trade ID Source Code
|
N/A
|
A
|
CME Source System Code:
B21 = Matched Trade Indicator
ETC = Electronic Trading Card
EFP = Entry via C21 EFP Trade Entry System
FLX = Entry via FLEX Products System
GBX = GLOBEX Matched Trade
GGU = GLOBEX Give-Up System
GUS = RTH Give-Up System
MQM = Firm Back-Office System
TES = Entry via TES (CME Trade Entry System)
TOP = Initiated in TOPS/Route System
CBOT Source Code:
Blank = Firm Back-Office System (via ARCS)
MQM = Firm Back-Office System (via MQM)
OTS = entry via OTIS (BOTCC Trade Entry System)
TOP = from TOPS/Route System
CNF = Confirmation from BOTCC
TPS = from Firm Back-office system which originated
from the TOPS/Route System
PJA = from Project A
EUR = from Eurex
DUG = Giveup Duplication
DUA = APS Duplication
|
CB
|
|
149
|
150
|
Trade ID Cycle Code
|
N/A
|
N
|
RESERVED FOR FUTURE USE
Day of the Month
|
CB
|
|
151
|
152
|
Order Type Code
|
N/A
|
AN
|
Order Type Codes:
S = Stop Order
M = Market Orders
L = Limit Orders
E = Error (CME Rule 551)
C = MOC (Market on Close) Orders
D = DRT Orders
Q = All other Orders
R = Currency LOX (CME Only)
U = All-or-None Pit LOX (CME Only)
X = S&P LOX trades (CME Only)
Z = Rule 527 Liquidation (CME) and Assignment Trades (CBOT Regulation 350.04a)
ETC trades = “Q” only.
|
CB
|
|
153
|
157
|
Floor Broker ID
|
HAN
|
AN
|
Broker for whom the executing broker executed the trade.
CBOT:
This field is used for Origins 3 and 4.
RESERVED FOR FUTURE USE AT THE CME
Not sent on outbound ETC record.
|
B
|
|
158
|
158
|
Cabinet Indicator
|
N/A
|
A
|
N = Regular Trade
Y = Cabinet Trade
|
CB
|
|
159
|
160
|
Transfer/Reason Code
(populated in OTI field)
|
N/A
|
AN
|
CME:
Transfer Reason
A - Error in assignment of account (in-house)
B - Rule 527 Transfers
C - Transfer at the request of a customer (to another firm)
E - Transfer to correct a firm-to-firm error in clearing a trade
F - Transfer for liquidation (offset) for a trade which cleared at the wrong house due to clerical error only
G- GLOBEX Error Trades
I - Customer/House origin transfer due to error
N - Transfer of positions to a newly approved clearing member
T - Transfer due to the merger of two or more clearing members
W - Transfer due to the withdrawal of a clearing member
X- SIMEX trades that liquidate existing positions
Z - Rule 527 - Intra-day liquidations
Not sent on outbound ETC record.
CBOT -
1 - Partially filled working orders
2 - Legging spread or crush orders
3 - Adjusting trade to reflect split fill
Late Submission
Indicates that this trade is excluded from fines or credits assessed by the trade submission incentive program.
|
CB
|
|
161
|
162
|
Opposing Origin Code
|
N/A
|
N
|
Opposing customer or house account
This field is only used for option adjustments..
|
B
|
|
163
|
163
|
Opposing Open/Close Indicator
|
N/A
|
A
|
Opposing trade Open/Close Indicator
O = Opening position on the opposite side of entry
C = Closing (offsetting) position on the opposite side of the entry
This field is only used for option adjustments.
|
B
|
|
164
|
164
|
Cancel Indicator
|
N/A
|
A
|
Automatic Exercise Cancel Indicator = C
|
B
|
|
165
|
167
|
Authorization Code / Trade ID
|
N/A
|
AN
|
Exercise Out-of-Money or Cancel an auto-exercise that is in the money. Authorization Code must reside on the BOTCC database or entry is not accepted.
CBOT: For Trade ID Matching (Modified Contra):
(Use of this field for Trade ID Matching has NOT been scheduled – firms should continue to use Opposite Firm Number, pos. 76-80)
Trade ID Match code must be 2-3 characters, minimum of 2, must contain at least 1 alpha, 1 numeric character.
|
B
|
|
168
|
168
|
APS/GUS Indicator
|
T or F
|
AN
|
Blank = Regular Trade
A = Average Price
G = Give-Up Trade
Not sent on outbound CME/ETC record.
For CBOT Giveup Duplications from BOTCC:
F = From Transfer
T = To Transfer
|
CB
|
|
169
|
173
|
APS Group ID
|
12345
|
AN
|
Unique Group ID that defines a group of trades for price averaging.
Not sent on outbound ETC record.
CBOT -
For Give-up Trades:
Position 169 = "G"
Position 170-172 = Carrying Firm (optional)
For Giveup Memo Add Transactions:
Position 169 = “M”
Position 170-172 = Carrying Firm (optional)
|
CB
|
|
174
|
179
|
Order Execution Time
|
N/A
|
N
|
Execution time of a trade: HHMMSS
CME: For ETC trades only.
|
C
|
|
180
|
184
|
Business Cycle Code
|
RTH
|
AN
|
Trading Session
RTH = Regular Trading hours (CB)
ETH = Electronic (GLOBEX) trading hours (C)
PJD = Project A Day Session (B)
PJA = Project A Afternoon Session (B)
PJO = Project A Overnight Session (B)
EUR = Eurex (B)
|
CB
|