Skip to main content

Morningstar collective investment vehicles mapping

This mapping is used for Security type Collective investment vehicles (FUND) and Exchange-traded funds (ETFs) (FUND).

This mapping is used when you choose ToolsCreate securityMorningstarFund.

Mapping

Mapping name: mapping.morningstar.fund

Updated fields

  • Security code

  • ISIN code

  • Name

  • Country

  • Currency

  • Type

  • URL

  • Status

  • Holiday calendar

  • Trade code

  • Exchange

  • Update code # (enabled field)

  • Tag Reference data - Morningstar

Mapping table

Row

Source field

Value mapping

FA field

Script

1

ATTR-ExchangeTradedShare

ExchangeTradedShare

2

BI-ISIN

isinCode

3

s.isinCode

if("[isinCode]".length()<10)            
{
outout="***"    
}
else     
{
output="[isinCode]"            
}

4

BI-MStarID

s.tradeCode

5

BI-MStarID

s.updateCode

6

BI-CurrencyId

s.currency

output='[BI-CurrencyId]'.substring(7);

7

BI-FundName

s.name

8

s.tags

output="Reference data-Morningstar"
;

9

s.type

if("[ExchangeTradedShare]"=='true')
{
output="CE"
}
else
{
output="C"
}
;

10

s.status

output="ACTIVE"

11

BI-Ticker

TIC

12

s.securityCode

if("[isinCode]".length()<10)        
{    
output="[TIC]"+"_"+"[s.currency]" 
}
else         
{     
output="[s.isinCode]"+"_"+"[s.currency]"  
}      
;

13

BI-DomicileId

CU
$AFG=AF;CU
$ALB=AL;CU
$DZA=DZ;CU
$ASM=AS;CU
$AND=AD;CU
$AGO=AO;CU
$AIA=AI;CU
$ATA=AQ;CU
$ATG=AG;CU
$ARG=AR;CU
$ARM=AM;CU
$ABW=AW;CU
$AUS=AU;CU
$AUT=AT;CU
$AZE=AZ;CU
$BHS=BS;CU
$BHR=BH;CU
$BGD=BD;CU
$BRB=BB;CU
$BLR=BY;CU
$BEL=BE;CU
$BLZ=BZ;CU
$BEN=BJ;CU
$BMU=BM;CU
$BTN=BT;CU
$BOL=BO;CU
$BES=BQ;CU
$BIH=BA;CU
$BWA=BW;CU
$BVT=BV;CU
$BRA=BR;CU
$IOT=IO;CU
$BRN=BN;CU
$BGR=BG;CU
$BFA=BF;CU
$BDI=BI;CU
$CPV=CV;CU
$KHM=KH;CU
$CMR=CM;CU
$CAN=CA;CU
$CYM=KY;CU
$CAF=CF;CU
$TCD=TD;CU
$CHL=CL;CU
$CHN=CN;CU
$CXR=CX;CU
$CCK=CC;CU
$COL=CO;CU
$COM=KM;CU
$COD=CD;CU
$COG=CG;CU
$COK=CK;CU
$CRI=CR;CU
$HRV=HR;CU
$CUB=CU;CU
$CUW=CW;CU
$CYP=CY;CU
$CZE=CZ;CU
$CIV=CI;CU
$DNK=DK;CU
$DJI=DJ;CU
$DMA=DM;CU
$DOM=DO;CU
$ECU=EC;CU
$EGY=EG;CU
$SLV=SV;CU
$GNQ=GQ;CU
$ERI=ER;CU
$EST=EE;CU
$SWZ=SZ;CU
$ETH=ET;CU
$FLK=FK;CU
$FRO=FO;CU
$FJI=FJ;CU
$FIN=FI;CU
$FRA=FR;CU
$GUF=GF;CU
$PYF=PF;CU
$ATF=TF;CU
$GAB=GA;CU
$GMB=GM;CU
$GEO=GE;CU
$DEU=DE;CU
$GHA=GH;CU
$GIB=GI;CU
$GRC=GR;CU
$GRL=GL;CU
$GRD=GD;CU
$GLP=GP;CU
$GUM=GU;CU
$GTM=GT;CU
$GGY=GG;CU
$GIN=GN;CU
$GNB=GW;CU
$GUY=GY;CU
$HTI=HT;CU
$HMD=HM;CU
$VAT=VA;CU
$HND=HN;CU
$HKG=HK;CU
$HUN=HU;CU
$ISL=IS;CU
$IND=IN;CU
$IDN=ID;CU
$IRN=IR;CU
$IRQ=IQ;CU
$IRL=IE;CU
$IMN=IM;CU
$ISR=IL;CU
$ITA=IT;CU
$JAM=JM;CU
$JPN=JP;CU
$JEY=JE;CU
$JOR=JO;CU
$KAZ=KZ;CU
$KEN=KE;CU
$KIR=KI;CU
$PRK=KP;CU
$KOR=KR;CU
$KWT=KW;CU
$KGZ=KG;CU
$LAO=LA;CU
$LVA=LV;CU
$LBN=LB;CU
$LSO=LS;CU
$LBR=LR;CU
$LBY=LY;CU
$LIE=LI;CU
$LTU=LT;CU
$LUX=LU;CU
$MAC=MO;CU
$MDG=MG;CU
$MWI=MW;CU
$MYS=MY;CU
$MDV=MV;CU
$MLI=ML;CU
$MLT=MT;CU
$MHL=MH;CU
$MTQ=MQ;CU
$MRT=MR;CU
$MUS=MU;CU
$MYT=YT;CU
$MEX=MX;CU
$FSM=FM;CU
$MDA=MD;CU
$MCO=MC;CU
$MNG=MN;CU
$MNE=ME;CU
$MSR=MS;CU
$MAR=MA;CU
$MOZ=MZ;CU
$MMR=MM;CU
$NAM=NA;CU
$NRU=NR;CU
$NPL=NP;CU
$NLD=NL;CU
$NCL=NC;CU
$NZL=NZ;CU
$NIC=NI;CU
$NER=NE;CU
$NGA=NG;CU
$NIU=NU;CU
$NFK=NF;CU
$MNP=MP;CU
$NOR=NO;CU
$OMN=OM;CU
$PAK=PK;CU
$PLW=PW;CU
$PSE=PS;CU
$PAN=PA;CU
$PNG=PG;CU
$PRY=PY;CU
$PER=PE;CU
$PHL=PH;CU
$PCN=PN;CU
$POL=PL;CU
$PRT=PT;CU
$PRI=PR;CU
$QAT=QA;CU
$MKD=MK;CU
$ROU=RO;CU
$RUS=RU;CU
$RWA=RW;CU
$REU=RE;CU
$BLM=BL;CU
$SHN=SH;CU
$KNA=KN;CU
$LCA=LC;CU
$MAF=MF;CU
$SPM=PM;CU
$VCT=VC;CU
$WSM=WS;CU
$SMR=SM;CU
$STP=ST;CU
$SAU=SA;CU
$SEN=SN;CU
$SRB=RS;CU
$SYC=SC;CU
$SLE=SL;CU
$SGP=SG;CU
$SXM=SX;CU
$SVK=SK;CU
$SVN=SI;CU
$SLB=SB;CU
$SOM=SO;CU
$ZAF=ZA;CU
$SGS=GS;CU
$SSD=SS;CU
$ESP=ES;CU
$LKA=LK;CU
$SDN=SD;CU
$SUR=SR;CU
$SJM=SJ;CU
$SWE=SE;CU
$CHE=CH;CU
$SYR=SY;CU
$TWN=TW;CU
$TJK=TJ;CU
$TZA=TZ;CU
$THA=TH;CU
$TLS=TL;CU
$TGO=TG;CU
$TKL=TK;CU
$TON=TO;CU
$TTO=TT;CU
$TUN=TN;CU
$TUR=TR;CU
$TKM=TM;CU
$TCA=TC;CU
$TUV=TV;CU
$UGA=UG;CU
$UKR=UA;CU
$ARE=AE;CU
$GBR=GB;CU
$UMI=UM;CU
$USA=US;CU
$URY=UY;CU
$UZB=UZ;CU
$VUT=VU;CU
$VEN=VE;CU
$VNM=VN;CU
$VGB=VG;CU
$VIR=VI;CU
$WLF=WF;CU
$ESH=EH;CU
$YEM=YE;CU
$ZMB=ZM;CU
$ZWE=ZW;CU
$ALA=AX

s.country

14

s.holidayCalendar

switch("[s.country]")
{
case 'GB':
output='GBLO'
break
case 'FR':
output='FRPA'
break
case 'DE':
output='DEFR'
break
case 'CH':
output='CHZU'
break
case 'EU':
output='EUTA'
break
case 'FI':
output='FIHE'
break
case 'US':
output='USNY'
break
case 'JP':
output='JPTO'
break
case 'AU':
output='AUSY'
break
case 'BR':
output='BRBD'
break
case 'CA':
output='CATO'
break
case 'CZ':
output='CZPR'
break
case 'DK':
output='DKCO'
break
case 'HU':
output='HUBU'
break
case 'MX':
output='MXMC'
break
case 'NO':
output='NOOS'
break
case 'NZ':
output='NZWE'
break
case 'PL':
output='PLWA'
break
case 'SE':
output='SEST'
break
case 'ZA':
output='ZAJO'
break
}
;

15

BI-ProviderCompanyWebsite

s.url

16

BI-ExchangeID

EXCH

output='[BI-ExchangeID]'.substring(6,10)

17

s.exchange

if((!"[EXCH]"?.trim())||("[EXCH]"==null)||("[EXCH]"=='')||("[EXCH]"=='chan'))
{
output="***"
}
else
{
output="[EXCH]"
}
;