Function Funds

FUNDS() Description

The FUNDS() function is designed to automatically obtain prices for mutual investment funds (Mutual Funds) directly from the Yahoo Finance website (finance.yahoo.com) for the specified symbol (for example, VFIAX) and the selected date. It allows you to obtain both historical prices and current asset value indicators.

This function simplifies investment portfolio management in Excel (LibreOffice Calc) spreadsheets and is an indispensable tool for long-term investors.

Main Features of the FUNDS Function

Syntax:

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

Parameters:

• Symbol: Exchange symbol of the mutual fund.
• [Date]: (Optional) Price setting date. By default, today's date is used.
• [Indicator]: (Optional) Value or volume indicator ("open", "high", "low", "close", "adjclose", "volume"). By default, the closing price "close" is used.

Usage Example

Example 1

Using the FUNDS() function is very simple. Just specify the fund ticker and date, and Excel (Calc) will automatically download the data:

=FUNDS(Symbol; Date; Indicator)

We will have the following result:

The following values are used in this example:

• Symbol: B5:B9 - Cell range with fund codes (VFIAX, SPPSX, APWEX, ICBMX, UTPIX).
• Date: B1 - The date for which the indicators need to 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 - Fund symbol ("VFIAX").
• Date: A5 - Price setting date ("Feb 5, 2026").
• Indicator: G4 - Indicator (trading volume) ("volume").

Relevant data from the Yahoo Finance website:

How It Works?

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

To use 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, just 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 Data > Calculate menu select Formula to Value.

Download Extension

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

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