Official exchange rates

External Data > Currency exchange rates

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

This greatly simplifies working with currency rates, especially for those who work with finances or keep 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:

Launching this tool

Click YLC Utilities > External Data > Currency exchange rates :

Exchange rate as a formula

You can also get the exchange rate value using the appropriate 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 corresponding values:

After applying:

Checking the correctness of the exchange rate

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

Website of the Central Bank of Brazil:

List of National Banks

Currently, official 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).
• Central Bank of Canada (bankofcanada.ca).

How much time will this 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 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 that will be opened in Excel (LibreOffice Calc).