Get FX Forward Rate

Get the forward FX rate for a currency pair on a future date in Excel with BlueGamma.FX_FORWARD, optionally as of a historical valuation date.

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

Formula

=BlueGamma.FX_FORWARD(currency_pair, [date], [valuation_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.
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

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