Forex Function

FOREX() Description

The FOREX() function is designed to automatically retrieve international currency exchange rates directly from the Yahoo Finance website (finance.yahoo.com) for a specified currency pair (e.g., EURUSD, USDJPY) and selected date. It supports both historical quotes and real-time values.

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

Key Features of the FOREX Function

Syntax:

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

Parameters:

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

Usage Example

Example 1

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

=FOREX(Pair; Date)

We will get the following result:

The following values are used in this example:

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

Example 2

The following values are used in this example:

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

Corresponding data from the Yahoo Finance website:

Download extension

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

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