EOD equity security mapping

1

s.tags

output="Reference data-EOD equity"      
;        

2

General.Type

s.subType

if("[General.Type]"=='Common Stock')
{
output='ES'
}
else
{
output=''
}
;     

3

s.type

if("[General.Type]"=='ETF')
{
output='CE'
}
else
{
output='E'
}
;

4

General.Exchange

EXCH

5

s.exchange

switch("[EXCH]")
{
case "OTC":
output="OTCM"
break
case "OTCMKTS":
output="OTCM"
break
case "OTCGRAY":
output="PSGM"
break
case "OTCBB":
output="XOTC"
break
case "OTCQX":
output="OTCQ"
break
case "PINK":
output="PINX"
break
case "OTCQB":
output="OTCB"
break
case "BATS":
output="BHSF"
break
case "NYSE MKT":
output="XASE"
break
case "AMEX":
output="XASE"
break
case "NYSE ARCA":
output="ARCX"
break
case "NYSE":
output="XNYS"
break
case "NASDAQ":
output="XNAS"
break
case "LSE":
output="XLON"
break
case "NEO":
output="NEOE"
break
case "V":
output="XTSX"
break
case "TO":
output="XTSE"
break
case "BE":
output="XBER"
break
case "HM":
output="XHAM"
break
case "XETRA":
output="XETR"
break
case "DU":
output="XDUS"
break
case "MU":
output="XMUN"
break
case "STU":
output="XSTU"
break
case "F":
output="XFRA"
break
case "HA":
output="XHAN"
break
case "LU":
output="XLUX"
break
case "MI":
output="XMIL"
break
case "VI":
output="XWBO"
break
case "PA":
output="XPAR"
break
case "BR":
output="XBRU"
break
case "LS":
output="XLIS"
break
case "AS":
output="XAMS"
break
case "MC":
output="BMEX"
break
case "VX":
output="XSWX"
break
case "SW":
output="XSWX"
break
case "VS":
output="XLIT"
break
case "IR":
output="XDUB"
break
output="XRIS"
break
case "HE":
output="XHEL"
break
case "IC":
output="XICE"
break
case "NFN":
output="XCSE"
break
case "NB":
output="XTAL"
break
case "CO":
output="XCSE"
break
case "OL":
output="XOSL"
break
case "ST":
output="XSTO"
break
case "TA":
output="XTAE"
break
case "HK":
output="XHKG"
break
case "KO":
output="XKRX"
break
case "KQ":
output="XKOS"
break
case "PSE":
output="XPHS"
break
case "WAR":
output="XWAR"
break
case "BUD":
output="XBUD"
break
case "SG":
output="XSES"
break
case "BSE":
output="XBOM"
break
case "SHG":
output="XSHG"
break
case "SN":
output="XSGO"
break
case "JK":
output="XIDX"
break
case "KAR":
output="XKAR"
break
case "AU":
output="XASX"
break
case "SHE":
output="XSHE"
break
case "AT":
output="ASEX"
break
case "SR":
output="XSAU"
break
case "BK":
output="XBKK"
break
case "JSE":
output="XJSE"
break
case "NSE":
output="XNSE"
break
case "VN":
output="HSTC"
break
case "KLSE":
output="XKLS"
break
case "BA":
output="XBUE"
break
case "SA":
output="BVMF"
break
case "MX":
output="XMEX"
break
case "IS":
output="XIST"
break
case "TW":
output="XTAI"
break
case "LIM":
output="XLIM"
break
case "TWO":
output="ROCO"
break
default:
output=''
break
}
;

6

General.ISIN

s.isinCode

7

General.CountryISO

s.country

8

General.Code

s.securityCode

if("[General.CountryISO]"=='US')
{
output="[General.Code]"+"."+"[General.CountryISO]"
}
else
{
output="[General.Code]"+"."+"[General.Exchange]"
}
;

9

s.securityCode

s.updateCode

10

General.CurrencyCode

s.currency

if("[General.CurrencyCode]"=='GBX')
{
    output='GBP'
}
else
{
    output="[General.CurrencyCode]"
}
;

11

s.holidayCalendar

switch("[s.exchange]")
{
case "OTCM":
output="USNY"
break
case "OTCM":
output="USNY"
break
case "PSGM":
output="USNY"
break
case "XOTC":
output="USNY"
break
case "OTCQ":
output="USNY"
break
case "PINX":
output="USNY"
break
case "OTCB":
output="USNY"
break
case "BHSF":
output="USNY"
break
case "XASE":
output="USNY"
break
case "ARCX":
output="USNY"
break
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="Sat/Sun"
break
}
;

12

s.status

output='ACTIVE' 
;

13

General.Name

s.name

14

s.tradeCode

output="[s.securityCode]"
;

15

outstandingShares.quarterly.0.shares

s.shares

if("[General.Type]"=='ETF')     
{       
output="***"           
}      
else        
{         
output="[outstandingShares.quarterly.0.shares]".toString()        
}         
;    

16

General.WebURL

EQURL

17

ETF_Data.ETF_URL

ETFURL

18

s.url

if("[General.Type]"=='ETF')
{
output="[ETFURL]"
}
else
{
output="[EQURL]"
}
;

19

s.multiplier

if("[General.CurrencyCode]" == 'GBX') {
    // If the currency is GBX, prices are denoted in pence. Hence multiplier 100. FA system still creates the security with GBP currency.
    output = "100";
} else {
    output = "1";
}