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. |
| change | The change in the price from the previous close. |
| change_percent | The change in the price from the previous close, as a normalized percent. |
| ma_50 | The 50-day moving average. |
| ma_200 | The 200-day moving average. |
| year_high | The 52-week high. |
| year_low | The 52-week low. |
| last_rate_timestamp | The timestamp of the last rate. |