> For the complete documentation index, see [llms.txt](https://www.bluegamma.io/documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.bluegamma.io/documentation/integrations/excel-add-in/how-to-guides/how-to-pull-fx-forward-rates-in-excel.md).

# 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:

{% content-ref url="/pages/cIh9SrulGOViAKc9OE27" %}
[Installation & Setup](https://www.bluegamma.io/documentation/integrations/excel-add-in/installation-and-setup.md)
{% endcontent-ref %}

***

### 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:

```
A1 = "EURUSD"
```

For every supported pair, see:

{% content-ref url="/pages/hXrblZYBmyrQf2Ap1GJo" %}
[Supported FX Currency Pairs](https://www.bluegamma.io/documentation/data-coverage/whats-available/supported-fx-currency-pairs.md)
{% endcontent-ref %}

***

### 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:

```
=BlueGamma.FX_FORWARD(currency_pair, [date])
```

**Example:**

```
=BlueGamma.FX_FORWARD($A$1, C1)
```

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

<figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2Fgit-blob-f47de234ceb86feacf642c35ff999b8eaeee9458%2Fexcel-fx-forecast-table.png?alt=media" alt=""><figcaption><p>Complete FX forecast table with USD equivalents (screenshot from an earlier run, with earlier dates)</p></figcaption></figure>

***

### Function Reference

For complete details on the FX forward function, see:

{% content-ref url="/pages/RC1cCYAnS7Rbn8j9pLC2" %}
[Get FX Forward Rate](https://www.bluegamma.io/documentation/integrations/excel-add-in/functions/get-fx-forward-rate.md)
{% endcontent-ref %}

For the current spot rate, use:

{% content-ref url="/pages/9PFMJbuSLh11kWDyjZUG" %}
[Get FX Rate](https://www.bluegamma.io/documentation/integrations/excel-add-in/functions/get-fx-rate.md)
{% endcontent-ref %}

***

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](https://auth.bluegamma.io/sign-up) and start using the Excel Add-in today.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://www.bluegamma.io/documentation/integrations/excel-add-in/how-to-guides/how-to-pull-fx-forward-rates-in-excel.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
