How to Pull a Forward Curve Directly into Excel

🧩 Step 1: Install the BlueGamma Excel Add-In

  • Visit the Microsoft AppSource Store

  • Click Get It Now and follow the prompts to install the add-in in Excel

πŸ” Step 2: Activate Your BlueGamma Account

  • Email us at [email protected] to activate your trial

  • Once activated:

    • Open Excel

    • Navigate to the BlueGamma tab in the toolbar

πŸ”‘ Step 3: Log In

  • Click Sign In under the BlueGamma tab and enter your account credentials

  • If you don’t have an account, contact us for setup

πŸ“‰ Step 4: Use the =BlueGamma.FORWARD_RATE Function

  • Use this function to pull forward rate data directly into a spreadsheet cell:

Formula Format

=BlueGamma.FORWARD_RATE(index, start_date, end_date)

Example:

=BlueGamma.FORWARD_RATE("SOFR", "2025-09-30", "2025-12-31")

πŸ§ͺ Example Usage in Financial Models

Want to create a dynamic forward curve table? Use Excel's autofill feature to extend the formula across rows for different dates.

Example Table:

=BlueGamma.FORWARD_RATE("SOFR", B1, C1)

You can list a series of start and end dates across columns B and C, then drag the formula in column D to apply it across the range.

🀝 Need Help?

We’re here to support you!

πŸ“₯ Download the BlueGamma Excel Add-In today and simplify your financial modeling workflows!

πŸ§ͺ Example: Build a Dynamic Forward Curve Table

Last updated