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 Yahoo Finance (finance.yahoo.com) website by the specified stock ticker (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 Excel (LibreOffice Calc) spreadsheets and will be useful for investors, traders, and financial analysts.

Main Characteristics of the NIKKEI225 Function

Syntax:

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

Parameters:

• Ticker: Stock ticker 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".

Usage Example

Example 1

The NIKKEI225() function is easy 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:

=NIKKEI225(Ticker; Date)

We will get the following result:

In this example, the following values are used:

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

Example 2

In this example, the following values are used:

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

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).