Funds Function

FUNDS() Description

The FUNDS() function is designed for automatically obtaining mutual investment fund prices (Mutual Funds) directly from the Yahoo Finance website (finance.yahoo.com) by a specified symbol (for example, VFIAX) and a 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 Characteristics 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) Price 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 - Date for which 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").

Corresponding data from the website Yahoo Finance:

How It Works?

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

To use it as an array, simply enter the function into any cell, specifying the relevant parameters. After that, 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.

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 get 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 FUNDS() function by installing the YLC Utilities extension.

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