Page tree
Skip to end of metadata
Go to start of metadata

Database Schema

ICE-to-Database mapping

Tables description

Table: ICEReports

Usage: Table holds summary of reported trades.

Fields

Name

FIX tag

Req’d

Description

TradeReportID


571

Y

Key field. Unique ID of Trade Capture Report

SendingTime

52


Y

Key field. Date and time when report was received.

Format: YYYYMMDD-HH:MM:SS

UniqueTradeID-Y

Key field. Together with TradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

TradeReportTransType                       


487

Y

Identifies Trade Report message transaction type.

Valid value:

0 = New

TradeReportType                               


856

N

Type of Trade Report.

Valid value:

0  = Submit

TrdType                                 


828

N

Type of trade.


ExecType       

150

N

ExecType will be equal to ‘NULL’ in case of live updates sent from ICE.

Valid values:

5 = Replace

F =  Trade (partial fill or fill)

H =  Trade Cancel

Please note:  it is possible to get a duplicate trade capture report with an ExecType of 5 even if nothing has changed on your side of the trade!

ExecID                                   


17

Y

Exchange Deal ID

OrigTradeID

1126

N

Original trade ID present only on the trades resulting from bust/adjust and containing the DealID of the original trade that was bust/adjusted

GroupIndicator

9820

N

Used to identify legs of spread deals brokered in WebICE TR

TradeLinkMktID

9414

N

Market id that links the futures market to the OTC market

OrdStatus                               


39

N

Identifies current status of order.

Valid values:

2 = Filled

4 = Cancelled

PreviouslyReported                           


570

Y

Indicates if the trade capture report was previously reported to the counterparty.

Valid values: N, Y

Symbol           


55

Y

MarketID (Symbol) needed to submit orders

SecurityID                             


48

N

Contract identifier/symbol.


SecurityIDSource                  


22

C

Exist only if SecurityID exists.

Valid value: 8

SecurityExchange

207

N

Exchange MIC Code

TradeLinkID

820

N

Deal id that links the futures market trade to the OTC market trade.

NOTE: The TransactTime (tag 60) for both the futures and OTC trade will be the same.

CFICode

                                   


461

Y


OptionsSymbol          

9403

N

Market id of the predefined option market. This tag is useful because for option trades, tag 55 will still contain the underlying Futures market id. This tag is optional because option markets hosted on our older trading engines don’t have any pre-configured marketIDs.

StrikePrice


202

N

Strike price of the option.

Required if  CFICode = ‘OCXXXX’ or ‘OPXXXX’

StartDate

916

N

In format, YYYYMMDD, used to report custom strips on bilateral trades. Please note for Endex Spot markets use DeliveryStartDate


EndDate


917

N

In format, YYYYMMDD, used to report custom strips on bilateral trades. Please note for Endex Spot markets use DeliveryEndDate

DeliveryStartDate

9520

N

Format will be based on UTCTimestamp with variation possible based on product. Accepted values include YYYYMMDD-HH:MM:SS and YYYMMDD-HH:MM:SS.sss

DeliveryEndDate


9521

N

Format will be based on UTCTimestamp with variation possible based on product. Accepted values include YYYYMMDD-HH:MM:SS and YYYMMDD-HH:MM:SS.sss

LocationCode

9522

N

Endex specific: Only populated for OCM Locational markets

MeterNumber

9523

N

Endex specific: Only populated for OCM Locational markets

LeadTime

9524

N

Endex specific: Only populated for OCM Locational markets

ReasonCode

9525

N

Endex specific: Only populated for OCM Locational markets

LastQty          

32

Y

Value of trade quantity

LastPx            

31

Y

Price of this (last) fill

TradeDate

75

Y

Indicates date of trade occurred in YYYYMMDD format

TransactTime                          

60

Y

Indicates time of trade occurred,

Format: HH:MI:SS.000

NumOfLots   

9018

Y

Trade quantity represented in number of lots

NumOfCycles

9022

Y

Remaining days left to a flow contract

NoSides         

552

Y

Total number of sides.
Will always be equal to 1

NoLegs

555

N

Total number of trade spread legs added into this report

ClientAppType

9413

N

Identifies the source which generated the current FIXTC report.

ExchangeSilo

9064

N

Identifies the Exchange Silo of a market.

Valid Values:

0= ICE

1= Endex

2= Liffe

SecuritySubType

762

N

Reserved for future use. Contains the strategy code for the UDS where applicable.

Valid Values:

https://www.theice.com/publicdocs/technology/ICE_Strategy_Code_Reference_Manual.pdf

TermsQualityComments

9510

N

Terms of Platts deal

TradeRequestID568NTradeRequestID of the Trade Capture Report Request.
LastParPx669CCDS and IRS Futures Price: The CDS or IRS Futures price of this fill.
SequenceWithinMillis9028NSequence of the message within the millisecond. SequenceWithinMillis / 1000 = # of microseconds. Please note that the last 3 digits are sequence numbers within the microsecond (not nanoseconds).
NumOfCombiDefinitions9500

WaiverIndicator8013CMiFID waiver indicator on off-exchange deals in MiFID-regulated markets and products.
DirectElectronicAccess9700C

Only required for MiFID II related markets when MIFIDID (Tag 9707) is not provided.
Supported value(s):
0 = False
1 = True

TradingCapacity9701C

Only required for MiFID II related markets when MIFIDID (Tag 9707) is not provided.
Supported value(s):
0 = DEAL (own account)
1 = MTCH (matched principal)
2 = AOTC (any other capacity)

LiquidityProvision9702C

Only required for MiFID II related markets when MIFIDID (Tag 9707) is not provided.
Supported value(s):
0 = False
1 = True

CommodityDerivIndicator9703N

Optional for MiFID II related markets when MIFIDID (Tag 9707) is not provided.
Supported value(s):
0 = False (Default if not sent)
1 = True

InvestmentDecision9704CMust be > 0. Maximum value of 9,223,372,036,854,775,807. Only required for MiFID II related markets when MIFIDID (Tag 9707) is not provided and TradingCapacity (Tag 9701) = ‘0’.
ExecutionDecision9705CMust be > 0. Maximum value of 9,223,372,036,854,775,807. Only required for MiFID II related markets when MIFIDID (Tag 9707) is not provided.
ClientIDCode9706CMust be > 0. Maximum value of 9,223,372,036,854,775,807. Only required for MiFID II related markets when MIFIDID (Tag 9707) is not provided and TradingCapacity (Tag 9701) = ‘1’ or ‘2’.
MiFIDID9707CMust be > 0. Maximum value of 9,223,372,036,854,775,807. Only required for MiFID II related markets when Tags 9700-9706 are not provided. Please note that this field (in lieu of 9700-9706) will be the only MiFID-related field processed if sent.

Table: ICEReportsSides

Usage: Table holds information about side of a reported trade. For each Trade Capture Report there will be one record in ICEReportsSides table.

Fields

Name

FIX tag

Req’d

Description

TradeReportID


571

Y

Key field. Unique ID of Trade Capture Report.

SendingTime

52

Y

Key field. Date and time when report was received.

Format: YYYYMMDD-HH:MM:SS

SideEntry


-

Y

Key field. Together with TradeReportID and SendingTime identifies unique side of each report

UniqueTradeID-Y

Key field. Together with TradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

Side

                                   


54

Y

Trade side.

Valid values:

1 = Buy

2 = Sell

OrderID

37

Y

Exchange OrderID

ClOrdID


11

N

Client OrderID

Text

58

N


CustOrderHandlingInst

1031

N

The CustOrderHandlingInst is used to mark deals with a value that determines how counterparty will be billed. This is only applicable to Griffin market types. Earlier Billing Code

ComplianceID

376

N

Unique Swap Identifier

NoParties


453

N

Number of Parties

AllocAccount

79

N

Allocation Account

Only if 78>0

PositionEffect

77

N

Valid Values:

O (Open)

C (Close)

MemoField

9121

N


TransactDetails

9123

N


CrossExecutionType9405N

Indicates the type of deal derived from a new order cross.
Supported value(s):
0 = Basic Crossing Order

NoNestedPartyIDs756NNumber of party roles.

Table: ICEReportsSidesParties

Usage: Table holds parties associated with certain side of reported trade. For each Trade Capture Report number of records in ICEReportdSidesParties table will be equal to value of NoParties in the correspondent record in ICEReportdSides table.

Fields

Name

FIX tag

Req’d

Description

TradeReportID


571

Y

Key field. Unique ID of Trade Capture Report.

SendingTime

52


Y

Key field. Date and time when report was received.

Format: YYYYMMDD-HH:MM:SS

SideEntry

-

Y

Key field. Together with TradeReportID and SendingTime identifies unique side entry of each report

PartyEntry

-

Y

Key field. Together with TradeReportID, SendingTime and SideEntry identifies unique party of each report

UniqueTradeID-Y

Key field. Together with TradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

PartyID

448

Y

PartyID

PartyIDSource


447

Y

Valid value: D (Proprietary/Custom code)

PartyRole

452

Y


Table: ICEReportsSidesAllocsPty

Usage: Table is used for allocation party details associated with certain side of reported trade. For each Trade Capture Report number of records in ICEReportdSidesAllocsPty table will be equal to value of NoNested2PartyIDS in correspondent record in ICEReportdSides table.

Fields

Name

FIX tag

Req’d

Description

TradeReportID


571

Y

Key field. Unique ID of Trade Capture Report.

SendingTime

52

Y

Key field. Date and time when report was received.

Format: YYYYMMDD-HH:MM:SS

SideEntry

-

Y

Key field. Together with TradeReportID and SendingTime identifies unique side entry of each report

UniqueTradeID-Y

Key field. Together with TradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

Nested2PartyEntry

-

Y

Key field. Together with TradeReportID, SendingTime and SideEntry identifies unique nested party of each report

Nested2PartyID

757

Y

Nested Party ID

Nested2PartyIDSource


758

Y

Valid value: D (Proprietary/Custom code)

Nested2PartyRole

759

Y

Clearing firm = 4

Give up type = 62

Only if 756>0

Table: ICEReportsLegs

Usage: Table holds details of individual leg of multileg instrument (user defined strategy) associated with reported trade. For each Trade Capture Report number of records in ICEReportsLegs table will be equal to value of NoLegs in correspondent record in ICEReports table.

Fields

Name

FIX tag

Req’d

Description

TradeReportID


571


Key field.Unique ID of Trade Capture Report.

SendingTime

52


Y

Key field. Date and time when report was received.
Format: YYYYMMDD-HH:MM:SS

LegsEntry

-


Key field. Together withTradeReportID and SendingTime identifies unique leg of each report

UniqueTradeID-Y

Key field. Together withTradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

LegSymbol     


600

Y

Leg MarketID (Symbol)

LegSecurityID                                   


602

N

Contract identifier/symbol

LegSecurityIDSource


603

N


LegCFICode

608

Y


LegStrikePrice                       


612

N

Strike price of option leg

Required if LegCFICode = ‘OPXXXX’ or ‘OCXXXX’

LegSide                                  


624

Y

Side of a leg. Valid values:

1 = Buy

2 = Sell

LegLastPx


637

Y

Value of leg trade quantity

LegQty           

687

Y

Price of this (last) leg fill

LegOptionRatio

1017

N

Contains the hedge ratio value in percentage

LegRefID

654

Y

Leg TradeID

LegNumOfLots


9019

Y

Spread leg quantity represented innumberof lots

LegNumofCycles

9023

Y


LegStartDate

9020


Y

Start date for the leg markets

LegEndDate


9021

Y

End date for the leg markets

LegComplianceID

9376

N

Unique Swap Identifier or Unique Trade Identifier

NoNestedParties

539

N

Number of nested parties for the leg.

LegSecurityExchange

616

N

Exchange MIC

LegOptionSymbol

9404

N

Exist only if tis leg is option leg

LegCustOrderHandlingInst

9426


N

Supported value(s):

S = Sleeve
M = Originator
T = Aggressor

LegMemoField

9122

N


LegParPx9669CCDS and IRS Futures Price: The CDS or IRS Futures price of this fill.
LinkExecID9527CExists on leg fillsofstrategy trades and contains the LegRefID (Tag 654) of the intermediate spread fill.

Table: ICEReportsLegsNestedPty

Usage: Table holds parties associated with individual leg of reported multileg trade. For each Trade Capture Report number of records in ICEReportsLegsNestedPty table will be equal to value of NoNestedParties in correspondent record in ICEReportsLegs table.

Fields

Name

FIX tag

Req’d

Description

TradeReportID


571

Y

Key field. Unique ID of Trade Capture Report.

SendingTime

52


Y

Key field. Date and time when report was received.
Format: YYYYMMDD-HH:MM:SS

LegsEntry                              


-

Y

Key field. Together with TradeReportID and SendingTime identifies unique nested party of each report

UniqueTradeID


Y

Key field. Together with TradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

NestedPartyEntry

-

Y

Key field. Together with TradeReportID and SendingTime identifies unique nested party of each report

NestedPartyID

524

Y

Nested PartyId

NestedPartyIDSource

525

Y

Valid value: D (Proprietary/Custom code)

NestedPartyRole

538

Y


Table: ICEReportsCombiDefinitions

Usage: Table holds contents of CombiDefinitions repeating groups.

Fields

Name

FIX tag

Req’d

Description

TradeReportID

571

Y

Key field. Unique ID of Trade Capture Report.


SendingTime

54 (Side)

Y

Key field. Date and time whenreport was received.

Format: YYYYMMDD-HH:MM:SS

UniqueTradeID


Y

Key field. Together with TradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

CombiDefEntry

-

Y

Key field. Numeric identifier of the CombiDefinitions group entry.

CombiPercentage

9501

N

Repeating group used to convey Platts specific combi fields.

CombiPriceBasis

9502

N

Returns the pricing basis for Platts combi deals.

CombiPriceBasisPeriod

9503

N

Returns the Platts basis period ex: Full month, quarter, 5 days, etc.

CombiPriceBasisSubLevel

9504

N

Returns the selectedsub level.

CombiLegPrice

9505

N

Returns the price of the combi leg.

Table: Sent_Messages_ICE

Usage: Table is used to exclude potential duplicates and build triggers for further data base messages processing        

Fields

Name

FIX tag

Req’d

Description

SendingTime

52 (SendingTime)



Y

Key field. Date and time when report was received.

Format: YYYYMMDD-HH:MM:SS

OrdStatus

39 (OrdStatus)

Y

Key field. Identifies current status of order.

Valid values:

2 = Filled

4 = Cancelled

ExecID

17 (ExecID)

Y

Key field. Exchange Deal ID

Symbol

55 (Symbol)

Y

Key field.

Contains the MarketID (Symbol) needed to submit orders

Side

54 (Side)

Y

Key field. Trade side.

Valid values:

1 = Buy

2 = Sell

ExecType150 (ExecType)Y

Key field. Describes the reason the trade capture report is sent. ExecType will be equal to ‘NULL’ in case of live updates sent from ICE.

5 = Replace
F = Trade (partial fill or fill)
H = Trade Cancel

TradeReportID


571 (TradeReportID)

N

Unique ID of Trade Capture Report

UniqueTradeID-N

Together with TradeReportID and SendingTime identifies unique trade appearance.

Format: ExecID + "." + Symbol + "." + Side + "." + OrdStatus

Table: ICESecurityDefinitions

Usage: Table holds summary data for requested security definitions on certain ICE Market. Total Number of securities available at the ICE Market is provided in  TotNoRelatedSym column.

Fields

Name

FIX tag

Req’d

Description

SecurityResponseID

322

Y

Key field. Unique ID of Security Definition

CurrentDate

52

Y

Key field. Date when Security Definition was received

Format: YYYYMMDD

ICESessionTargetCompID

56

Y

Key field. Always set to ICE

SecurityReqID

320

Y

ID of Security Definitions Request

SecurityResponseType

393

Y

Valid value: 4

TotNoRelatedSym

393

Y

Total number of securities in this security type

NoRpts

82

Y

Total number of messages sent as a response of the request

ListSeqNo

67

Y

Sequence number of the message in a list

NoUnderlyings

711

Y

Total number of securities in this security definition response message

ExchangeSilo

9064

N

Identifies the Exchange Silo of a market.

Valid Values:

0= ICE

1= Endex

2= Liffe

SecurityID48CSecurity Type ID of the product
Symbol55CUnderlying future Market ID that the options in the security list are derived from.
Text58N

Table: ICESecurityDefUnderlyings

Usage: Table is used to store description of individual securities available on  certain ICE Market. For each Security Definition number of records in ICESecurityDefUnderlyings table will be equal to value of NoUnderlyings in correspondent record in ICESecurityDefinitions table.

Fields

Column Name

FIX tag

Req’d

Description

UnderlyingSymbol                             

311

Y

Key field. Contains the MarketID (Symbol) needed to submit orders

CurrentDate

52

Y

Key field. Date when Security Definition was received

Format: YYYYMMDD

UnderlyingCFICode                          

463

N

Key field.

Valid Values:

FXXXXX = Futures

OXXXXX = Options

OXXFXX = Unique Option market ID

ICESessionTargetCompID

56

Y

Always set to ICE

SecurityResponseID

322

Y

Unique ID of Security Definition

UnderlyingSecurityID                                                                       

                       

309

Y

Contract symbol


UnderlyingSecurityIDSource                        

305

Y

Contract symbol source

UnderlyingSecurityDesc

307

Y

Security description

UnderlyingMaturityDate

542

Y

Maturity date of a security

UnderlyingContractMultiplier                       

436

Y

Contract multiplier

StartDate

916

Y

Start Date of the market strip

EndDate                     

917

Y

End Date of the market strip

IncrementPrice

9013

Y

Increment Price for a security

IncrementQty             

9014

Y

Increment quantity for a security

LotSize                       

9017

Y


LotSizeMultiplier

9024

N

 Clearable products only

StripID                       

9201

Y


StripType                               

9200

Y


StripName      

9202

N


HubID            

9300

Y


HubName                   

9301

N


HubAlias                    

9302

N


UnderlyingUnitOfMeasure

998

Y

Physical unit of measure for derivative products


Granularity     

9085

N


PriceDenomination    

9100

Y

Trading denomination the contract trades in e.g., USD, GB pence, USD cents

NOTE: For OXXFXX– unique Option marketIDs this tag will be absent

PriceUnit        

9101

Y

NOTE: For OXXFXX– unique Option marketIDs this tag will be absent

NumOfDecimalPrice 

9083

Y


ProductID      

9061

N


ProductName             

9062

N


NumOfDecimalQty   

9084

Y


Clearable        

9025

N

Valid values:

Y = Clearable

N = Not Clearable

ProductDescription    

9063

N


TickValue       

9032

N


IncrementStrike         

9400

N

Exists for options

MinStrike                               

9401

N

Exists for options

MaxStrike                              

                                   

9402

N

Exists for options

ImpliedType   

9002

N

Valid Value:

F – Full Spread

PrimaryLegSymbol

9004

N

Exists for spread products.

SecondaryLegSymbol

9005

N

Exists for spread products.

NumOfCycles

9022

N

Remaining days left to a flow contract

PhysicalCode

9303

N

Always exist if Tag 711 value > 0

UnderlyingSecurityExchange

308

N

Supports Market Identifier Code (MIC) values. Examples of possible values are “IFEU”, “IFUS”, “IFCA”, “IFED”, etc. This will not be sent for options markets.

OffExchangeIncrementPrice


9040

N

The minimum increment price for Off Exchange markets

OffExchangeIncrementQty

9041

N

The minimum increment quantity for Off Exchange markets

UnderlyingStrikePrice

316

N


SecurityTradingStat

326

N


UnderlyingSecuritySubTyp

763

N

Reserved for future use. Contains the strategy code for a defined market where applicable.

https://www.theice.com/publicdocs/technology/ICE_Strategy_Code_Reference_Manual.pdf

NoUnderlyingSecurityAltID457CNumber of UnderlyingSecurityAltID (Tag 458) entries.
UnderlyingCouponRate435CCDS and IRS Futures - Fixed Rate: The fixed rate for an instrument.
UnderlyingDatedDate2041CCDS and IRS Futures - Cash Flow Alignment Date: The cash flow alignment date is a date not adjusted for holidays used to derive interest payment dates. Any calendar day.
UnderlyingInterestAccrualDate2042CCDS and IRS Futures - Effective Date: The effective date of the swap future. Any business day.
UnderlyingIssueDate242CIRS Futures - First Fixing Date: The first Fixing Date is the date at which the float rate is set during the first float period. Any acceptable business day. Not applicable for CDS.
UnderlyingRepurchaseRate245CIRS Futures - Previous Fixing Rate: The rate set on the last reset date. Sent for float leg on aged or spot starting swap futures. Not sent for forward starting swap futures. Not applicable for CDS.
UnderlyingFactor246CCDS and IRS Futures - Index Factor: Percentage of the original index that is still accruing interest.
UnderlyingCreditRating256CIRS Futures - Rate Descriptor: The description of Float Rate. Sent for float leg on aged or spot starting swap futures. Not applicable for CDS.
UnderlyingInstrRegistry595C

IRS Futures - Payment Frequency: The interest rate swap future payment frequency. Not applicable for CDS.
Supported value(s):
6M = 6 months
1Y = 1 year

UnderlyingPutOrCall315C

Supported value(s):
0 = Put
1 = Call

UnderlyingCurrency318NPlease note that you may receive values that are not ISO 4217 Currency codes.
UnderlyingSettlMethod1039C

Adapted from FIX 5.0.
Supported value(s):
C = Cash/Financial
P = Physical

StrikeExerciseStyle1304C

Adapted from FIX 5.0. Only supported for FLEX Expiry Option products.
Supported value(s):
0 = European
1 = American
3 = Asian

BaseNumLots9030N
LegacyTickValue9132N
HedgeProductID9026NUnique product id for the corresponding Hedge Product.
HedgeMarketID9027NMarketID for the corresponding Hedge market.
HedgeOnly9033N

Indicates whether a market can only be used as a hedge.
Supported value(s):
0 = No (Default if not sent)
1 = Yes, Hedge only

HomeExchange9042NIndicates where the equity is listed.
IsDividendAdjusted9043N

Indicates whether or not the equity will be adjusted for dividends.
Supported value(s):
0 = No (Default if not sent)
1 = Yes

ClearedAlias9091N
Denominator9092N
InitialMargin9093N
ProductType9095N

Supported value(s):
Energy
Futures
Spreads

NumOfDecimalStrikePrice9185NNumber of decimals to display for strike price.
BlockOnly9203N

Indication of whether the market is only traded as a block and not in the central limit order book.
Supported value(s):
0 = No (default if not sent)
1 = Yes

FlexAllowed9204N

Indication of whether a market allows FLEX expiries.
Supported value(s):
0 = No (default if not sent)
1 = Yes

GTAllowed9205N

Indication of whether a market allows GTC and GTD orders.
Supported value(s):
0 = No (default if not sent)
1 = Yes

MiFIDRegulatedMarket9215N

Indication of whether the market falls under MiFID regulations.
Supported value(s):
0 = No (default if not sent)
1 = Yes

AONAllowed9216N

Indication of whether a market allows Flexible options.
Supported value(s):
0 = No (default if not sent)
1 = Yes

UnderlyingAccruedPremiumAmt9900NCDS and IRS Futures - Total Premium Accrual: Premium that has accrued during the current quarterly payment period. Based on 100 Notional and will be applied to the 'A' value.
UnderlyingEventPaymentAmt9901NCDS Futures - Premium & Credit Event Payments (B Value): This value represents historical premium and credit event payments for 100 notional, and is one of the primary inputs needed for calculating a futures price for a swap future.
UnderlyingAlignmentInterestRate9902NIRS Futures - Accrued Coupons (B Value): This value represents historical fixed and floating payments for 100 notional, and is one of the primary inputs needed for calculating a futures price for an interest rate swap future.
UnderlyingRepurchaseDate9903NCDS and IRS Futures - Price Alignment Interest (C Value): PAI is the cumulative daily interest on variation margin adjustment for 100 notional. PAI is one of the primary inputs needed for calculating a futures price for a swap future.
UnderlyingInterpolationFactor9904NIRS Futures - Previous Fixing Date: The date (YYYYMMDD) the floating rate was set for the next floating payment. Not applicable for CDS.
NoBlockDetails9070NNumber of block details.
TestMarketIndicator9217N

Indication of whether the market is a production or test market.
Supported value(s):
0 = No, this is a production market (default if not sent).
1 = Yes, this is a test market only.

UDSAllowed9049N

Indicates whether or not the market can be used as a leg to create a Defined Strategy.
Supported value(s):
0 = No (Default if not sent)
1 = Yes

Table: ICEUnderlyingSecurityAltID

Usage: Table holds contents of NoUnderlyingSecurityAltID repeating groups.

Fields

Name

FIX tag

Req’d

Description

UnderlyingSymbol

311

Y

Key field. Contains the MarketID (Symbol) needed to submit orders

CurrentDate

52

Y

Key field. Date when Security Definition was received

Format: YYYYMMDD

UnderlyingCFICode

56

Y

Key field.

Valid Values:

FXXXXX = Futures

OXXXXX = Options

OXXFXX = Unique Option market ID

UnderlyingSecurityEntry

320

Y

Key field. Numeric identifier of the NoUnderlyingSecurityAltID group entry.

UnderlyingSecurityAltID

458

C

Will contain the ISIN of the instrument if UnderlyingSecurityAltIDSource (Tag 459) = 'U4'. Will contain the ISIN of the underlying equity if UnderlyingSecurityAltIDSource (Tag 459) = '4'.

UnderlyingSecurityAltIDSource

459

C

Supported value(s): 4 = ISIN (Underlying ISIN of Equity related market) U4 = ISIN (ISIN of Instrument as required by MiFID). Only supported for Futures and Options MiFID regulated markets. Not supported for strategies.

Table: ICESecurityBlockDetails

Usage: Table holds contents of NoBlockDetails repeating groups.

Fields

Name

FIX tag

Req’d

Description

UnderlyingSymbol

311

Y

Key field. Contains the MarketID (Symbol) needed to submit orders

CurrentDate

52

Y

Key field. Date when Security Definition was received

Format: YYYYMMDD

UnderlyingCFICode

56

Y

Key field.

Valid Values:

FXXXXX = Futures

OXXXXX = Options

OXXFXX = Unique Option market ID

UnderlyingBlockDetailsEntry

320

Y

Key field. Numeric identifier of the NoBlockDetails group entry.

BlockDetailsBlockType

9071

C

First tag in the repeating group. Required with NoBlockDetails (Tag 9070) > ‘0’.
Supported value(s):
0 = Regular
1 = PNC
2 = DP
3 = LIS

BlockDetailsTradeType

9072

C

Required with NoBlockDetails (Tag 9070) > ‘0’.
Supported value(s):
See TrdType (Tag 828) for Supported value(s).

BlockDetailsMinQty9073CRequired with NoBlockDetails (Tag 9070) > ‘0’. Block minimum quantity.
  • No labels