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 |