Skip to main content

Mapping for futures

Securities

Mapping script mapping.bbgTradeFeed.futSec:

Source field in Online trade feed

Target field in FA

Notes

/TradeFeed/Common/SecurityIdentifier/text() 

s.securityCode

s.type

F

s.status

PASSIVE

s.name

[s.securityCode]_TEMP_AIM

/TradeFeed/Common/SecurityCurrencyISOCode/text()

s.currency

/TradeFeed/Common/SecurityIdentifier/text() 

s.isinCode

/TradeFeed/Common/Price/text()

/TradeFeed/Common/TradeAmount/text()

/TradeFeed/Common/SettlementCcyPrincipal/text()

s.multiplier

[Price]*[TradeAmount]/[SettlementCcyPrincipal]

If any of the three is not defined, then 1

s.multiplierView

[s.multiplier]

s.blockSize

1/[s.multiplier]

/TradeFeed/Common/Ticker/text()

/TradeFeed/ExtendedFields/Field[@name='MARKET_SECTOR_DES']/text()

s.tradeCode

[Ticker].[MARKET_SECTOR_DES]

Transactions

Mapping script mapping.bbgTradeFeed.futTrs:

Source field in Online Trade Feed

Target field in FA

Notes

/TradeFeed/Common/TraderAccountName/text()

tr.parentPortfolio

If a portfolio that has the ext ID "AIM-ID" with the given TraderAccountName is found, then the transaction is imported into that portfolio. Otherwise, the parent portfolio short name is assumed to be the TraderAccountName.

/TradeFeed/Common/TransactionNumber/text()

tr.reference

AIM_[TransactionNumber]

/TradeFeed/Common/BuySellCoverShortFlag/text()

tr.type

B, if BuySellCoverShortFlag is B or C.

S, if BuySellCoverShortFlag is S or H.

tr.status

OK

/TradeFeed/Common/AsOfTradeDate/text()

/TradeFeed/Common/TradeDate/text()

tr.transactionDate

AsOfTradeDate, if defined. Otherwise TradeDate.

/TradeFeed/Common/SettlementDate/text()

tr.settlementDate

/TradeFeed/Common/SecurityIdentifier/text() 

tr.security

tr.account

AUTO

/TradeFeed/Common/TradeAmount/text()

tr.amount

/TradeFeed/Common/Price/text()

tr.unitPrice

tr.fxRate

AUTO

/TradeFeed/TransactionCosts/TransactionCost[1]/Cost/text()

tr.cost

/TradeFeed/TransactionCosts/TransactionCost[1]/Type/text()

tr.costType1

If Type = 2, then COMA

If Type = 3, then EXCH

/TradeFeed/TransactionCosts/TransactionCost[2]/Cost/text()

tr.cost2

/TradeFeed/TransactionCosts/TransactionCost[2]/Type/text()

tr.costType2

If Type = 2, then COMA

If Type = 3, then EXCH

/TradeFeed/Common/AccruedInterestRepoInterest/text()

tr.accruedInterest

/TradeFeed/Common/CustomerAccountCounterparty/text()

tr.counter

If a contact that has the ext ID "AIM-ID" with the given CustomerAccountCounterparty is found, then that contact is used. Otherwise, the contact ID is assumed to be the CustomerAccountCounterparty.

/TradeFeed/Common/TransactionNumberOfOriginTrans/text()

tr.intInfo

/TradeFeed/Common/SettlementCurrencyISOCode/text()

tr.currency