Inter-day time series

An inter-day time-series covers intervals greater than one day, such as one week, one month, or one year. Use the SF_TIMESERIES() function and set the period argument to the desired interval.

=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 one of the inter-day intervals listed below.

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

=SF_TIMESERIES("AAPL", "2020-01-01", "2023-10-26", "1week", "all")

Inter-day intervals

The supported inter-day intervals are:

• 1 week ("1week")

• 1 month ("1month")

• 1 year ("1year")

Inter-day metrics

The available inter-day metrics are:

• All ("all")

• Date ("date")

• Open ("open")

• High ("high")

• Low ("low")

• Close ("close")

• Volume ("volume")