Get FX Rate

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

New to the Excel Add-In? Install the add-in to start using this formula.

Formula

=BlueGamma.FX(currency_pair, [valuation_date])

Parameters

currency_pair	string	Currency pair in ISO format (e.g. EURUSD, USDJPY)
valuation_date	string (optional)	Valuation date or datetime (UTC), e.g. 2026-07-17 or 2026-07-17T14:30:00. Date-only values price at end of day (23:59:59 UTC). Defaults to live.

Returns

Spot FX rate (e.g. 1.0845)

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