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:
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:
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.:
SOFRSONIA3M EURIBORCORRA
For a full list of supported indices, see:
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?

