Not sure how to get the Effective Excahnge Rate from the site

General
1

Hi, I’m trying to get the REER from the BIS website but am not seeing the files there.Do i need to contract them to get this information?

2

Hi,

It seems the data retrieval method has been changed. You can try the following:

  • Go to the BIS Effective exchange rates page

  • URL: https://data.bis.org/topics/EER

  • At the bottom of that page, under Helpful links, click “Bulk downloads”.

  • On the Bulk downloads page, scroll to the section “Effective exchange rates”.
    There you’ll see several links, including:

  • Effective exchange rates (CSV)

  • Effective exchange rates (CSV, flat)

  • (and two SDMX options) BIS Data Portal+1

  • Click “Effective exchange rates (CSV)”.

  • This downloads a ZIP file that contains the full EER dataset (nominal & real, broad & narrow, various frequencies).

  • Unzip the file and open the CSV in Excel / Python / R.

There is one column called “EER_TYPE” for REER, you have to filter it to “R” and you will get the REER data for all the countries. You can then filter based on which countries you are looking for.

Hope this helps.