Official currency exchange rates

Import > Currency exchange rates

This utility will help you to get currency exchange rates from the official websites of national banks of many countries.

This significantly simplifies work with exchange rates, especially for those who work with finances or maintain records in different currencies.

Instead of manual entry of rates, you just need to use this utility to quickly get up-to-date data.

Screenshot

After applying:

Running this tool

Click YLC Utilities > Import > Currency exchange rates :

Exchange rate as a formula

You can also get the exchange rate value using the corresponding function. To do this, simply click the Add Formula button. For example, for the Central Bank of Brazil, the NBBR() function will be added with the corresponding values:

After applying:

Checking the correctness of the exchange rate

For financial or accounting calculations, checking for calculation correctness and absence of errors is very important. For this purpose, the "Official currency exchange rates" tool has a built-in Check Online button to verify data on the official websites of national (central) banks. By clicking this button, you will be automatically redirected to the corresponding website with exchange rates:

Website of the Central Bank of Brazil:

List of National Banks

Currently, official currency exchange rates are available from the following National (central) banks:

• National Bank of Ukraine (bank.gov.ua);
• National Bank of Kazakhstan (nationalbank.kz);
• Central Bank of Uzbekistan (cbu.uz);
• Central Bank of Azerbaijan (cbar.az);
• National Bank of Moldova (bnm.md);
• National Bank of Georgia (nbg.gov.ge);
• Central Bank of Turkmenistan (cbt.tm);
• National Bank of Kyrgyzstan (nbkr.kg);
• National Bank of Tajikistan (nbt.tj);
• Central Bank of Armenia (cba.am);
• Bank of Lithuania (lb.lt);
• European Central Bank (ecb.eu);
• Central Bank of Russia (cbr.ru);
• National Bank of Romania (bnro.ro);
• Central Bank of Brazil (bcb.gov.br).
• Bank of Israel (boi.org.il).
• Reserve Bank of Australia (rba.gov.au).
• Central Bank of Norway (norges-bank.no).
• Bank of Canada (bankofcanada.ca).
• Bank of England (bankofengland.co.uk).
• Sveriges Riksbank (Central Bank of Sweden) (riksbank.se).
• Danmarks Nationalbank (Central Bank of Denmark) (nationalbanken.dk).
• National Bank of Poland (nbp.pl).
• Swiss National Bank (snb.ch).
• Czech National Bank (cnb.cz).
• Hungarian National Bank (mnb.hu).

How much time will this save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use Excel (Calc), the volume of data you work with, and how often you use this tool.

Download extension

You can use the Currency exchange rates utility by installing the YLC Utilities extension.

After this, this function will be available in all files opened in Excel (LibreOffice Calc).