Dividend Function

DIVIDEND() Description

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

This function is convenient for creating stock trackers in Excel (LibreOffice Calc) spreadsheets 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 easy to use. You just need to specify the cell with the stock code, and Excel (Calc) will automatically import the dates and amounts of dividends paid within the specified range:

=DIVIDEND(Ticker; Range)

We will get the following result:

This example uses the following values:

• Ticker: B1 - The 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. After that, 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 you need to convert an array formula to values - select the entire array and in the menu Data > Calculate 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 opened in Excel (LibreOffice Calc).