The file should be in comma-separated (RFC-4180) format. https://tools.ietf.org/html/rfc4180
The file will always be read as UTF-8 encoded data.
Blank lines are allowed and comment lines begin with a #.
The first row of data must be a header row with column names. The following column names are defined (extra ones are ignored). Column names are not case sensitive and can be in any order.
Field Name | Required | Description |
---|---|---|
Symbol | Y | Identifier for the instrument. |
SecurityType | Y | Asset type of the instrument. Only Equity is supported currently. |
CurrencyCode | Y | ISO 4217 currency code https://www.iban.com/currency-codes |
Mic | Y | Market identifier code https://www.iso20022.org/market-identifier-codes |
IsoAlpha2CountryCode | Y | ISO alpha-2 country code https://www.iban.com/country-codes |
InstrumentName | Name of the instrument. | |
Isin | ISIN identifier for the instrument. | |
Sedol | SEDOL identifier for the instrument. This is recommended for most Equities. | |
Cusip | Cusip identifier for the instrument. | |
ExchangeCode | This is the Eikon 3 letter format if a Ric is provided or the Bloomberg 2 letter format if a BloombergTicker is provided. | |
Ric | * | Reuters identifier for the instrument. This or BloombergTicker is required. |
BloombergTicker | * | Bloomberg identifier for the instrument. This or Ric is required. |
BloombergTickerAndExchangeCode | Bloomberg identifier with exchange code for the instrument. | |
BloombergYellowKey | Bloomberg asset type identifier. |