Forex Function

FOREX() Description

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

This function is convenient for creating stock trackers in tables Excel (LibreOffice Calc) 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 establishment. 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".

Example Usage

Example 1

The FOREX() function is easy to use. You just need to specify the 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:

This example uses the following values:

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

Example 2

This example uses the following values:

• 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:

How It Works?

The FOREX() function can work in normal mode as well as an array function.

To use it as an array, simply enter the function into any cell, specifying the appropriate parameters. After that, you need to press Ctrl+Shift+Enter to enter the array formula and LO Calc will automatically return a table with data.

To select all cells associated with the array formula, simply select any array cell and press Ctrl+/.

If you need to convert an array formula to values - select the entire array and in the menu Data > Calculate select Formula to Value.

When using a date as text, it must first be converted into a real date, for example: DATEVALUE("2026-01-25").

Ready-made Templates

You can also use ready-made templates to retrieve historical data, financial indicators, or a company profile.

To do this, go to the menu YLC Utilities > Template > Company screener and choose one of the following reports:

• Profile data ("Profile Data")
• Financial data ("Financial Data")
• Statistical data ("Statistical Data")
• Dividend data ("Dividend Data")
• Historical data ("Historical Data")

Download Extension

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

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