Mapping for equities
Securities
Mapping script mapping.bbgTradeFeed.eqSec:
Source field in Online Trade Feed | Target field in FA | Notes |
|---|---|---|
/TradeFeed/Common/Ticker/text() /TradeFeed/Common/PrimaryExchangeCode/text() | s.securityCode | If the source data has the PrimaryExchangeCode field, then the security code is [Ticker] [PrimaryExchangeCode]. Otherwise, the security code is just [Ticker]. |
s.type | Fixed value E | |
s.status | Fixed value PASSIVE | |
s.name | Based on the s.securityCode field: [s.securityCode]_TEMP_AIM | |
/TradeFeed/Common/SecurityCurrencyISOCode/text() | s.currency |
Transactions
Mapping script mapping.bbgTradeFeed.eqTrs:
Source field in Online trade feed | Target field in FA | Notes |
|---|---|---|
/TradeFeed/Common/TraderAccountName/text() | tr.parentPortfolio | If a portfolio that has the external 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/Ticker/text() /TradeFeed/Common/PrimaryExchangeCode/text() | tr.security | If PrimaryExchangeCode is defined, then [Ticker] [PrimaryExchangeCode]. Otherwise, [Ticker]. |
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 external 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 |