Get FX Rate

Get the spot FX rate for a currency pair (e.g. EURUSD, GBPJPY).

Formula

=BlueGamma.FX(currency_pair, [valuation_date])

Parameters

currency_pair

string

Currency pair in ISO format (e.g. EURUSD, USDJPY)

valuation_date

string (optional)

Date to fetch the rate for (e.g. 2024-12-31). Defaults to today.

Returns

Spot FX rate (e.g. 1.0845)

=BlueGamma.FX("EURUSD")
=BlueGamma.FX("GBPUSD", "2024-12-31")

Last updated