Drop Copy FIX Spec

This document describes the SpiderRock Drop Copy FIX Gateway. This gateway enables the client or a third party to receive fix messages representing orders and reports sent on a client session. Below are the specs for the application-level messages available to receive on the SpiderRock Drop Copy FIX Gateway. Depending on available information, all tags listed may not appear on the dropped message.

This document is intended to be used in conjunction with the SpiderRock FIX Session Guide which describes session level message handling and other SpiderRock FIX conventions in more detail.

Application Messages

Execution Report

This is the default Execution Report message. The client support desk can aid with any changes.

Tag	FIX Tag Name	Type	Values	Associated Record Field (SpdrParentExecution)	Comments
	Standard Header		MsgType = 8
115	OnBehalfOfCompID	string		execBrkrClFirm	Client/firm at executing broker (if any)
116	OnBehalfOfSubID	string		execBrkrUserName	User name at execution broker (if any)
11	ClOrdID	string		clOrdId	Child order identifier
1	Account	string		accnt execBrkrAccnt	SpiderRock trading accnt account at executing broker (if any)
20	ExecTransType	enum	0 = New 1 = Cancel 2 = Correct	execStatus fillQuantity
150	ExecType	enum	1 = Partial Fill 2 = Filled	execStatus fillQuantity
39	OrdStatus	enum	2 = Filled 5 = Replaced	execStatus fillQuantity
41	OrigClOrdId	string		altPrevOrderId	Client order ID of the original order that is requested to be canceled (24 character max)
35	OrderID	string		streetOrderId	Street side orderId (orderId or equivalent)
54	Side	enum	1 = Buy 2 = Sell 5 = Sell Short 6 = Sell Short Exempt	orderSide childSSaleFlag	Order side Child order position type
114	LocateReqd	bool
5700	LocateBroker	string
38	OrderQty	int		fillQuantity
40	OrdType	enum	1 = Market 2 = Limit Z = LimitOnOpen B = LimitOnClose Y = MarketOnOpen
44	Price	float		fillPrice
47	Rule80A	enum	A = Agency I = Individual P = Principal	lastCapacity	Child order capacity
59	TimeInForce	enum	0 = Day 2 = Opening 7 = Closing	timeInForce
55	Symbol	string		secKey	Stocks, Options, Futures Symbol for the position report
65	SymbolSfx	string		secKey	Stocks Suffix of the symbol for the position report
167	SecurityType	enum	MLEG = MultiLeg CS = Common Stock FUT = Future OPT = Option	secType
200	MaturityMonthYear	string		secKey	Futures, Options The month and year of maturity YYYYMM
205	MaturityDay	int		secKey	Futures, Options Can be used in conjunction with MaturityMonthYear to specify a particular maturity date
202	StrikePrice	float		secKey	Options Strike price of the security
201	PutOrCall	enum	0 = Put 1 = Call	secKey	Options
100	ExDestination	enum	See Fix Session Guide Appendix B	childExDest	Child order exchange destination code
204	CustomerOrFirm	enum	0 = Customer 1 = Firm 2 = BrokerDealer 3 = Broker Dealer Customer 4 = MarketMarker 5 = AwayMarketMarker 8 = ProCustomer J = FirmJBO	firmType	Child order firm type
77	PositionEffect	enum	O = Open C = Close	parentPosType childPosType	Parent order position type Child order position type
439	ClearingFirm	string		clearingFirm	Clearing firm
400	ClearingAccount	string		clearingAccnt	Clearing firm account (if any)
5000	SRParentNumber	string		parentNumber	SpiderRock parent number
5004	SRBaseParentNumber	string		baseParentNumber	SPDR order number (initial number in cancel/replace sequence)
5520	SROrderClass	enum	R = RiskDrop P = Parent	execRole
5036	SRUsername	string		userName	User name associated with the parent order
19	ExecRefID	string		fillNumber/ pExecution.version	If Busted or Corrected
17	ExecID	string		fillNumber	SpiderRock execution number
654	LegRefID	string		fillLegRefId	legRefId for multileg fills
6	AvgPx	float		fillPrice
14	CumQty	int		fillQuantity
151	LeavesQty	int
31	LastPx	float		fillPrice
32	LastQty	int		fillQuantity
30	LastMkt	enum	See Fix Session Guide Appendix B	fillMarket/childExDest
29	LastCapacity	enum	1 = Agent 4 = Principal	lastCapacity
58	Text	string
60	TransactTime	utcTimeStamp		fillTransactDttm	Transaction date/time as reported by exchange or down stream broker
75	TradeDate	date		fillDttm	Trading Date
76	ExecBroker	string		extExecBroker	Downstream destination
5607	SRStreetExecID	string		fillExecId	Street side execution Id
5608	SRStreetExecRefID	string		fillExecRefId	Street side execution ref Id (only used when busting an execution)
442	MultiLegReportingType	enum	3 = MultiLegSecurity		Futures
5602	SRFillNumber	string		fillNumber	SpiderRock execution number
5611	SRExchLiqTag	string		exchLiquidityTag	Liquidity tag as reported by downstream venue (if any)
5610	SRLiquidityTag	string		spdrLiquidityTag	SpiderRock normalized liquidity tag
5619	SRExchFeeEst	float		fillExchFee	SpiderRock estimate of the exchange fee based on liquidity tags (best effort)
5618	SRBillingRate	float		fillBrkrRate /fillRoutingRate	Brokerage rate + routing rate
5360	SRExDestination	string		childExDest	Child order exchange destination code
5627	SRChildShortSaleFlag	enum	1 = Long 2 = Short 3 = Exempt 5 = Open 6 = Close 8 = Cover	childSSaleFlag	Short sale flag
5625	SRChildPositionType	enum	5 = Open 6 = Close	childPosType	Child order position type
5631	SRStreetRoute	string		routingCode	SpiderRock market routing code
5038	SROrderDttm	utc datetime		parentDttm	Parent order creation date/time
5012	SRAltAccnt	string		altAccnt	Alternate (client assigned) account string
5014	SRAltUserName	string		altUserName	Alternate (client assigned) user name
5034	SRStrategy	string		parentStrategy	Client strategy
5009	SRSpdrSource	enum	See SpiderRock Tags Appendix	spdrSource	SpiderRock parent order entry source
5290	SRUserData1	string		userData1	Echoed client supplied data field
5291	SRUserData2	string		userData2	Echoed client supplied data field
	Standard Trailer

New Order Single

This is the default New Order Single message. The client support desk can aid with any changes.

Tag	FIX Tag Name	Type	Values	Associated Record Field (SpdrParentExecution)	Comments
	Standard Header		MsgType = D
115	OnBehalfOfCompID	string		execBrkrClFirm	Client/firm at executing broker (if any)
116	OnBehalfOfSubID	string		execBrkrUserName	User name at execution broker (if any)
1	Account	string		accnt execBrkrAccnt	SpiderRock trading accnt account at executing broker (if any)
21	HandlInst	enum	1 = Automated execution order, private, no Broker intervention 2 = Automated execution order, public, Broker intervention OK 3 = Manual order, best execution		Execution handling instruction (if any) Default value = 1
439	ClearingFirm	string		clearingFirm	Clearing firm
400	ClearingAccount	string		clearingAccnt	Clearing firm account (if any)
11	ClOrdID	string		clOrdId	Child order identifier
5000	SRParentNumber	string		parentNumber	SpiderRock parent number
5004	SRBaseParentNumber	string		baseParentNumber	SPDR order number (initial number in cancel/replace sequence)
5520	SROrderClass	enum	R = RiskDrop P = Parent	execRole
5360	SRExDestination	string		childExDest	Child order exchange destination code
5036	SRUsername	string		userName	User name associated with the parent order
5006	SRAltOrderId	string		altOrderId	Alternate order ID (usually clOrdId from client)
5008	SRGroupingCode	int		groupingCode	SpiderRock parent broker number
5012	SRAltAccnt	string		altAccnt	Alternate (client assigned) account string
5014	SRAltUserName	string		altUserName	Alternate (client assigned) user name
100	ExDestination	enum	See Fix Session Guide Appendix B	childExDest	Child order exchange destination code
60	TransactTime	utcTimeStamp		fillTransactDttm	Transaction date/time as reported by exchange or down stream broker
54	Side	enum	1 = Buy 2 = Sell 5 = Sell Short 6 = Sell Short Exempt	orderSide childSSaleFlag	Order side Child order position type
38	OrderQty	int		fillQuantity
40	OrdType	enum	1 = Market 2 = Limit Z = LimitOnOpen B = LimitOnClose Y = MarketOnOpen
44	Price	float		fillPrice
59	TimeInForce	enum	0 = Day 2 = Opening 7 = Closing	timeInForce
55	Symbol	string		secKey	Stocks, Options, Futures Symbol for the position report
167	SecurityType	enum	MLEG = MultiLeg CS = Common Stock FUT = Future OPT = Option	secType
200	MaturityMonthYear	string		secKey	Futures, Options The month and year of maturity YYYYMM
205	MaturityDay	int		secKey	Futures, Options Can be used in conjunction with MaturityMonthYear to specify a particular maturity date
202	StrikePrice	float		secKey	Options Strike price of the security
201	PutOrCall	enum	0 = Put 1 = Call	secKey	Options
204	CustomerOrFirm	enum	0 = Customer 1 = Firm 2 = BrokerDealer 3 = Broker Dealer Customer 4 = MarketMarker 5 = AwayMarketMarker 8 = ProCustomer J = FirmJBO	firmType	Child order firm type
47	Rule80A	enum	A = Agency I = Individual P = Principal	lastCapacity	Child order capacity
77	PositionEffect	enum	O = Open C = Close	parentPosType childPosType	Parent order position type Child order position type
5034	SRStrategy	string		parentStrategy	Client strategy
5290	SRUserData1	string		userData1	Echoed client supplied data field
5291	SRUserData2	string		userData2	Echoed client supplied data field
	Standard Trailer

New Order Multileg

This is the default New Order Multileg message. The client support desk can aid with any changes.

Tag	FIX Tag Name	Type	Values	Associated Record Field (SpdrParentExecution)	Comments
	Standard Header		MsgType = AB
115	OnBehalfOfCompID	string		execBrkrClFirm	Client/firm at executing broker (if any)
116	OnBehalfOfSubID	string		execBrkrUserName	User name at execution broker (if any)
1	Account	string		accnt execBrkrAccnt	SpiderRock trading accnt account at executing broker (if any)
21	HandlInst	enum	1 = Automated execution order, private, no Broker intervention 2 = Automated execution order, public, Broker intervention OK 3 = Manual order, best execution		Execution handling instruction (if any) Default value = 1
439	ClearingFirm	string		clearingFirm	clearing firm
400	ClearingAccount	string		clearingAccnt	Clearing firm account (if any)
11	ClOrdID	string		clOrdId	Child order identifier
5000	SRParentNumber	string		parentNumber	SpiderRock parent number
5004	SRBaseParentNumber	string		baseParentNumber	SPDR order number (initial number in cancel/replace sequence)
5520	SROrderClass	enum	R = RiskDrop P = Parent	execRole
5360	SRExDestination	string		childExDest	Child order exchange destination code
5036	SRUsername	string		userName	User name associated with the parent order
5006	SRAltOrderId	string		altOrderId	Alternate order ID (usually clOrdId from client)
5008	SRGroupingCode	int		groupingCode	SpiderRock parent broker number
5012	SRAltAccnt	string		altAccnt	Alternate (client assigned) account string
5014	SRAltUserName	string		altUserName	Alternate (client assigned) user name
100	ExDestination	enum	See Fix Session Guide Appendix B	childExDest	Child order exchange destination code
60	TransactTime	utcTimeStamp		fillTransactDttm	Transaction date/time as reported by exchange or down stream broker
54	Side	enum	1 = Buy 2 = Sell 5 = Sell Short 6 = Sell Short Exempt	orderSide childSSaleFlag	Order side Child order position type
38	OrderQty	int		fillQuantity
40	OrdType	enum	1 = Market 2 = Limit Z = LimitOnOpen B = LimitOnClose Y = MarketOnOpen
44	Price	float		fillPrice
59	TimeInForce	enum	0 = Day 2 = Opening 7 = Closing	timeInForce
55	Symbol	string		secType	Stocks, Options, Futures Symbol for the position report
167	SecurityType	enum	MLEG = MultiLeg CS = Common Stock FUT = Future OPT = Option	secType
200	MaturityMonthYear	string		secKey	Futures, Options The month and year of maturity YYYYMM
205	MaturityDay	int		secKey	Futures, Options Can be used in conjunction with MaturityMonthYear to specify a particular maturity date
202	StrikePrice	float		secKey	Options Strike price of the security
201	PutOrCall	enum	0 = Put 1 = Call	secKey	Options
204	CustomerOrFirm	enum	0 = Customer 1 = Firm 2 = BrokerDealer 3 = Broker Dealer Customer 4 = MarketMarker 5 = AwayMarketMarker 8 = ProCustomer J = FirmJBO	firmType	Child order firm type
47	Rule80A	enum	A = Agency I = Individual P = Principal	lastCapacity	Child order capacity
555	NoLegs	int			Number of leg repeating groups
	Leg Repeating Group
601	LegSymbolSfx	string	WI = When Issued for a security to be reissued under an old CUSIP or ISIN CD = a EUCP with lump-sum interest rather than discount price		Used to construct child order seckey
600	LegSymbol	string		Used to construct child order seckey
608	LegCFICode	string		Used to construct child order seckey
654	LegRefId	hexlong		OrderLegsItem.stockLegId or OrderLegsItem.LegIdN (where N is NoLegs #)	Unique indicator for specific leg
623	LegRatioQty	float		OrderLegsItem.multN (where N is NoLegs #)
624	LegSide	char	1 = Buy 2 = Sell 5 = Sell Short Y = Sell Short Auto 6 = Sell Short Exempt	OrderLegsItem.sideN (where N is NoLegs #)
611	LegMaturityDate	LocalMktDate		Used to construct child order seckey	Options
612	LegStrikePrice	float		Used to construct child order seckey	Options
564	LegPositionEffect	char	O = Open C = Close R = Rolled F = FIFO	OrderLegsItem.posTypeN (where N is NoLegs #)	Options
	End of Leg Repeating Group
5034	SRStrategy	string		parentStrategy	Client strategy
5290	SRUserData1	string		userData1	Echoed client supplied data field
5291	SRUserData2	string		userData2	Echoed client supplied data field
	Standard Trailer

Order Cancel Request

This is the default Order Cancel Request message. The client support desk can aid with any changes.

Tag	FIX Tag Name	Type	Values	Associated Record Field (SpdrParentExecution)	Comments
	Standard Header		MsgType = F
115	OnBehalfOfCompID	string		execBrkrClFirm	Client/firm at executing broker (if any)
116	OnBehalfOfSubID	string		execBrkrUserName	User name at execution broker (if any)
1	Account	string		accnt execBrkrAccnt	SpiderRock trading accnt Account at executing broker (if any)
21	HandlInst	enum	1 = Automated execution order, private, no Broker intervention 2 = Automated execution order, public, Broker intervention OK 3 = Manual order, best execution		Execution handling instruction (if any) Default value = 1
11	ClOrdID	string		clOrdId	Child order identifier
37	OrderID	string
41	OrigClOrdId	string		altPrevOrderId	Client order ID of the original order that is requested to be canceled (24 character max)
100	ExDestination	enum	See Fix Session Guide Appendix B	childExDest	Child order exchange destination code
60	TransactTime	utcTimeStamp		fillTransactDttm	Transaction date/time as reported by exchange or down stream broker
54	Side	enum	1 = Buy 2 = Sell 5 = Sell Short 6 = Sell Short Exempt	orderSide childSSaleFlag	Order side Child order position type
38	OrderQty	int		fillQuantity
40	OrdType	enum	1 = Market 2 = Limit Z = LimitOnOpen B = LimitOnClose Y = MarketOnOpen
44	Price	float		fillPrice
55	Symbol	string		secKey	Stocks, Options, Futures Symbol for the position report
167	SecurityType	enum	MLEG = MultiLeg CS = Common Stock FUT = Future OPT = Option	secType
200	MaturityMonthYear	string		secKey	Futures, Options The month and year of maturity YYYYMM
205	MaturityDay	int		secKey	Futures, Options Can be used in conjunction with MaturityMonthYear to specify a particular maturity date
202	StrikePrice	float		secKey	Options Strike price of the security
201	PutOrCall	enum	0 = Put 1 = Call	secKey	Options
47	Rule80A	enum	A = Agency I = Individual P = Principal	lastCapacity	Child order capacity
204	CustomerOrFirm	enum	0 = Customer 1 = Firm 2 = BrokerDealer 3 = Broker Dealer Customer 4 = MarketMarker 5 = AwayMarketMarker 8 = ProCustomer J = FirmJBO	firmType	Child order firm type
311	UnderlyingSymbol	string			Symbol of underlying security to derivative product
439	ClearingFirm	string		clearingFirm	Clearing firm
400	ClearingAccount	string		clearingAccnt	Clearing firm account (if any)
5000	SRParentNumber	string		parentNumber	SpiderRock parent number
5004	SRBaseParentNumber	string		baseParentNumber	SPDR order number (initial number in cancel/replace sequence)
5009	SRSpdrSource	enum	See SpiderRock Tags Appendix	spdrSource	SpiderRock parent order entry source
5014	SRAltUserName	string		altUserName	Alternate (client assigned) user name
5015	SRSecKey	string		secKey	Execution security key
5016	SRSecType	enum	1 = Stock 2 = Future 3 = Option 4 = Mleg	secType	Execution security type
5017	SRAssetType	enum	1 = EQT 2 = IDX 3 = BND 4 = CUR 5 = COM 6 = FUT 7 = SYN 8 = WAR 9 = FLX 10 = MUT 11 = SPD 12 = MM 13 = MF 14 = COIN 15 = TOKEN 16 = ANY	secKey_at
5018	SRTickerSrc	enum	See SpiderRock Fix Tags below	secKey
5036	SRUsername	string		userName	User name associated with the parent order
5340	SROrderShape	enum	0 = Single 1 = Cross 2 = MLeg 3 = MLegCross	parentShape
5360	SRExDestination	string		childExDest	Child order exchange destination code
5520	SROrderClass	enum	R = RiskDrop P = Parent	execRole
5601	SRBaseClOrdID	long
5250	SRRiskGroupId	int		riskGroupId	riskGroupId (parent order group ID) for this execution report
5034	SRStrategy	string		parentStrategy	Client strategy
5290	SRUserData1	string		userData1	Echoed client supplied data field
5291	SRUserData2	string		userData2	Echoed client supplied data field
	Standard Trailer

Multileg Order Cancel Replace

This is the default Multileg Order Cancel Replace message. The client support desk can aid with any changes.

Tag	FIX Tag Name	Type	Values	Associated Record Field (SpdrParentExecution)	Comments
	Standard Header		MsgType = AC
115	OnBehalfOfCompID	string		execBrkrClFirm	Client/firm at executing broker (if any)
116	OnBehalfOfSubID	string		execBrkrUserName	User name at execution broker (if any)
1	Account	string		accnt execBrkrAccnt	SpiderRock trading accnt account at executing broker (if any)
21	HandlInst	enum	1 = Automated execution order, private, no Broker intervention 2 = Automated execution order, public, Broker intervention OK 3 = Manual order, best execution		Execution handling instruction (if any) Default value = 1
439	ClearingFirm	string		clearingFirm	Clearing firm
400	ClearingAccount	string		clearingAccnt	Clearing firm account (if any)
11	ClOrdID	string		clOrdId	Child order identifier
5000	SRParentNumber	string		parentNumber	SpiderRock parent number
5004	SRBaseParentNumber	string		baseParentNumber	SPDR order number (initial number in cancel/replace sequence)
5520	SROrderClass	enum	R = RiskDrop P = Parent	execRole
5360	SRExDestination	string		childExDest	Child order exchange destination code
5036	SRUsername	string		userName	User name associated with the parent order
5006	SRAltOrderId	string		altOrderId	Alternate order ID (usually clOrdId from client)
5008	SRGroupingCode	int		groupingCode	SpiderRock parent broker number
5012	SRAltAccnt	string		altAccnt	Alternate (client assigned) account string
5014	SRAltUserName	string		altUserName	Alternate (client assigned) user name
100	ExDestination	enum	See Fix Session Guide Appendix B	childExDest	Child order exchange destination code
60	TransactTime	utcTimeStamp		fillTransactDttm	Transaction date/time as reported by exchange or down stream broker
54	Side	enum	1 = Buy 2 = Sell 5 = Sell Short 6 = Sell Short Exempt	orderSide childSSaleFlag	Order side Child order position type
38	OrderQty	int		fillQuantity
40	OrdType	enum	1 = Market 2 = Limit Z = LimitOnOpen B = LimitOnClose Y = MarketOnOpen
44	Price	float		fillPrice
59	TimeInForce	enum	0 = Day 2 = Opening 7 = Closing	timeInForce
55	Symbol	string		secKey	Stocks, Options, Futures Symbol for the position report
167	SecurityType	enum	MLEG = MultiLeg CS = Common Stock FUT = Future OPT = Option	secType
200	MaturityMonthYear	string		secKey	Futures, Options The month and year of maturity YYYYMM
205	MaturityDay	int		secKey	Futures, Options Can be used in conjunction with MaturityMonthYear to specify a particular maturity date
202	StrikePrice	float		secKey	Options Strike price of the security
201	PutOrCall	enum	0 = Put 1 = Call	secKey	Options
204	CustomerOrFirm	enum	0 = Customer 1 = Firm 2 = BrokerDealer 3 = Broker Dealer Customer 4 = MarketMarker 5 = AwayMarketMarker 8 = ProCustomer J = FirmJBO	firmType	Child order firm type
47	Rule80A	enum	A = Agency I = Individual P = Principal	lastCapacity	Child order capacity
555	NoLegs	int			Number of leg repeating groups
	Leg Repeating Group
601	LegSymbolSfx	string	WI = When Issued for a security to be reissued under an old CUSIP or ISIN CD = a EUCP with lump-sum interest rather than discount price		Used to construct child order seckey
600	LegSymbol	string		Used to construct child order seckey
608	LegCFICode	string		Used to construct child order seckey
654	LegRefId	hexlong		OrderLegsItem.stockLegId or OrderLegsItem.LegIdN (where N is NoLegs #)	Unique indicator for specific leg
623	LegRatioQty	float		OrderLegsItem.multN (where N is NoLegs #)
624	LegSide	char	1 = Buy 2 = Sell 5 = Sell Short Y = Sell Short Auto 6 = Sell Short Exempt	OrderLegsItem.sideN (where N is NoLegs #)
611	LegMaturityDate	LocalMktDate		Used to construct child order seckey	Options
612	LegStrikePrice	float		Used to construct child order seckey	Options
564	LegPositionEffect	char	O = Open C = Close R = Rolled F = FIFO	OrderLegsItem.posTypeN (where N is NoLegs #)	Options
	End of Leg Repeating Group
5034	SRStrategy	string		parentStrategy	Client strategy
5290	SRUserData1	string		userData1	Echoed client supplied data field
5291	SRUserData2	string		userData2	Echoed client supplied data field
	Standard Trailer

Order Cancel Replace Request

This is the default Order Cancel Replace Request message. The client support desk can aid with any changes.

Tag	FIX Tag Name	Type	Values	Associated Record Field (SpdrParentExecution)	Comments
	Standard Header		MsgType = G
115	OnBehalfOfCompID	string		execBrkrClFirm	Client/firm at executing broker (if any)
116	OnBehalfOfSubID	string		execBrkrUserName	User name at execution broker (if any)
1	Account	string		accnt execBrkrAccnt	SpiderRock trading accnt account at executing broker (if any)
21	HandlInst	enum	1 = Automated execution order, private, no Broker intervention 2 = Automated execution order, public, Broker intervention OK 3 = Manual order, best execution		Execution handling instruction (if any) Default value = 1
439	ClearingFirm	string		clearingFirm	Clearing firm
400	ClearingAccount	string		clearingAccnt	Clearing firm account (if any)
11	ClOrdID	string		clOrdId	Child order identifier
41	OrigClOrdId	string		altPrevOrderId	Client order ID of the original order that is requested to be canceled (24 character max)
5000	SRParentNumber	string		parentNumber	SpiderRock parent number
5004	SRBaseParentNumber	string		baseParentNumber	SPDR order number (initial number in cancel/replace sequence)
5520	SROrderClass	enum	R = RiskDrop P = Parent	execRole
5360	SRExDestination	string		childExDest	Child order exchange destination code
5036	SRUsername	string		userName	User name associated with the parent order
5006	SRAltOrderId	string		altOrderId	Alternate order ID (usually clOrdId from client)
5008	SRGroupingCode	int		groupingCode	SpiderRock parent broker number
5012	SRAltAccnt	string		altAccnt	Alternate (client assigned) account string
5014	SRAltUserName	string		altUserName	Alternate (client assigned) user name
100	ExDestination	enum	See Fix Session Guide Appendix B	childExDest	Child order exchange destination code
60	TransactTime	utcTimeStamp		fillTransactDttm	Transaction date/time as reported by exchange or down stream broker
54	Side	enum	1 = Buy 2 = Sell 5 = Sell Short 6 = Sell Short Exempt	orderSide childSSaleFlag	Order side Child order position type
38	OrderQty	int		fillQuantity
40	OrdType	enum	1 = Market 2 = Limit Z = LimitOnOpen B = LimitOnClose Y = MarketOnOpen
44	Price	float		fillPrice
59	TimeInForce	enum	0 = Day 2 = Opening 7 = Closing	timeInForce
55	Symbol	string		secKey	Stocks, Options, Futures Symbol for the position report
167	SecurityType	enum	MLEG = MultiLeg CS = Common Stock FUT = Future OPT = Option	secType
200	MaturityMonthYear	string		secKey	Futures, Options The month and year of maturity YYYYMM
205	MaturityDay	int		secKey	Futures, Options Can be used in conjunction with MaturityMonthYear to specify a particular maturity date
202	StrikePrice	float		secKey	Options Strike price of the security
201	PutOrCall	enum	0 = Put 1 = Call	secKey	Options
204	CustomerOrFirm	enum	0 = Customer 1 = Firm 2 = BrokerDealer 3 = Broker Dealer Customer 4 = MarketMarker 5 = AwayMarketMarker 8 = ProCustomer J = FirmJBO	firmType	Child order firm type
47	Rule80A	enum	A = Agency I = Individual P = Principal	lastCapacity	Child order capacity
77	PositionEffect	enum	O = Open C = Close	parentPosType childPosType	Parent order position type Child order position type
5034	SRStrategy	string		parentStrategy	Client strategy
5290	SRUserData1	string		userData1	Echoed client supplied data field
5291	SRUserData2	string		userData2	Echoed client supplied data field
	Standard Trailer

SpiderRock Defined FIX Tags

SpiderRock defined tags are available for execution drop reports. Below are the most relevant for a Drop Copy. See SpiderRock Tags Appendix for more information.

Tag	FIX Tag Name	Type	Values	Associated Record Field	Comments
5000	SRParentNumber	string		parentNumber	SpiderRock parent number
5004	SRBaseParentNumber	string		baseParentNumber	SPDR order number (initial number in cancel/replace sequence)
5006	SRAltOrderId	string		altOrderId	Alternate order ID (usually clOrdId from client)
5008	SRGroupingCode	int		groupingCode	SpiderRock parent broker number
5009	SRSpdrSource	enum	See SpiderRock Tags Appendix	spdrSource	SpiderRock parent order entry source
5012	SRAltAccnt	string		altAccnt	Alternate (client assigned) account string
5014	SRAltUserName	string		altUserName	Alternate (client assigned) user name
5015	SRSecKey	string		secKey	Execution security key
5016	SRSecType	enum	1 = Stock 2 = Future 3 = Option 4 = Mleg	secType	Execution security type
5017	SRAssetType	enum	See SpiderRock Tags Appendix	secKey
5018	SRTickerSrc	enum	See SpiderRock Tags Appendix	secKey_ts
5020	SRAccnt	string		accnt	SpiderRock trading account
5022	SRClientFirm	string		clientFirm	SR client firm
5024	SRClearingFirm	string		clearingFirm	Clearing firm
5026	SRClearingAccnt	string		clearingAccnt	Clearing firm account (if any)
5034	SRStrategy	string		parentStrategy	Client strategy
5036	SRUsername	string		userName	User name associated with the parent order
5038	SROrderDttm	utc datetime		parentDttm	Parent order creation date/time
5040	SROrderSide	enum	B = Buy S = Sell	orderSide	Order side
5094	SROrderHandling	enum	1 = ActiveTaker 2 = PostOnly 3 = DMA 4 = MktOnOpn 5 = MktOnCls 8 = Legger 9 = Seeker 10 = SeekerLegger 11 = CrossResponse 12 = AuctionResponse 13 = AwayAlgo 14 = ExchPing 19 = SweepTake 20 = CobMaker 21 = TestParent 22 = BlockAuction 23 = BlockResponse 24 = Matrix	parentOrderHandling	Primary/Take Algo Handler
5096	SRBalanceHandling	enum	1 = PostWith 2 = PostTurn 3 = PostImprove 4 = PostLimit 6 = MaxIntern 7 = PostWthF 8 = PostImprvR 9 = PostFlash 10 = PostFlashW 11 = PostPeg 12 = PostFlashI	parentBalanceHandling	Make Algo Handler
5152	SRAutoHedge	enum	N = NoHedge X = FastCrx Y = FastDrk Z = SlowDrk F = AutoCrx S = AutoTrn M = AutoMid A = SpdrAuto 1 = Spdr10S 3 = Spdr30S 9 = Spdr90S 5 = Spdr5M H = Spdr30M D = SpdrDay V1 = AlphaVwap1pct V2 = AlphaVwap2pct V5 = AlphaVwap5pct V25 = AlphaVwap25pct T = Static	autoHedge	Auto = hedge algorithm (if any)
5166	SRFirmType	enum	C = Customer F = Firm MM = MarketMaker PC = ProCustomer BD = BrokerDealer AwayMM = AwayMM JBO = FirmJBO BDC = BrkrDlrCust	firmType	Child order firm type
5168	SROrderCapacity	enum	A = Agency P = Principal I = Individual PR = Proprietary AOM = AgentOtherMember	lastCapacity	Child order capacity
5170	SRPositionType	enum	7 = Auto 5 = Open 2 = Close	parentPosType	Parent order position type
5172	SRShortSaleFlag	enum	1 = Long 2 = Short 3 = Exempt 4 = Auto 5 = Open 6 = Close 8 = Cover 7 = NA 8 = Cover	parentSSaleFlag	Short sale flag on parent order
5250	SRRiskGroupId	int		riskGroupId	Risk group ID (parent order group ID) for this execution report
5290	SRUserData1	string		userData1	Echoed client supplied data field
5291	SRUserData2	string		userData2	Echoed client supplied data field
5296	SRChildOrderPrice	float		childPrice	Child order price
5302	SRLegIndex	int			Leg of a spread order if MultiLegReportingType is MultiLegSecurity(3)
5340	SROrderShape	enum	0 = Single 1 = Cross 2 = MLeg 3 = MLegCross	parentShape
5342	SRExecShape	enum	1 = Single 2 = Mleg (Top) 3 = Mleg Leg 4 = Spread (Top) 5 = Spread Leg 6 = Single Leg	execShape
5350	SRExecBrokerMPID	string		execBrkrMPID	FINRA/Assigned exec broker MPID (if any)
5351	SRExecBrokerCode	string		execBrkrCode	SR Assigned executing broker code
5352	SRExecBrokerAccnt	string		execBrkrAccnt	Account at executing broker (if any)
5353	SRExecBrokerClFirm	string		execBrkrClFirm	Client/firm at executing broker (if any)
5360	SRExDestination	string		childExDest	Child order exchange destination code
5400	SRContractMultiplier	int		underliersPerCn	Option delivery underliers per contract
5411	SRExecUsername	string		execBrkrUserName	User name at execution broker (if any)
5520	SROrderClass	enum	R = RiskDrop P = Parent	execRole
5601	SRBaseClOrdID	long
5602	SRFillNumber	string		fillNumber	SpiderRock execution number
5607	SRStreetExecID	string		fillExecId	Street side execution Id
5608	SRStreetExecRefID	string		fillExecRefId	Street side execution ref Id (only used when busting an execution)
5610	SRLiquidityTag	string		spdrLiquidityTag	SpiderRock normalized liquidity tag
5611	SRExchLiqTag	string		exchLiquidityTag	Liquidity tag as reported by downstream venue (if any)
5612	SRExchangeFillDetails	string		fillExchDetail	Other FIX tags from downstream venue
5618	SRBillingRate	float		fillBrkrRate fillRoutingRate	Brokerage rate + routing rate
5619	SRExchFeeEst	float		fillExchFee	SpiderRock estimate of the exchange fee based on liquidity tags (best effort)
5625	SRChildPositionType	enum	5 = Open 6 = Close	childPosType	Child order position type
5627	SRChildShortSaleFlag	enum	1 = Long 2 = Short 3 = Exempt 5 = Open 6 = Close 8 = Cover	childSSaleFlag	Short sale flag
5631	SRStreetRoute	string		routingCode	SpiderRock market routing code
5648	SRBillingCategory	enum	A = Alpha A50 = AlphaTop50 TM = TiedMaker TT = TiedTaker S = SOR D = DMA AR = AuctionResponse BA = BlockAuction BR = BlockResponse F = Facilitate AF = AlphaFacilitate AT = AwayTrade SO = SymOverride E = Extern NB = NonBillable IS = IsoSweep SS = SpdrSweep SK = Seeker LEG = Legger AD = Drop AA = AwayAlgo G = GTH AG = AlphaGTH	billingCategory
5663	SRReportDetail	string		fillReportDetail	Extra detail (if any) from child execution
5690	SRUBidPx	float		fillUBid	Underlier market bid at fill arrival
5691	SRUAskPx	float		fillUAsk	Underlier market ask at fill arrival
5692	SRUBidSz	float		fillUBidSz	Underlier bid size at fill arrival
5693	SRUAskSz	float		fillUAskSz	Underlier ask size at fill arrival
5999	SRChildOrderHandling	string		childOrderHandling	Child order handling string from the algo that generated the child order responsible for this fill