For the complete documentation index, see llms.txt. This page is also available as Markdown.

How to Pull FX Forward Rates in Excel

Pull FX forward rates directly into Excel using BlueGamma's Excel Add-in. Forecast future exchange rates for hedging, cash flow forecasting, and financial modeling.

BlueGamma's Excel Add-in lets you fetch FX forward rates directly into your financial model using a simple function. This guide walks you through building an FX forward curve in Excel for forecasting foreign currency exposure.

Before You Start

To follow this guide, make sure you have:

  • Installed the BlueGamma Excel Add-in

  • Signed in to the add-in (the BlueGamma button on the Home tab in Excel)

  • An active BlueGamma trial or subscription

If you haven't set this up yet, see:

Installation & Setup

1. Choose the Currency Pair

FX forward rates require a currency pair in the format BASEQUOTE (e.g., EURUSD).

Common currency pairs include:

  • EURUSD - Euro to US Dollar

  • GBPUSD - British Pound to US Dollar

  • USDJPY - US Dollar to Japanese Yen

  • AUDUSD - Australian Dollar to US Dollar

  • USDCAD - US Dollar to Canadian Dollar

Place the currency pair in a fixed cell for easy referencing:

For every supported pair, see:

Supported FX Currency Pairs

2. Set Up Future Dates

Create a schedule of future dates for which you need FX forward rates. A date that has already passed returns the spot rate, so use dates after today. These typically align with:

  • Foreign currency debt service dates

  • Revenue or payment schedules

  • Capital expenditure timelines

  • Hedge settlement dates

For example, if you have quarterly foreign currency payments:

C
D
E
F
G

Date

2027-03-31

2027-06-30

2027-09-30

2027-12-31

2028-03-31


3. Pull FX Forward Rates

Use the BlueGamma function:

Example:

This returns the forward exchange rate for the currency pair in A1 on the date in C1.

Fill the formula across your date schedule to generate a complete forward curve.


4. Build a Complete FX Forecast Table

Here's a practical example showing how to forecast the USD equivalent of EUR-denominated debt payments:

Row
A
B
C
D
E

1 (Currency Pair)

EURUSD

2 (Payment Date)

2027-03-31

2027-06-30

2027-09-30

2027-12-31

2028-03-31

3 (EUR Payment)

1,000,000

1,000,000

1,000,000

1,000,000

1,000,000

4 (FX Forward Rate)

=BlueGamma.FX_FORWARD($A$1,A2)

=BlueGamma.FX_FORWARD($A$1,B2)

=BlueGamma.FX_FORWARD($A$1,C2)

=BlueGamma.FX_FORWARD($A$1,D2)

=BlueGamma.FX_FORWARD($A$1,E2)

5 (USD Equivalent)

=A3*A4

=B3*B4

=C3*C4

=D3*D4

=E3*E4

This setup gives you:

  1. The forward FX rate for each payment date

  2. The projected USD value of each EUR payment

  3. A clear view of your foreign currency exposure over time

Complete FX forecast table with USD equivalents (screenshot from an earlier run, with earlier dates)

Function Reference

For complete details on the FX forward function, see:

Get FX Forward Rate

For the current spot rate, use:

Get FX Rate

You now have live FX forward rates directly in Excel, ready to feed into your financial models, hedging analysis, and cash flow forecasts.

Ready to pull live FX forward rates into your model?

Create a free BlueGamma trial and start using the Excel Add-in today.

Last updated

Was this helpful?