Yfinance Function

YFINANCE() Description

The YFINANCE() function is designed for automatically getting historical data directly from the Yahoo Finance website (finance.yahoo.com) by a specified stock 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.

Key Features of the YFINANCE Function

Syntax:

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

Parameters:

• Symbol: Stock symbol.
• [StartDate]: (Optional) Start date of the period for getting data. By default, today's date is used.
• [EndDate]: (Optional) End date of the period for getting data. By default, today's date 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, Yes (1) is used.
• [Calendar]: (Optional) Whether to show calendar days: 0-Trading days, 1-Calendar days. By default, 0 (trading days) is used. Used only when Interval is equal to "1d"

Example Usage

Example 1

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

=YFINANCE(Symbol; StartDate; EndDate)

We will get the following result:

The following values are used in this example:

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

Corresponding data from the Yahoo Finance website:

Example 2

The following values are used in this example:

• 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 Yahoo Finance website:

How It Works?

Simply enter the YFINANCE() function into any cell, specifying the symbol and date range. 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 to values - select the entire array and in the menu Data > Calculate choose Formula to Value.

When using a date as text, it must first be converted to a real date, e.g.: DATEVALUE("2026-01-25").

Ready-made Templates

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

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