> 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-a-forward-curve-directly-into-excel.md).
# How to Pull a Forward Curve Directly into Excel
Pull forward curves directly into Excel using BlueGamma's Excel Add-in. Set up dates, choose your index and select a valuation date.
BlueGamma's Excel Add-in lets you fetch forward curves directly into your model using simple functions. This guide walks you through how to do that: setting up dates, choosing your index and selecting a valuation date.
### 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](/documentation/integrations/excel-add-in/installation-and-setup.md)
{% endcontent-ref %}
***
### 1. Add Start Dates and End Dates
Forward rates are defined over a **Start Date → End Date** period. This period reflects the start of the interest period and the end of the interest period (usually the interest payment date).
In your model, set up the schedule of periods you want to forecast.
For example:
| | C | D | E | F | G |
| -------------- | ---------- | ---------- | ---------- | ---------- | ---------- |
| **Start Date** | 2027-01-01 | 2027-04-01 | 2027-07-01 | 2027-10-01 | 2028-01-01 |
| **End Date** | 2027-04-01 | 2027-07-01 | 2027-10-01 | 2028-01-01 | 2028-04-01 |
These dates typically come from:
* your **debt schedule**,
* **loan interest periods**, or
* **swap cashflow dates**.
For a forecast, use periods that start after the valuation date. If a period has already started, `FORWARD_RATE` uses the published fixings for the part that has already fixed.
***
### 2. Choose the Index
Use the index linked to your instrument, e.g.:
* `SOFR`
* `SONIA`
* `3M EURIBOR`
* `CORRA`
For a full list of supported indices, see:
{% content-ref url="/pages/V5BVY98UcwQpCdpKqzbj" %}
[Available Indices](/documentation/data-coverage/data-coverage/available-indices.md)
{% endcontent-ref %}
Place it in a fixed cell for easy referencing:
```
A1 = "SOFR"
```
***
### 3. Choose the Valuation Date
You can:
* Use the latest curve (leave the valuation date blank)
* Or anchor the data to a specific date, e.g.:
```
A2 = 30/11/2025
```
***
### 4. Pull the Forward Curve
Use the BlueGamma function:
```
=BlueGamma.FORWARD_RATE(index, start_date, end_date, [valuation_date])
```
**Example:**
```
=BlueGamma.FORWARD_RATE($A$1, C1, C2)
```
Or if you would like to pick a particular valuation date:
```
=BlueGamma.FORWARD_RATE($A$1, C1, C2, $A$2)
```
Fill across your spreadsheet to generate the forward curve.
***
### 5. Example Output
This produces a full forward curve that aligns with your model's interest periods. The screenshot uses an earlier schedule, with a valuation date of 30/11/2025 in A2.
***
You now have a forward curve directly in Excel, ready to feed into your interest and debt modelling.
**Ready to pull live forward curves directly 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-a-forward-curve-directly-into-excel.md?ask=&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.
