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) by the specified ticker symbol (for example, SPY, VOO) and the 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.

Key Features of the ETF Function

Syntax:

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

Parameters:

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

Example of Use

Example 1

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

=ETF(Symbol; Date; Indicator)

We will get the following result:

The following values are used in this example:

• Symbol: B5:B9 - Range of cells with fund symbols (SPY, VOO, SOXS, ZSL, SQQQ).
• Date: B1 - The date for which indicators should be obtained. ("2026-02-05").
• Indicator: C4:H4 - Range of cells 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 date ("Feb 5, 2026").
• Indicator: G4 - Indicator (trading volume) ("volume").

Corresponding data from Yahoo Finance:

How It Works?

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

To use it as an array, simply 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 the data table.

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

If you need to convert the array formula to values - select the entire array and in the Data > Calculate menu 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").

Pre-built templates

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

To do this, go to the YLC Utilities > Template > Company screener menu and select 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 the extension

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

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