Stock Function

STOCK() Description

The STOCK() function is designed to automatically retrieve stock prices directly from the Yahoo Finance website (finance.yahoo.com) by the specified stock ticker (for example, AAPL, NVDA) and selected date. It supports both historical quotes and real-time values.

This function is useful for creating stock trackers in Excel (LibreOffice Calc) and will be beneficial for investors, traders, and financial analysts.

Key Features of the STOCK Function

Syntax:

=STOCK(Ticker; [Date]; [Indicator])

Parameters:

• Ticker: Stock ticker symbol.
• [Date]: (Optional) Date for price retrieval. By default, today's date is used.
• [Indicator]: (Optional) Stock price indicator or trading volume ("open", "high", "low", "close", "adjclose", "volume"). By default, the closing price is used, i.e., the value "close".

Example Usage

Example 1

The STOCK() function is simple to use. You just need to specify the cell with the stock code and Excel (Calc) will automatically import its price for the specified date:

=STOCK(Ticker; Date)

We will get the following result:

In this example, the following values are used:

• Ticker: A2 - Cell containing the stock code ("AAPL").
• Date: D1 - Date for price retrieval ("30/06/2025").

Example 2

In this example, the following values are used:

• Ticker: B1 - Cell containing the stock code ("AAPL").
• Date: A5 - Date for price retrieval ("Aug 1, 2025").
• Indicator: G4 - Value type (trading volume) ("volume").

Corresponding data from the Yahoo Finance website:

Download extension

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

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