Official currency exchange rates

Import > Currency exchange rates

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

This significantly simplifies working with currency rates, especially for those who work with finances or keep records in different currencies.

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

Screenshot

After application:

Launching 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, just click the Add Formula button. For example, for the Central Bank of Brazil, the NBBR() function will be added with the corresponding values:

After application:

Checking the correctness of the exchange rate

For financial or accounting calculations, it is very important to check the correctness of calculations and the absence of errors. 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 currency exchange rate website:

Website of the Central Bank of Brazil:

List of National Banks

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

• 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);
• Central bank of the European Union (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).

How much time will it save?

By 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 the extension

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

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