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
Name | Type | Description | Required |
---|---|---|---|
symbol | Text | Symbol to get data for. Multiple comma separated items allowed. | True |
interval | Text | Time interval of the data to return. | False |
start_date | Text | Start date of the data, in YYYY-MM-DD format. | False |
end_date | Text | End date of the data, in YYYY-MM-DD format. | False |
Data
- fmp
Name | Description |
---|---|
date | The date of the data. |
open | The open price. |
high | The high price. |
low | The low price. |
close | The close price. |
volume | The trading volume. |
vwap | Volume Weighted Average Price over the period. |
average | Average trade price of an individual equity during the interval. |
change | Change in the price of the symbol from the previous day. |
percent_change | Percent change in the price of the symbol from the previous day. |
adj_open | The adjusted open price. |
adj_high | The adjusted high price. |
adj_low | The adjusted low price. |
adj_close | The adjusted close price. |
adj_volume | The adjusted volume. |
fifty_two_week_high | 52 week high price for the symbol. |
fifty_two_week_low | 52 week low price for the symbol. |
factor | factor by which to multiply equity prices before this date, in order to calculate historically-adjusted equity prices. |
split_ratio | Ratio of the equity split, if a split occurred. |
dividend | Dividend amount, if a dividend was paid. |
close_time | The timestamp that represents the end of the interval span. |
frequency | The data time frequency. |
intraperiod | If 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 |