The NBSE() function is designed to automatically obtain the official exchange rate value of the Swedish krona directly from the Central Bank of Sweden website (riksbank.se) for the specified code and date.
The NBSE function significantly facilitates work with exchange rates, especially for those who work with finance or keep records in different currencies. Instead of manually entering rates, you just need to use this function to get the current data.
Also, you can use the tool "Official exchange rates", which inserts the exchange rate for selected cells in one click.
=NBSE(CurrCode; CurrDate)The NBSE() function is easy to use. You just need to enter the currency code and date into the corresponding formula cells, and Excel (Calc) will automatically obtain the current currency rate:
=NBSE(CurrCode; CurrDate)
We will have the following result:
The following values are used in this example:
The NBSE() function can work both in normal mode and as an array function.
To use it as an array, simply enter the function into any cell, specifying the relevant parameters. After that, you need to press Ctrl+Shift+Enter to enter the array formula and LO Calc will automatically return a table with the data.
To select all cells related to the array formula, simply select any cell in the array and press Ctrl+/.
If you need to convert an array formula into values - select the entire array and in the
When using the date in text format, it must first be converted into a real date, for example:
You can use the NBSE() function by installing the YLC Utilities extension.
After this, this function will be available in all files opened in Excel (LibreOffice Calc).
