SNAPSHOTS
Snapshots of currency exchange rates from an indirect or direct perspective of a base currency.
Syntax
=OBB.CURRENCY.SNAPSHOTS([base],[quote_type],[counter_currencies])
Examples
=OBB.CURRENCY.SNAPSHOTS()
=OBB.CURRENCY.SNAPSHOTS("USD,XAU","indirect",EUR,JPY,GBP)
Parameters
Name | Type | Description | Required |
---|---|---|---|
base | Text | The base currency symbol. Multiple comma separated items allowed. | False |
quote_type | Text | Whether the quote is direct or indirect. Selecting 'direct' will return the exchange rate as the amount of domestic currency required to buy one unit of the foreign currency. Selecting 'indirect' (default) will return the exchange rate as the amount of foreign currency required to buy one unit of the domestic currency. | False |
counter_currencies | Any | An optional list of counter currency symbols to filter for. None returns all. | False |
Data
- fmp
Name | Description |
---|---|
base_currency | The base, or domestic, currency. |
counter_currency | The counter, or foreign, currency. |
last_rate | The exchange rate, relative to the base currency. Rates are expressed as the amount of foreign currency received from selling one unit of the base currency, or the quantity of foreign currency required to purchase one unit of the domestic currency. To inverse the perspective, set the 'quote_type' parameter as 'direct'. |
open | The open price. |
high | The high price. |
low | The low price. |
close | The close price. |
volume | The trading volume. |
prev_close | The previous close price. |
vwap | The volume-weighted average price. |
change | The change in price from the previous day. |
change_percent | The percentage change in price from the previous day. |
prev_open | The previous day's opening price. |
prev_high | The previous day's high price. |
prev_low | The previous day's low price. |
prev_volume | The previous day's volume. |
prev_vwap | The previous day's VWAP. |
bid | The current bid price. |
ask | The current ask price. |
minute_open | The open price from the most recent minute bar. |
minute_high | The high price from the most recent minute bar. |
minute_low | The low price from the most recent minute bar. |
minute_close | The close price from the most recent minute bar. |
minute_volume | The volume from the most recent minute bar. |
minute_vwap | The VWAP from the most recent minute bar. |
minute_transactions | The number of transactions in the most recent minute bar. |
quote_timestamp | The timestamp of the last quote. |
minute_timestamp | The timestamp for the start of the most recent minute bar. |
last_updated | The last time the data was updated. |