Login Search
 
 
About Us Careers Contact Us Press Center
 
Login
Delivery Info
Open Interest Reports
Web OTIS Access
 
Bulletins
Clearing Member Info
Newsletters
Related Links
 
 
 
 
Clearing Corp Bulletins Printer Friendly Version Printer Friendly Version
REMINDER
VOLUME 20 - BULLETIN #298

TO:

ALL CLEARING MEMBERS

FROM:

BUSINESS SYSTEMS GROUP

DATE:

October 19, 2000

SUBJECT:

APS Duplication via MQM

In conjunction with the conversion to the New Customer Network and the elimination of all RJE processing scheduled for December 1, 2000, the Clearing Corporation has converted the APS give-up duplication file to a TREX record format to be sent via MQM. Production implementation is scheduled for October 20, 2000.

To receive the new APS duplication file to a MQM queue in the TREX record format using MQM messages use the following procedures:

1. From the OTIS main selection menu select Option 14, Give-up and APS trades.

2. From the Give-up and Average Price System selection menu select Option 12, APS Trade Duplication.

3. From the APS Transaction Duplication menu select Option 1, Transaction since last request. This request will send all APS messages since the last time they were requested, to the firm’s MQM queue.

Please see the attached document for the record layout, and note that a special A8 block has been developed for the APS trade duplication. An APS TREX test file has been created, and can be sent to the firms MQM test queue. Firms that would like to receive the test file should contact a Business Systems Analyst.

Should you have any questions, please call or e-mail one of the following Business Systems Analysts:

John Compall

 

john.compall@botcc.com

Shawn Gebbia

786-5748

shawn.gebbia@botcc.com

Marc MacQuarrie

786-5732

marc.macquarrie@botcc.com

Richard Scruggs

786-5739

richard.scruggs@botcc.com

Jill Turner

786-5718

jill.turner@botcc.com

Matt Walsh

 

matt.walsh@botcc.com

Kelli Wegener

786-5761

kelli.wegener@botcc.com

     

Thomas Andrews

Manager

thomas.andrews@botcc.com

Diane Schuering

Vice President

diane.schuering@botcc.com

     

Business Systems Group E-Mail Address

bsg@botcc.com

BOTCC Web Site

http://www.botcc.com

APS DUPES Sample Data

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:

Blank/1 = Pit Trades

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:

Blank = Pit Trades

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)

D - Rule 551 Transfers

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

S - New SIMEX positions

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

SPECIAL BLOCK A2 - CARRY FIRM/EXCHANGE

POSITION

FROM TO

FIELD NAME AND FORM

SAMPLE DATA

FORMAT

DESCRIPTION AND COMMENTS

R-EX

1

2

Block 2

A2

AN

APS/Give-ups/Foreign Exchange Block

CB

3

7

Carry Exchange

N/A

AN

Carrying Organization/Exchange

CME = Chicago Mercantile Exchange

CBT = Chicago Board of Trade

SX = SIMEX (for SIMEX adds, confirms and "B" records)

CB

8

12

Carry Firm/Foreign Firm/CMTA Firm

N/A

AN

Carrying Firm for CME GUS(Give-Ups), CBOT Give-ups or CME/CBOT APS, Executing Firm for CMTA trades, or Foreign Firm (SIMEX)

CB

13

27

Carry Account

CARRYACCT123

AN

Carry Firm Account Number for:

- Single CME (GUS) and CBOT Give-ups or CME/CBOT APS allocations.

- LIFFE receiving firm’s account number for trades executed at CBOT

- TOPS Only: Omnibus Account Number

CB

SPECIAL BLOCK A8 – APS Trade Duplication

</

POSITION

FROM TO

FIELD NAME AND FORM

SAMPLE DATA

FORMAT

DESCRIPTION AND COMMENTS

R-EX

1

2

Block 8

A8

AN

Always A8

B

3

9

Residual Amount

99999.99

N

Residual Amount - 9(5)V99

B

10

14

Series Aps Group Code

ABCDE

AN

Series APS Group Code

B

15

19

APS Plus 5 Value

.99999

N

Fractional portion of APS Plus 5 value, 5 decimal places - V9(5)

B

20

30

APS Plus 5 Average Price

9999.999

N

APS Plus 5 average price, 7 decimal place - 9(4)V(7)

B

31

46

Actual Average Price

99.99

N

Actual Average Price, 9 decimal places - 9(7)V9(9)

B

47

48

Omnibus

AB

AN

Omnibus

B