SheetsFinance Docs
Financial Calendars

Dividends Calendar

Use the SF_CALENDAR() function with type="dividends" to retrieve historic and upcoming dividend payment data. The function returns rows for each dividend event within the requested date range and the metrics you select.

=SF_CALENDAR(searchTerms, "dividends", startDate, endDate, metrics, options)

The maximum date range for a single call is 90 days. If the range between startDate and endDate is larger, it is truncated to 90 days. For longer ranges, make multiple calls and combine them with HSTACK or VSTACK.

Available metrics

Chain metrics together with & or use "all" to return every column.

  • Date ("date")

  • Symbol ("symbol")

  • Dividend ("dividend")

  • Adjusted Dividend ("adjDividend")

  • Record Date ("recordDate")

  • Payment Date ("paymentDate")

  • Declaration Date ("declarationDate")

  • Yield ("yield")

  • Frequency ("frequency")

Examples

Filter by market suffix

Return all dividends on the Frankfurt Stock Exchange between March and June 2024.

=SF_CALENDAR(".DE", "dividends", "2024-03-01", "2024-06-01", "all")

Filter by exact symbol

Use the $ exact-match operator to return dividend data for Microsoft only.

=SF_CALENDAR("$MSFT", "dividends", TODAY(), TODAY()+90, "date&dividend&paymentDate&yield")

For full syntax details, including searchTerms filtering and the options parameter, see the Financial Calendars overview.

Was this helpful?
Was this helpful?