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. |
| symbol | Symbol of the equity. |
| adj_close | The adjusted close price. |
| unadjusted_volume | Unadjusted volume of the symbol. |
| change | Change in the price from the previous close. |
| changeOverTime | Change in the price from the previous close, as a normalized percent. |