Stock Function

STOCK() Description

The STOCK() function is designed for automatic retrieval of stock prices directly from the Yahoo Finance website (finance.yahoo.com) by the specified stock symbol (e.g., AAPL, TSLA) and selected date. It supports both historical quotes and real-time current values.

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

Key Features of the STOCK Function

Syntax:

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

Parameters:

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

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 have the following result:

In this example, the following values are used:

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

Example 2

Corresponding data from the Yahoo Finance website:

Download extension

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

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