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