ETF Function

ETF() Description

The ETF() function is designed to automatically obtain stock prices of exchange-traded funds (ETFs) directly from the Yahoo Finance website (finance.yahoo.com) using a specified symbol (for example, SPY, VOO) and a selected date.

This function allows you to track the value of ETF portfolios directly in Excel (LibreOffice Calc) spreadsheets, which significantly simplifies investment analysis and market monitoring for users.

Main Characteristics of the ETF Function

Syntax:

=ETF(Symbol; [Date]; [Indicator])

Parameters:

• Symbol: Exchange symbol of the fund (for example, "SPY", "VOO").
• [Date]: (Optional) Price setting date. The current date is used by default.
• [Indicator]: (Optional) Price indicator or trading volume ("open", "high", "low", "close", "adjclose", "volume"). The closing price "close" is used by default.

Example Usage

Example 1

The ETF() function automates the collection of quote data. You need to specify the fund ticker, and Excel (Calc) will automatically download the data:

=ETF(Symbol; Date; Indicator)

We will have the following result:

The following values are used in this example:

• Symbol: B5:B9 - Cell range with fund symbols (SPY, VOO, SOXS, ZSL, SQQQ).
• Date: B1 - The date for which the indicators should be obtained. ("2026-02-05").
• Indicator: C4:H4 - Cell range with indicators (open, high, low, close, adjclose, volume).

Example 2

The following values are used in this example:

• Symbol: B1 - Cell with the fund symbol ("SPY").
• Date: A5 - Price setting date ("Feb 5, 2026").
• Indicator: G4 - Indicator (trading volume) ("volume").

Corresponding data from the Yahoo Finance website:

How Does It Work?

The ETF() function can work both in normal mode and as an array function.

To use it as an array, just enter the function in 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 cell in the array and press Ctrl+/.

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

Download the Extension

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

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