Get FX Forward Rate

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

Formula

=BlueGamma.FX_FORWARD(currency_pair, [date])

Parameters

currency_pair	string	Currency pair in ISO format (e.g. EURUSD, USDJPY)
date	string (optional)	Future date to fetch the forward rate for. Defaults to today.

Returns

Forward FX rate (e.g. 1.0923)

Example

=BlueGamma.FX_FORWARD("EURUSD", "2026-06-01")

This returns the forward exchange rate for EURUSD on June 1, 2026 (e.g., 1.1605).