Daily dividend adjusted time series

A daily dividend adjusted time-series is the historical price performance of an asset on a daily basis between a start and end date, including dividend adjustments. This can be thought of as the adjusted chart or adjusted OHLCV for the asset. Use the SF_TIMESERIES() function and set the period argument to "dailyAdj".

Because the series is adjusted for both dividends and splits, you can use it to calculate total returns — the combined price and dividend performance of the asset — rather than price-only returns.

To calculate a total return, divide the latest adjusted close by the oldest adjusted close and subtract 1. With "-&NH" the oldest value is the first row and the latest is the last row.

=SF_TIMESERIES(symbol, startDate, endDate, period, metric, options)

• symbol is the stock or coin ticker symbol, either as a cell reference or a string (e.g. "AAPL").

• startDate and endDate are in ISO format YYYY-MM-DD.

• period set to "dailyAdj" for a dividend adjusted daily time-series.

• metric selects which data to return. Leave blank or use "all" to return every metric.

• options format the output. Results are returned latest first by default. Use "-" to reverse the order so the oldest date comes first, and "NH" to remove the header row. Combine them with &, e.g. "-&NH".

SheetsFinance has 30+ years of daily data available. You can enter dates directly, reference them from other cells, or use in-built functions such as TODAY() to generate a time-series relative to today's date.

=SF_TIMESERIES("AAPL", "2010-05-04", "2023-10-26", "dailyAdj", "all")

Dividend adjusted metrics

The available dividend adjusted metrics are:

• All ("all")

• Date ("date")

• Adj. Open ("adjOpen")

• Adj. High ("adjHigh")

• Adj. Low ("adjLow")

• Adj. Close ("adjClose")

• Volume ("volume")