Import of currency rates from Israel's Bank's website

Nbil () description

NBIL () function is intended to automatically obtain the value of the official course of Israeli Shekel directly from The site of the Bank of Israel (boi.org.il) according to the specified code and date.

The NBIL function makes it easy to work with exchange rates, especially for those who work with finances or keep records in different currencies. Instead of manual courses, it is enough for you to use this feature to obtain up -to -date data.

Also, you can use The Official Currency Exchange Course Instrument , which inserts the currency rate for selected cells in one click.

The main characteristics of NBIL function

Syntax:

=NBIL(CurrCode; CurrDate)

Parameters:

• CurrCode: The letter code of the currency at which you want to get the course.
• CurrDate: Date of the exchange rate.

Example of use

NBIL () is easy to use. It is enough for you to enter the currency code and date into the appropriate formula cells and Excel will automatically receive a current currency exchange rate:

=NBIL(CurrCode; CurrDate)

We will have the following result:

This example uses the following values:

• CurrCode: A2 - The letter of the US dollar ("USD") .
• CurrDate: D1 - Date of setting the course ("30/06/2025") .

Download extensions

You can take advantage of the feature Nbil () by installing the extension YLC Utilities .

This feature will be available in all files that will be opened in Excel.