Reference data enums for a lookup table of possible enumeration field values.
Security master
Security master provides up-to-date (latest) or point-in-time (PIT) static information on securities across international markets for 860,000+ listed and delisted securities. This provides a means for resolving securities attributes, identification, symbology and informational challenges efficiently. Some common use cases for the security master include research, backtesting, compliance and report generation, risk management, and keeping portfolios current.
See also
Fields
- Timestamps are strings in ISO 8601 format, expressed in UTC
- Dates are strings in YYYY-MM-DD ISO 8601 format, expressed in the local time of the listing
exchange
- Enums are strings, with each value corresponding to a predefined set of options listed in the associated lookup table
Field |
Type |
Description |
---|---|---|
ts_record |
Timestamp | The timestamp (UTC) the record last changed. |
ts_effective |
Timestamp | The timestamp (UTC) the record details are effective from. |
listing_id |
String | Unique listing numerical ID. Concatenation of a sequence number and the listing_group_id . The sequence number will usually be 1 unless additional listings exists for the same security in the same market, usually as a result of secondary trading currencies. |
listing_group_id |
String | Groups all listings for the same security on a specific exchange, often in different trading currencies. |
security_id |
String | Security level numerical ID. Can be used to link all multiple listings together. |
issuer_id |
String | Issuer level numerical ID. Can be used to link all securities of a company together. |
listing_status |
Enum | Listing status code. Indicates the listing activity status at market level. See LISTSTAT enum. |
listing_source |
Enum | Indicates if the listing level data in the record is (M)ain or (S)econdary. See LISTSOURCE enum. |
listing_created_date |
Date | Listing creation date. |
listing_date |
Date or null | Listing date. |
delisting_date |
Date or null | Delisting date. |
issuer_name |
String | Issuer name. |
security_type |
Enum | The security type. See SECTYPE enum. |
security_description |
String | The security description. |
primary_exchange |
Enum or null | Exchange code for the primary security. Empty if unknown. See EXCHANGE enum. |
exchange |
Enum | Exchange code for the listing. Equivalent to the MIC but more stable as MIC might not be available in a timely fashion. Also note that the MIC can change but the exchange will remain the same. See EXCHANGE enum. |
operating_mic |
Enum or null | Market Identifier Code (MIC) as an ISO 10383 string. See EXCHANGE enum. |
symbol |
String or null | The query input symbol which matched the record. |
nasdaq_symbol |
String or null | Nasdaq Integrated Platform Suffix convention symbol. |
local_code |
String or null | Local code, usually unique at market level but there are exceptions to this rule. Either an alpha string, or a number. |
isin |
String or null | ISIN global level identifier as an ISO 6166 string. |
us_code |
String or null | US domestic CUSIP. |
bbg_comp_id |
String or null | Bloomberg composite global ID. |
bbg_comp_ticker |
String or null | Bloomberg composite ticker. |
figi |
String or null | Bloomberg FIGI, that is exchange level ID. |
figi_ticker |
String or null | Bloomberg exchange level ticker. |
fisn |
String or null | Financial Instrument Short Name. |
lei |
String or null | Legal Entity Identifier. |
sic |
String or null | Standard Industrial Classification Code. |
cik |
String or null | Central Index Key. |
gics |
String or null | Global Industry Standard Classification. |
naics |
String or null | North American Industrial Classification System. |
cic |
String or null | Complementary Identification Code. |
cfi |
String or null | Classification of Financial Instruments as an ISO 10962 string. |
incorporation_country |
Enum or null | Country of incorporation code of the issuer as two letter ISO 3166-1 alpha-2 string. See CNTRY enum. |
listing_country |
Enum or null | Listing country as two letter ISO 3166-1 alpha-2 string. See CNTRY enum. |
register_country |
Enum or null | Register country as two letter ISO 3166-1 alpha-2 string. See CNTRY enum. |
trading_currency |
Enum or null | Trading currency as an ISO 4217 string. See CUREN enum. |
multi_currency |
Boolean | True if there is currently more than one listing in the market, otherwise false. |
segment_mic_name |
String or null | Market Segment Name. Not the MICSEG lookup name but used when no segment MIC is available. |
segment_mic |
Enum or null | Market Identifier Code (MIC) as an ISO 10383 string. See MICSEG enum. |
structure |
Enum or null | Security structure code. See STRUCTCD enum. |
lot_size |
Number or null | Lot Size. Indicates the minimum number of shares that can be acquired in one transaction. |
par_value |
Number or null | Par value amount. |
par_value_currency |
Enum or null | Par value currency as an ISO 4217 string. See CUREN enum. |
voting |
Enum or null | Voting or non-voting rights. See VOTING enum. |
vote_per_sec |
Number or null | Number of votes per security. |
shares_outstanding |
String or null | Shares outstanding. |
shares_outstanding_date |
String or null | Effective date for shares_outstanding . |
ts_created |
Timestamp | The timestamp (UTC) the record was added to database. |
Identifiers
Identifiers for listing, security and issuer are grouped at the beginning of each record, which enables
clearer comparisons of where a single security is associated with many individual listings across
different exchanges. There is one primary_exchange
for a security, and it may then be listed
on multiple secondary exchange
s.