Bloomberg issuer updates for equities and debt instruments
You can fetch and update the issuer information for securitiy types Equity (STOCK) and Debt instruments (BOND) from Bloomberg.
To fetch the data, go to Update security data → Bloomberg in the Securities view.
This mapping creates the issuer contact and links it to the security.
Mapping
Mapping name: update.bloomberg.issuer
Updated fields
Security code
Security name
Security status
Security issuer (reference)
Security currency
Security type
Contact ID (LEI)
Contact name
Contact classification
Contact identification
Contact juridical
Contact nationality
Contact tax country
Contact status
Contact type (Issuer)
Contact Solvency II information
Mapping table
Row | Source field | FA field | Script |
|---|---|---|---|
1 | MARKET_SECTOR | SECTOR | |
2 | TICKER_AND_EXCH_CODE | TIC | |
3 | CRNCY | s.currency | |
4 | ID_ISIN | ISIN | |
5 | s.securityCode | if("[SECTOR]"=="2")
{
output="[TIC]"
}
else
{
output="[ISIN]_[CRNCY]"
}
; | |
6 | ID_BB_COMPANY | COMPANY | |
7 | LEGAL_ENTITY_IDENTIFIER | LEI | |
8 | c.contactId | if((!"[LEGAL_ENTITY_IDENTIFIER]"?.trim()) || ("[LEGAL_ENTITY_IDENTIFIER]"=='N.S.') || ("[LEGAL_ENTITY_IDENTIFIER]"=='null'))
{output="[COMPANY]"}
else
{output="[LEGAL_ENTITY_IDENTIFIER]"}
;if((!"[LEGAL_ENTITY_IDENTIFIER]"?.trim()) || ("[LEGAL_ENTITY_IDENTIFIER]"=='N.S.') || ("[LEGAL_ENTITY_IDENTIFIER]"=='null')) {output="[COMPANY]"} else {output="[LEGAL_ENTITY_IDENTIFIER]"} ; | |
9 | ISSUER | ||
10 | c.type | output="5" | |
11 | c.juridical | output="CO" | |
12 | c.status | output="A" | |
13 | c.identity | output="OTHER" | |
14 | c.classification | output="PROF" | |
15 | CNTRY_OF_INCORPORATION | c.taxCountry | |
16 | CNTRY_OF_RISK | RISKCTRY | |
17 | c.nationality | if((!"[CNTRY_OF_RISK]"?.trim()) || ("[CNTRY_OF_RISK]"=='N.S.') || ("[CNTRY_OF_RISK]"=='null'))
{
output="[CNTRY_OF_INCORPORATION]"
}
else
{
output="[CNTRY_OF_RISK]"
}
; | |
18 | s.issuer | output="[c.contactId]" | |
19 | s.type | switch("[MARKET_SECTOR]")
{
case "2":
output="E"
break
case "3":
output="D"
break
case "6":
output="D"
break
case "7":
output="D"
break
case "8":
output="D"
break
case "11":
output="D"
break
default:
output="X"
break
}
; | |
20 | SECURITY_NAME | s.name | |
21 | s.status | output="ACTIVE" ;" | |
22 | NACE_SECTOR_CODE NACE_CODE NACE_CODE_CLASS ID_BB_ULTIMATE_PARENT_CO_NAME LEI_ULTIMATE_PARENT_COMPANY | c.profileAttributes | The three given fields are imported as contact's profile attributes, if Bloomberg provides values for those fields. The updated fields (in the Solvency II profile) are:
|