NIKKEI225 function

NIKKEI225() Description

The NIKKEI225() function is designed for automatic retrieval of stock prices of companies from the "NIKKEI 225" index, traded on the Tokyo Stock Exchange directly from the site Yahoo Finance (finance.yahoo.com) by the specified stock symbol (e.g., 9202, 7201) and selected date. It supports both historical quotes and current real-time values.

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

Key Features of the NIKKEI225 Function

Syntax:

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

Parameters:

• Ticker: Stock symbol or "INDEX".
• [Date]: (Optional) Date of price setting. By default, today's date is used.
• [Indicator]: (Optional) Stock price indicator or its 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 NIKKEI225() function is easy to use. You just need to specify the cell with the stock code and Excel (Calc) automatically imports its price for the specified date:

=NIKKEI225(Ticker; Date)

We will have the following result:

The following values are used in this example:

• Ticker: B3 - Cell containing the stock code ("9202").
• Date: C1 - Date of price setting ("Aug 1, 2025").

Example 2

The following values are used in this example:

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

Corresponding data from the site Yahoo Finance:

Download extension

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

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