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)	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")