Import of currency rates from the Central Bank of Norway website

NBNO() Description

The NBNO() function is designed for automatic retrieval of the official Norwegian krone exchange rate value directly from the Central Bank of Norway website (norges-bank.no) by the specified code and date.

The NBNO function significantly simplifies working with currency rates, especially for those who work with finances or keep records in various currencies. Instead of manual entry of rates, you just need to use this function to get current data.

Also, you can use the "Official Exchange Rates" tool, which inserts currency rates for selected cells in one click.

Main Characteristics of the NBNO Function

Syntax:

=NBNO(CurrCode; CurrDate)

Parameters:

• CurrCode: Alphanumeric code of the currency for which you want to get the rate.
• CurrDate: Date of currency rate setting.

Example of Use

The NBNO() function is simple to use. You just need to enter the currency code and date into the corresponding cells of the formula, and Excel (Calc) will automatically get the current currency rate:

=NBNO(CurrCode; CurrDate)

We will have the following result:

The following values are used in this example:

• CurrCode: A2 - alphanumeric code of the US dollar ("USD").
• CurrDate: D1 - date of rate setting ("30/06/2025").

Download extension

You can use the NBNO() function by installing the YLC Utilities extension.

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