Skip to main content

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