Skip to main content

HISTORICAL

Get historical price data for a given stock. This includes open, high, low, close, and volume.

Syntax

=OBB.EQUITY.PRICE.HISTORICAL(symbol,[interval],[start_date],[end_date])

Examples

=OBB.EQUITY.PRICE.HISTORICAL("AAPL")
=OBB.EQUITY.PRICE.HISTORICAL("AAPL","1d")

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for. Multiple comma separated items allowed.True
intervalTextTime interval of the data to return.False
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
dateThe date of the data.
openThe open price.
highThe high price.
lowThe low price.
closeThe close price.
volumeThe trading volume.
vwapVolume Weighted Average Price over the period.
averageAverage trade price of an individual equity during the interval.
changeChange in the price of the symbol from the previous day.
percent_changePercent change in the price of the symbol from the previous day.
adj_openThe adjusted open price.
adj_highThe adjusted high price.
adj_lowThe adjusted low price.
adj_closeThe adjusted close price.
adj_volumeThe adjusted volume.
fifty_two_week_high52 week high price for the symbol.
fifty_two_week_low52 week low price for the symbol.
factorfactor by which to multiply equity prices before this date, in order to calculate historically-adjusted equity prices.
split_ratioRatio of the equity split, if a split occurred.
dividendDividend amount, if a dividend was paid.
close_timeThe timestamp that represents the end of the interval span.
frequencyThe data time frequency.
intraperiodIf true, the equity price represents an unfinished period (be it day, week, quarter, month, or year), meaning that the close price is the latest price available, not the official close price for the period