Jorge Guerrero

Logo

Economist and data scientist working at the intersection of finance, data science, and policy, building models and visualizations to understand and navigate financial topics.



View My LinkedIn Profile

View My GitHub Profile

Bank Exposures - static visualization

Jorge Guerrero

Description

Explore the network of bank exposures: from reporting country → counterparty country via the Locational banking statistics (LBS) published by the Bank for International Settlement (BIS) to assess which countries have hihger expositions. The final visualization attemps to explore in an easy language and intuitive lenaguage the global finane interconnections.

Data

The locational banking statistics (LBS) measure international banking activity from a residence perspective, focusing on the location of the banking office. The LBS capture the outstanding claims (financial assets) and liabilities of internationally active banks located in reporting countries on counterparties residing in more than 200 countries. Banks record their positions on an unconsolidated basis, including intragroup positions between offices of the same banking group. The LBS capture around 95% of all cross-border banking activity.

The data is published in US dollars, quarterly, with timeseries since 1980 and it is accesible through API. I am planning to use timeseries since 2000 and end-date of 2024. This dataset contains the cross-country expositions.

In particular, for the static visualization we are working with a subset of the series, filtered in the website and retrieved with the API specific link.

Applied filters to the series:

  1. Time and frequency: quarterly last 25 years (Q4-2000 to Q3-2025)
  2. Units: outstanding amounts in USD
  3. Balance sheet position: claims (what the banks lend) and liabilities (what the banks borrowed)
  4. Instruments: A- all intruments (include loans, deposits, derivatives)
  5. Currency denominated (nominal): TO1 - all currencies
  6. Currency type: A - all currencies (add domestic, foreign and unclassified)
  7. Parent country: 5J - all countries
  8. Reporting bank type: A - all reporting banks and institutions (include domestic and foreign)
  9. Reporting country: distinct values by ISO-2 country code
  10. Counterparty sector: A - all sectors (include banks,non financial corporations, NBFI, government, Households, etc.)
  11. Counterparty country: distinct values by ISO-2 country code
  12. Position type: cross border

The work acomplishes to illustrate that:

Reproduce graphs

To reproduce the visualizations included in the infographic you could run the jupyter notebook: “../src/milestone_2.2.ipynb”

Data Sources

Bank for International Settlements. (2025). Locational Banking Statistics (LBS). BIS Data Portal. https://data.bis.org/topics/LBS