Official currency exchange rates

External Data > Currency exchange rates

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

This makes working with exchange rates much easier, especially for those who work with finances or keep records in different currencies.

Instead of manually entering rates, you can simply use this utility to quickly get up-to-date data.

Screenshot

After application:

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

After application:

Checking the correct exchange rate

For financial or accounting calculations, it is very important to check the correctness of the calculations and the absence of errors. For this, the tool "Official currency exchange rates" there is a built-in button Check Online to check 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:

Central Bank of Brazil website :

List of National Banks

Official exchange rates of the following National (central) banks are currently available:

• National Bank of Ukraine (bank.gov.ua);
• National Bank of Kazakhstan (nationalbank.kz);
• Central Bank of Uzbekistan (cbu.uz);
• of the 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);
• of the 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).

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use the tool.

Download extension

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

After that, this function will be available in all files that are opened in Excel .