Dividend Function

DIVIDEND() Description

The DIVIDEND() function is designed to automatically retrieve 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 Excel (LibreOffice Calc) spreadsheets and will be useful for investors, traders, and financial analysts.

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

Usage Example

Example 1

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

=DIVIDEND(Ticker; Range; Total)

We will have the following result:

In this example, the following values are used:

• 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

In this example, the following values are used:

• 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 Does It Work?

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, press Ctrl+Shift+Enter to enter the array formula, and LO Calc will automatically return a data table.

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.

Ready-made Templates

You can also use ready-made templates to retrieve historical data, financial indicators, or company profile.

To do this, go to the menu YLC Utilities > Template > Company screener and select one of the following reports:

• Profile data ("Profile data")
• Financial data ("Financial data")
• Statistical data ("Statistical data")
• Dividend data ("Dividend data")
• Historical data ("Historical data")

Download Extension

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

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