HISTORICAL
Currency Historical Price. Currency historical data. Currency historical prices refer to the past exchange rates of one currency against another over a specific period. This data provides insight into the fluctuations and trends in the foreign exchange market, helping analysts, traders, and economists understand currency performance, evaluate economic health, and make predictions about future movements.
Syntax
=OBB.CURRENCY.PRICE.HISTORICAL(symbol,[start_date],[end_date],[interval])
Examples
=OBB.CURRENCY.PRICE.HISTORICAL("EURUSD")
=OBB.CURRENCY.PRICE.HISTORICAL("EURUSD","2023-01-01","2023-12-31")
=OBB.CURRENCY.PRICE.HISTORICAL("EURUSD",,,"15m")
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| symbol | Text | Symbol to get data for. Can use CURR1-CURR2 or CURR1CURR2 format. Multiple comma separated items allowed. | True |
| 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 |
| interval | Text | Time interval of the data to return. Options: 1m, 5m, 15m, 30m, 1h, 4h, 1d. | 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. |
| adj_close | The adjusted close price. |
| change | Change in the price from the previous close. |
| changeOverTime | Change in the price from the previous close, as a normalized percent. |