Skip to main content

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

NameTypeDescriptionRequired
baseTextThe base currency symbol. Multiple comma separated items allowed.False
quote_typeTextWhether 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_currenciesAnyAn optional list of counter currency symbols to filter for. None returns all.False

Data

NameDescription
base_currencyThe base, or domestic, currency.
counter_currencyThe counter, or foreign, currency.
last_rateThe 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'.
openThe open price.
highThe high price.
lowThe low price.
closeThe close price.
volumeThe trading volume.
prev_closeThe previous close price.
vwapThe volume-weighted average price.
changeThe change in price from the previous day.
change_percentThe percentage change in price from the previous day.
prev_openThe previous day's opening price.
prev_highThe previous day's high price.
prev_lowThe previous day's low price.
prev_volumeThe previous day's volume.
prev_vwapThe previous day's VWAP.
bidThe current bid price.
askThe current ask price.
minute_openThe open price from the most recent minute bar.
minute_highThe high price from the most recent minute bar.
minute_lowThe low price from the most recent minute bar.
minute_closeThe close price from the most recent minute bar.
minute_volumeThe volume from the most recent minute bar.
minute_vwapThe VWAP from the most recent minute bar.
minute_transactionsThe number of transactions in the most recent minute bar.
quote_timestampThe timestamp of the last quote.
minute_timestampThe timestamp for the start of the most recent minute bar.
last_updatedThe last time the data was updated.