Dividend Function

DIVIDEND() Description

The DIVIDEND() function is designed for automatic retrieval of dividend data directly from the Yahoo Finance website (finance.yahoo.com) by the specified stock ticker symbol (e.g., AAPL, NVDA) and selected date.

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 DIVIDEND Function

Syntax:

=DIVIDEND(Ticker; [Range])

Parameters:

• Ticker: Stock ticker symbol.
• [Range]: (Optional) Date range: "1d", "5d", "1mo", "3mo", "6mo", "1y", "2y", "5y", "10y", "ytd", "max". By default, the maximum range is used ("max").

Example Usage

The DIVIDEND() function is simple to use. You just need to specify a cell with the stock code and Excel (Calc) automatically imports the dates and amounts of dividends paid within the specified range:

=DIVIDEND(Ticker; Range)

We will get the following result:

In this example, the following values are used:

• Ticker: B1 - Cell containing the stock ticker ("AAPL").
• Range: B2 - Date range ("1y").

Corresponding data from the Yahoo Finance website:

How It Works?

Simply enter the DIVIDEND() function into any cell, specifying the ticker and date range. Then press Ctrl+Shift+Enter to enter the array formula and LO Calc will automatically return a table with data.

To select all cells associated with the array formula, simply select any array cell and press Ctrl+/.

If you need to convert an array formula to values - select the entire array and in the Data > Calculate menu choose Formula to Value.

Download extension

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

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