Forex Function

FOREX() Description

The FOREX() function is designed for automatic retrieval of international currency exchange rates directly from Yahoo Finance website (finance.yahoo.com) for a specified currency pair (for example, EURUSD, USDJPY) and a selected date. It supports both historical quotes and current real-time values.

This function is convenient for creating exchange trackers in tables Excel (LibreOffice Calc) and will be useful for investors, traders, and financial analysts.

Key Characteristics of the FOREX Function

Syntax:

=FOREX(Pair; [Date]; [Indicator])

Parameters:

• Pair: Exchange symbol of the currency pair.
• [Date]: (Optional) Date for setting the exchange rate. By default, today's date is used.
• [Indicator]: (Optional) Indicator of the currency pair's rate type ("open", "high", "low", "close"). By default, the closing price is used, i.e. the value "close".

Example of Use

Example 1

The FOREX() function is easy to use. You just need to specify the cell with the currency pair code and Excel (Calc) automatically imports the exchange rate of these currencies for the specified date:

=FOREX(Pair; Date)

We will get the following result:

In this example, the following values are used:

• Pair: A2 - Cell containing the currency pair code ("EURUSD").
• Date: D1 - Date of rate setting ("30/06/2025").

Example 2

In this example, the following values are used:

• Pair: B1 - Cell containing the currency pair code ("EURUSD").
• Date: A5 - Date of rate setting ("Aug 1, 2025").
• Indicator: E4 - Value type (closing rate) ("close").

Corresponding data from the website Yahoo Finance:

Download extension

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

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