Skip to main content

Bloomberg equity security mapping

Used for Security Types Equity (STOCK), Collective investment vehicles (FUND) and Exchange-traded funds (ETFs) (FUND).

This is used in menu command: Tools > Create security if you select Bloomberg equity.

Mapping

Mapping name: mapping.bloomberg.equity

Updated fields

  • Security code

  • ISIN code

  • Name

  • Trade code

  • URL

  • Country

  • Currency

  • Exchange

  • Type

  • Sub-type

  • Status

  • Holiday calendar

  • Enable settlement date offset

  • Multiplier

  • Multiplier 2

  • Settlement date offset

  • Outstanding shares

  • Update code # (enabled field)

  • Tag Reference data - Bloomberg equity/Reference data - Bloomberg fund

  • Solvency II profile data: Asset listed in, CIC code

  • Key figure Bloomberg Identifier (for SEB custody report)

Mapping table

Row

Source field

FA field

Script

1

CFI_CODE

CFI

 

2

BLOOMBERG_CFI_CODE

CFI

 

3

 

s.type

if("[CFI]".substring(0,2)=='CE' )
{
output = "[CFI]".substring(0,2)
}
else if("[CFI]".substring(0,2)=='EU' )
{
output = "C"
}
else
{
output = "[CFI]".substring(0,1)
}
;

4

 

s.subType

if("[CFI]".substring(0,2)=='CE' )
{
output =''
}
else if("[CFI]".substring(0,2)=='EU' )
{
output = "CM"
}
else
{
output = "[CFI]".substring(0,2)
}
;

5

ID_ISIN

s.isinCode

 

6

CRNCY

s.currency

if("[CRNCY]"=='GBp')
{
output='GBP'
}
else
{
output="[CRNCY]"
}
;

7

TICKER_AND_EXCH_CODE

s.securityCode

if("[s.type]"=="C")
{
output="[s.isinCode]_[s.currency]"
}
else
{
output="[TICKER_AND_EXCH_CODE]"
}

8

ID_BB_GLOBAL

s.updateCode

 

9

 

USEMIC

output="-"
;

10

ID_MIC1

USEMIC

 

11

ID_MIC_PRIM_EXCH

USEMIC

 

12

 

HOLEX

switch("[USEMIC]")
{
case "XSWX":
output = "CHZU"
break
case "XVTX":
output = "CHZU"
break
case "XMAD":
output = "ESMA"
break
case "XNGS":
output ="USNY"
break
case "XNYS":
output ="USNY"
break
case "XNAS":
output ="USNY"
break
case "GLBX":
output ="USNY"
break
case "XCME":
output ="USNY"
break
case "XSES":
output = "SGSI"
break
case "XSTO":
output = "SEST"
break
case "XCSE":
output = "DKCO"
break
case "XETR":
output = "DEFR"
break
case "XEUR":
output = "DEFR"
break
case "FRAB":
output = "DEFR"
break
case "MUNA":
output = "DEFR"
break
case "XBER":
output = "DEFR"
break
case "XHEL":
output = "FIHE"
break
case "FNFI":
output = "FIHE"
break
case "NOTC":
output = "NOOS"
break
case "XOSL":
output = "NOOS"
break
case "XOAM":
output = "NOOS"
break
case "XLDN":
output = "GBLO"
break
case "SETS":
output = "GBLO"
break
case "XPAR":
output = "FRPA"
break
case "XTKS":
output = "JPTO"
break
case "XJPX":
output = "JPTO"
break
case "XTSX":
output = "CATO"
break
case "XTSE":
output = "CATO"
break
case "XASX":
output = "AUSY"
break
case "XNZE":
output = "NZWE"
break
default:
output="-"
break
}
;    

13

CDR_EXCH_CODE

CAL

 

14

CALENDAR_CODE

CAL

 

15

CNTRY_OF_DOMICILE

s.country

if("[CNTRY_OF_DOMICILE]"!="EU")
{
if("[CNTRY_OF_DOMICILE]".length()==2)
{
output="[CNTRY_OF_DOMICILE]"
}
else
{
output=''
}
}
else
{
output=''
}
;

16

 

CALCODE

switch("[CAL]")
{
case "A7":
output="AUSY"
break
case "AU":
output="AUSY"
break
case "AX":
output="AUSY"
break
case "BZ":
output="BRBD"
break
case "RI":
output="BRBD"
break
case "ML":
output="CAMO"
break
case "CA":
output="CATO"
break
case "T4":
output="CATO"
break
case "WG":
output="CATO"
break
case "#V":
output="CHZU"
break
case "BS":
output="CHZU"
break
case "CH":
output="CHZU"
break
case "S5":
output="CHZU"
break
case "SZ":
output="CHZU"
break
case "V1":
output="CHZU"
break
case "ZU":
output="CHZU"
break
case "CZ":
output="CZPR"
break
case "P1":
output="CZPR"
break
case "FA":
output="DEFR"
break
case "GE":
output="DEFR"
break
case "CP":
output="DKCO"
break
case "CP":
output="DKCO"
break
case "DE":
output="DKCO"
break
case "TE":
output="EUTA"
break
case "FI":
output="FIHE"
break
case "HE":
output="FIHE"
break
case "FR":
output="FRPA"
break
case "M9":
output="FRPA"
break
case "MT":
output="FRPA"
break
case "PA":
output="FRPA"
break
case "AP":
output="GBLO"
break
case "EN":
output="GBLO"
break
case "GB":
output="GBLO"
break
case "LM":
output="GBLO"
break
case "LS":
output="GBLO"
break
case "B8":
output="HUBU"
break
case "HU":
output="HUBU"
break
case "FX":
output="JPTO"
break
case "JN":
output="JPTO"
break
case "OK":
output="JPTO"
break
case "T2":
output="JPTO"
break
case "T3":
output="JPTO"
break
case "TK":
output="JPTO"
break
case "ME":
output="MXMC"
break
case "MX":
output="MXMC"
break
case "NO":
output="NOOS"
break
case "OS":
output="NOOS"
break
case "FD":
output="NYFD"
break
case "NY":
output="NYSE"
break
case "KD":
output="NZAU"
break
case "ND":
output="NZAU"
break
case "NZ":
output="NZAU"
break
case "WL":
output="NZWE"
break
case "PD":
output="PLWA"
break
case "PL":
output="PLWA"
break
case "O2":
output="SEST"
break
case "ST":
output="SEST"
break
case "SW":
output="SEST"
break
case "CE":
output="USNY"
break
case "M4":
output="USNY"
break
case "US":
output="USNY"
break
case "#A":
output="USNY"
break
case "JH":
output="ZAJO"
break
case "SA":
output="ZAJO"
break
case "X1":
output="ZAJO"
break
case "ZA":
output="ZAJO"
break
default:
output='Sat/Sun'
break
}
;

17

 

s.exchange

if("[USEMIC]"=='-')
{
output=''
}
else
{
output="[USEMIC]"
}
;

18

 

s.holidayCalendar

if("[HOLEX]"!='-')
{
output="[HOLEX]"
}
else
{
output="[CALCODE]"
}
;

19

DAYS_TO_SETTLE

s.settlementDateOffset

 

20

 

s.enableSettlementDateOffset

if("[DAYS_TO_SETTLE]" != null && !"[DAYS_TO_SETTLE]".isEmpty() && !"[DAYS_TO_SETTLE]".trim().isEmpty())
{
output='1'
}
else
{
output="0"
}
;

21

EQY_SH_OUT_REAL

s.share

 

22

 

s.tradeCode

output="[ID_BB_GLOBAL]"    
;

23

 

s.status

output="ACTIVE";

24

NAME

nam

 

25

SECURITY_NAME

s.name

if("[s.type]"=="C")
{
output="[NAME]"
}
else
{
output="[SECURITY_NAME]"
}
;

26

 

s.tags

if("[s.type]"=="C")
{
output="Reference data-Bloomberg fund"
}
else
{
output="Reference data-Bloomberg equity"
}
;

27

COMPANY_WEB_ADDRESS

s.url

 

28

 

s.multiplier

char currencyLastChar ="[CRNCY]".charAt(2);
if(currencyLastChar.isLowerCase()) { // BBG has the last character of the currency code lower case if the dividend is denominated in 1/100. // E.g. BGp (when the dividend is denominated in pence instead of pounds) output = "100";
} else { output = "1";
}

29

 

s.multiplierView

output="1"
;

30

 

s.profileAttributes

if(!"[CIC]"?.trim())
{
output=""
}
else
{
output = "security.sii.listedIn=" + "[CIC]".substring(0,2) + ":string#security.sii.cic=" + "[CIC]".substring(2) + ":string#"
}
;

31

TICKER

s.keyFigures

if("[TICKER]"!='') {output="***BloombergId=2000-01-01=[TICKER]"}else {output="***"}