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".

=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. Use "-" for descending order and "NH" for no header.

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")