src.lei_extract_anchor_leis Namespace Reference

Functions
Path	get_lei_data_dir ()
list	extract_ecb_sis (str filepath)
list	extract_uk_pra (str filepath)
	main ()

Variables
dict	COUNTRY_NAME_TO_ISO
list	MANUAL_ANCHORS
list	SOVEREIGN_ANCHORS
list	CENTRAL_BANK_ANCHORS
list	SUPRANATIONAL_ANCHORS

Detailed Description

Extract anchor LEIs from regulatory lists into a single JSON file.

Parses:
  - ECB SSM Significant Institutions list (xlsx)
  - Bank of England PRA Banks list (csv)
  - Hand-curated G-SIB / major institution LEIs (US, Asia-Pacific, Canada)

Output: external/lei/anchor_leis.json

Usage:
    python lei_extract_anchor_leis.py

Function Documentation

get_lei_data_dir()

Path get_lei_data_dir

(

)

Get the path to external/lei directory.

Here is the caller graph for this function:

extract_ecb_sis()

list extract_ecb_sis

(

str

filepath

)

Extract LEIs from the ECB SSM Significant Institutions list.

Parses the 'SIs' sheet. Top-level groups have a sequential number in
column 2; sub-entities have column 2 blank. We extract all entities
with valid LEI codes.

Here is the caller graph for this function:

extract_uk_pra()

list extract_uk_pra

(

str

filepath

)

Extract LEIs from the Bank of England PRA Banks list.

CSV with headers at row 10 (0-indexed row 9): Firm Name, FRN, LEI.
Multiple sections (UK-incorporated, overseas branches, Gibraltar, EEA).

Here is the caller graph for this function:

Variable Documentation

COUNTRY_NAME_TO_ISO

dict COUNTRY_NAME_TO_ISO

Initial value:

=  {
    "Austria": "AT", "Belgium": "BE", "Bulgaria": "BG", "Croatia": "HR",
    "Cyprus": "CY", "Czech Republic": "CZ", "Czechia": "CZ",
    "Denmark": "DK", "Estonia": "EE", "Finland": "FI", "France": "FR",
    "Germany": "DE", "Greece": "GR", "Hungary": "HU", "Iceland": "IS",
    "Ireland": "IE", "Italy": "IT", "Latvia": "LV", "Lithuania": "LT",
    "Luxembourg": "LU", "Malta": "MT", "Netherlands": "NL", "Norway": "NO",
    "Poland": "PL", "Portugal": "PT", "Romania": "RO", "Slovakia": "SK",
    "Slovenia": "SI", "Spain": "ES", "Sweden": "SE",
}

MANUAL_ANCHORS

list MANUAL_ANCHORS

Initial value:

=  [
    # --- United States (holding companies) ---
    {"lei": "8I5DZWZKVSZI1NUHU748", "name": "JPMorgan Chase & Co.", "source": "manual", "country": "US"},
    {"lei": "9DJT3UXIJIZJI4WXO774", "name": "Bank of America Corporation", "source": "manual", "country": "US"},
    {"lei": "6SHGI4ZSSLCXXQSBB395", "name": "Citigroup Inc.", "source": "manual", "country": "US"},
    {"lei": "784F5XWPLTWKTBV3E584", "name": "The Goldman Sachs Group, Inc.", "source": "manual", "country": "US"},
    {"lei": "IGJSJL3JD5P30I6NJZ34", "name": "Morgan Stanley", "source": "manual", "country": "US"},
    {"lei": "PBLD0EJDB5FWOLXP3B76", "name": "Wells Fargo & Company", "source": "manual", "country": "US"},
    {"lei": "WFLLPEPC7FZXENRZV188", "name": "The Bank of New York Mellon Corporation", "source": "manual", "country": "US"},
    {"lei": "549300ZFEEJ2IP5VME73", "name": "State Street Corporation", "source": "manual", "country": "US"},
    # --- Asia-Pacific ---
    {"lei": "353800V2V8PUY9TK3E06", "name": "Mitsubishi UFJ Financial Group (MUFG)", "source": "manual", "country": "JP"},
    {"lei": "549300HS3WTRS6D88H32", "name": "Mizuho Financial Group", "source": "manual", "country": "JP"},
    {"lei": "35380028MYWPB6AUO129", "name": "Sumitomo Mitsui Financial Group (SMFG)", "source": "manual", "country": "JP"},
    {"lei": "5493002ERZU2K9PZDL40", "name": "Industrial and Commercial Bank of China (ICBC)", "source": "manual", "country": "CN"},
    {"lei": "54930053HGCFWVHYZX42", "name": "Bank of China Limited", "source": "manual", "country": "CN"},
    {"lei": "5493001KQW6DM7KEDR62", "name": "China Construction Bank Corporation", "source": "manual", "country": "CN"},
    {"lei": "549300E7TSGLCOVSY746", "name": "Agricultural Bank of China Limited", "source": "manual", "country": "CN"},
    # --- Canada ---
    {"lei": "ES7IP3U3RHIGC71XBU11", "name": "Royal Bank of Canada", "source": "manual", "country": "CA"},
    {"lei": "PT3QB789TSUIDF371261", "name": "The Toronto-Dominion Bank", "source": "manual", "country": "CA"},
]

SUPRANATIONAL_ANCHORS

list SUPRANATIONAL_ANCHORS

Initial value:

=  [
    {"lei": "5493006YXS1U5GIHE750", "name": "European Investment Bank", "source": "supranational", "country": "LU"},
    {"lei": "222100W4EEAQ77386N50", "name": "European Stability Mechanism", "source": "supranational", "country": "LU"},
    {"lei": "222100OW6UHQXNHKQ143", "name": "European Financial Stability Facility", "source": "supranational", "country": "LU"},
    {"lei": "ZTMSNXROF84AHWJNKQ93", "name": "International Bank for Reconstruction and Development", "source": "supranational", "country": "US"},
    {"lei": "549300X0MVH42CY8Q105", "name": "Asian Development Bank", "source": "supranational", "country": "PH"},
    {"lei": "VKU1UKDS9E7LYLMACP54", "name": "Inter-American Development Bank", "source": "supranational", "country": "US"},
    {"lei": "549300LNCLMO3ITVCU07", "name": "African Development Bank", "source": "supranational", "country": "CI"},
    {"lei": "549300UYNXMI821WYG82", "name": "Council of Europe Development Bank", "source": "supranational", "country": "FR"},
    {"lei": "213800HYL1S7VAXG6Z48", "name": "Nordic Investment Bank", "source": "supranational", "country": "FI"},
]