Yfinance Function

YFINANCE() Description

The YFINANCE() function is designed to automatically retrieve historical data directly from the Yahoo Finance website (finance.yahoo.com) by a specified ticker symbol (e.g., AAPL, NVDA) for a defined period.

This function allows you to analyze market trends directly in Excel (LibreOffice Calc) spreadsheets and is an indispensable tool for financial modeling and in-depth market analysis.

Main Characteristics of the YFINANCE Function

Syntax:

=YFINANCE(Symbol; [StartDate]; [EndDate]; [Interval]; [Header]; [Calendar])

Parameters:

• Symbol: Ticker symbol.
• [StartDate]: (Optional) The start date of the period for data retrieval. By default, the today's date value is used.
• [EndDate]: (Optional) The end date of the period for data retrieval. By default, the today's date value is used.
• [Interval]: (Optional) Data interval ("1d", "1wk", "1mo"). By default, the daily interval "1d" is used.
• [Header]: (Optional) Whether to show the table header: 0-No, 1-Yes. By default, the value Yes (1) is used.
• [Calendar]: (Optional) Whether to show calendar days: 0-Trading days, 1-Calendar days. By default, the value 0 (trading days) is used. Used only when Interval equals "1d"

Usage Example

Example 1

The YFINANCE() function allows you to download an array of historical data. You specify a ticker symbol and a time period, and Excel (Calc) imports the corresponding indicators:

=YFINANCE(Symbol; StartDate; EndDate)

We will have the following result:

In this example, the following values are used:

• Symbol: B1 - Cell with stock code ("AAPL").
• StartDate: B2 - Start date ("2026-02-01").
• EndDate: B3 - End date ("2026-02-09").

Corresponding data from the website Yahoo Finance:

Example 2

In this example, the following values are used:

• Symbol: B1 - Cell with the currency pair symbol ("USDJPY=X").
• StartDate: B2 - Start date ("2026-02-01").
• EndDate: B3 - End date ("2026-02-09").
• Interval: B4 - Daily interval ("1d").
• Header: B5 - Display table header (1).
• Calendar: B6 - Fill all calendar days with data (1).

Corresponding data from the website Yahoo Finance:

How Does It Work?

Just enter the YFINANCE() function into any cell, specifying the symbol and date range. Then 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 an array formula, simply select any cell in the array and press Ctrl+/.

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

Download extension

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

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