Stock feature

Stock () Description

Stock () feature is intended to automatically obtain shares prices directly from Yahoo Finance site (Finance.yahoo.com) according to the specified exchange symbol (eg AAPl, Tsla) and the selected date. It supports both historical quotations and current values in real time.

This feature is convenient for creating exchange trackers in Excel tables and will be useful for investors, traders and financial analysts.

The main characteristics of the Stock feature

Syntax:

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

Parameters:

• Ticker: Exchange symbol of the stock.
• [Date]: (Optional) Price setting date. The default value of today's date is used.
• [Indicator]: (Optional) the stock price indicator or its volume of trade ("open", "high", "low", "close", "adjclose", "volume"). Default is used by the closing price ie value "close" .

Example of use

Example 1

Stock () is easy to use. It is enough for you to specify a cell with the stock code and Excel Automatically imports its price at a given date:

=STOCK(Ticker; Date)

We will have the following result:

This example uses the following values:

• Ticker: A2 - the cell with which the stock code is contained ("AAPL") .
• Date: D1 - the price setting date ("30/06/2025") .

Example 2

Relevant data from the site Yahoo Finance :

Download extensions

You can take advantage of the feature Stock () by installing the extension YLC Utilities .

This feature will be available in all files that will be opened in Excel.