Bloomberg currency cross security mapping
This mapping is used for Security Type Currency cross.
This mapping is used when you choose Tools → Create security → Bloomberg → Currency cross.
Mapping
Mapping name: mapping.bloomberg.currencycross
Updated fields
Security code
Name
Status
Country
Currency
Base currency
Type
Multiplier
Multiplier 2
Update code # (enabled field)
Tag Reference data - Bloomberg currency cross
Mapping table
Row | Source field | FA Field | Custom script |
---|---|---|---|
1 | s.type | output = 'I' ; | |
2 | TICKER | s.securityCode | |
3 | CRNCY | s.currency | |
4 | ID_BB_GLOBAL | s.updateCode | |
5 | s.status | output="ACTIVE"; | |
6 | SECURITY_NAME | s.name | |
7 | s.baseCurrency | output="[TICKER]".substring(0,3) ; | |
8 | BASE_CRNCY | s.baseCurrency | |
9 | PX_POS_MULT_FACTOR | s.multiplier | |
10 | s.multiplierView | output="[s.multiplier]" ; | |
11 | s.tags | output="Reference data-Bloomberg currency cross" ; |