Dividend Function

DIVIDEND() Description

The DIVIDEND() function is designed to automatically obtain dividend data directly from the Yahoo Finance website (finance.yahoo.com) by the specified stock ticker symbol (for example, AAPL, NVDA) and the selected date.

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

Key Features of the DIVIDEND Function

Syntax:

=DIVIDEND(Ticker; [Range]; [Total])

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 ("max") is used.
• [Total]: (Optional) Whether to sum values: 0-No, 1-Yes. By default, the value No (0) is used.

Usage Example

Example 1

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

=DIVIDEND(Ticker; Range; Total)

We will have the following result:

The following values are used in this example:

• Ticker: A6:A9 - Range of cells with stock tickers (AAPL, NVDA, MSFT, ORCL).
• Range: B1 - Date range for the last 365 days ("1y").
• Total: B2 - Sum the total amount of dividends for the specified period (1).

Example 2

The following values are used in this example:

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

Corresponding data from the Yahoo Finance website:

How It Works?

The DIVIDEND() function can work both in normal mode and as an array function.

To use it as an array, simply enter the function into any cell, specifying the appropriate parameters. After that, you need to 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 cell in the array and press Ctrl+/.

If it is necessary to convert an array formula into values - select the entire array and in the Data > Calculate menu select Formula to Value.

Download extension

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

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