Examples, notes, and refereces for using Bloomberg's OpenFIGI api to map tickers/company-names to bloomberg figis
mapping_tickers.py
ticker + exchange --> bloomberg figisearch_names.py
search name + exchange --> bloomberg figi
- Great for getting things into bloomberg ids, not out.
- Unspecific requests yield unspecific responses. If inputs aren't listing specific (sedol/isin/cusip/ticker-exchange), expect many results for a given name/ticker (1->N).
Code | Name | Description |
---|---|---|
NAME |
Name | Name of the company or brief description of the instrument. The Name of an instrument may change in conjunction with corporate actions. |
TICKER |
Ticker | Ticker is a specific identifier for a financial instrument that reflects common usage. Tickers are not, however, unique to specific exchanges or specific pricing sources. Tickers may change in conjunction with Corporate Actions. |
EXCH_CODE |
Exchange Code | Code for the trading venue or environment on which the instrument trades. If an exchange is specified, the code will be for the specified exchange. When not specified, the code will be according to the user default exchange, which can be the composite or primary exchange. |
SECURITY_TYP |
Security Type | Description of the specific instrument type within its market sector. |
ID_BB_SEC_NUM_DES |
Security ID Number Description | Descriptor for a financial instrument. Equities: Not unique on the exchange level; must be combined with Feed Source (DX282, FEED_SOURCE) to achieve a unique value at the exchange level. |
MARKET_SECTOR_DESCRIPTION |
Market Sector Description | Market Sector refers to the asset type assigned to the instrument. |
ID_BB_GLOBAL |
Financial Instrument Global Identifier | Twelve character, alphanumeric identifier. The first 2 characters are upper-caseconsonants (including "Y"), the third character is the upper-case "G", characters 4 -11 are any upper-case consonant (including "Y") or integer between 0 and 9, and the last character is a check-digit. An identifier is assigned to instruments of all asset classes, is unique to an individual instrument and once issued will not change for an instrument. For equity instruments an identifier is issued per instrument per trading venue. |
COMPOSITE_ID_BB_GLOBAL |
Composite Financial Instrument Global Identifier | Twelve character, alphanumeric identifier. The first 2 characters are upper-case consonants (including "Y"), the third character is the upper-case "G", characters 4 -11 are any upper-case consonant (including "Y") or integer between 0 and 9, and the last character is a check-digit. The Composite level of assignment is provided in cases wherethere are multiple trading venues for the instrument within a single country or market. The Composite Financial Instrument Global Identifier (FIGI) enables users to link multiple FIGIs at the trading venue-level within the same country or market in order to obtain an aggregated view for that instrument within that country or market. |
ID_BB_GLOBAL_SHARE_CLASS_LEVEL |
Share Class Financial Instrument Global Identifier | Twelve character, alpha-numeric identifier. The first 2 characters are upper-case consonants (including "Y"), the third character is the upper-case "G", characters 4 -11 are any upper-case consonant (including "Y") or integer between 0 and 9, and the last character is a check-digit. A Share Class level Financial Instrument Global Identifier is assigned to an instrument that is traded in more than one country. This enables users to link multiple Composite FIGIs for the same instrument in order to obtain an aggregated view for that instrument across all countries globally. |
ID_BB_UNIQUE |
Unique Identifier | A legacy identifier assigned to all instruments. The construction and length of thisidentifier is different across asset classes. This identifier can also change as a result of corporate actions. |
SECURITY_TYP2 |
Security Type 2 | A description of the security type. |
SECURITY_DESS |
Security Description | A description of the security |
UNIQUE_ID_FUT_OPT |
Unique Identifier for Future Option | Unique ticker with logic for index, currency, single stock futures, commodities andcommodity options. This identifier differs from the Unique Identifier in that it is a logical ticker. |
MARKET_SECTOR |
Market Sector Number | Number of the market sector of the security. Possible returns are: 1. Commodity; 2. Equity; 3. Municipals; 4. Preferred; 6. Money Market; 7. Government; 8. Corporate; 9. Index; 10. Currency; 11. Mortgage; |
SECURITY_SHORT_DES |
Security Short Description | Alternate Short Description for a given security comprised of the ticker, coupon and maturity year (YY). For strips it returns the ticker, coupon, and maturity (M/YY). For corporate securities with Japanese tickers, the series will also be displayed. |
https://github.com/talsan/openfigi/blob/master/references/Open_Symbology_Fields-2a61f8aa4d.pdf