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

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:

Installation & Setup

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:

Available Indices

Place it in a fixed cell for easy referencing:


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


4. Pull the Forward Curve

Use the BlueGamma function:

Example:

Or if you would like to pick a particular valuation date:

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 and start using the Excel Add-in today.

Last updated

Was this helpful?