Skip to main content

DIVIDENDS

Get historical dividend data for a given company.

Syntax

=OBB.EQUITY.FUNDAMENTAL.DIVIDENDS(symbol,[start_date],[end_date])

Examples

=OBB.EQUITY.FUNDAMENTAL.DIVIDENDS("AAPL")

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for.True
start_dateTextStart date of the data, in YYYY-MM-DD format.False
end_dateTextEnd date of the data, in YYYY-MM-DD format.False

Data

NameDescription
ex_dividend_dateThe ex-dividend date - the date on which the stock begins trading without rights to the dividend.
amountThe dividend amount per share.
factorfactor by which to multiply stock prices before this date, in order to calculate historically-adjusted stock prices.
currencyThe currency in which the dividend is paid.
split_ratioThe ratio of the stock split, if a stock split occurred.