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:
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 DollarGBPUSD- British Pound to US DollarUSDJPY- US Dollar to Japanese YenAUDUSD- Australian Dollar to US DollarUSDCAD- US Dollar to Canadian Dollar
Place the currency pair in a fixed cell for easy referencing:
For every supported pair, see:
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:
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:
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:
The forward FX rate for each payment date
The projected USD value of each EUR payment
A clear view of your foreign currency exposure over time

Function Reference
For complete details on the FX forward function, see:
For the current spot rate, use:
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?

