MeridianMERIDIAN

FIGI

Financial Instrument Global Identifier. 12-character alphanumeric code assigned by Bloomberg and the Object Management Group. Format: 2 consonants (no vowels) + 'G' + 8 alphanumeric characters (no vowels) + 1 check digit. Used globally for securities identification in trading and clearing systems.

FIGI

finance.securities.figi

Financial Instrument Global Identifier. 12-character alphanumeric code assigned by Bloomberg and the Object Management Group. Format: 2 consonants (no vowels) + 'G' + 8 alphanumeric characters (no vowels) + 1 check digit. Used globally for securities identification in trading and clearing systems.

Domain
finance
Category
securities
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "BBG000BLNQ16"
→ finance.securities.figi

DuckDB

Detect
SELECT finetype('BBG000BLNQ16');
-- → 'finance.securities.figi'
Cast expression
UPPER(CAST({col} AS VARCHAR))
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'finance.securities.figi';

Struct Expansion

Expression
body: SUBSTRING({col}, 4, 8)
check_digit: SUBSTRING({col}, 12, 1)
prefix: SUBSTRING({col}, 1, 2)

JSON Schema

finetype schema finance.securities.figi
{
  "$id": "https://meridian.online/schemas/finance.securities.figi",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Financial Instrument Global Identifier. 12-character alphanumeric code assigned by Bloomberg and the Object Management Group. Format: 2 consonants (no vowels) + 'G' + 8 alphanumeric characters (no vowels) + 1 check digit. Used globally for securities identification in trading and clearing systems.",
  "examples": [
    "BBG000BLNQ16",
    "BBG000B9XRY4",
    "BBG000BVPV84",
    "BBG000BPH459",
    "BBG000GZQ728"
  ],
  "pattern": "^[BCDFGHJKLMNPQRSTVWXYZ]{2}G[BCDFGHJKLMNPQRSTVWXYZ0-9]{8}\\d$",
  "title": "FIGI",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "UPPER(CAST({col} AS VARCHAR))"
}

Examples

BBG000BLNQ16BBG000B9XRY4BBG000BVPV84BBG000BPH459BBG000GZQ728

Aliases

bloomberg_idopen_figi

Type Registry