# Excel Add-in

Use the Excel Add-In to access live and historical interest rate data directly in Excel — including **swap rates**, **forward curves**, **discount factors**, **FX rates**, and **government bond yields** — without needing to write code.

***

## Getting Started

New to the BlueGamma Excel Add-in? Start here:

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

***

## 🔧 Core Interest Rate Functions

| Function                                                                                        | Description                                                 | Example                                                          |
| ----------------------------------------------------------------------------------------------- | ----------------------------------------------------------- | ---------------------------------------------------------------- |
| [`SWAP_RATE`](/documentation/integrations/excel-add-in/functions/get-swap-rates.md)             | Get the fixed rate for a vanilla interest rate swap         | `=BlueGamma.SWAP_RATE("SOFR", "2024-01-01", "2034-01-01", "6M")` |
| [`FORWARD_RATE`](/documentation/integrations/excel-add-in/functions/get-forward-rates.md)       | Return the forward rate between two dates for a given index | `=BlueGamma.FORWARD_RATE("SONIA", "2026-06-30", "2026-09-30")`   |
| [`DISCOUNT_FACTOR`](/documentation/integrations/excel-add-in/functions/get-discount-factors.md) | Get the discount factor for a given date and rate index     | `=BlueGamma.DISCOUNT_FACTOR("EURIBOR", "2027-01-01")`            |
| [`SWAP_RATE_BY_ID`](/documentation/integrations/excel-add-in/functions/get-swap-rate-by-id.md)  | Fetch the rate for a swap saved in the BlueGamma app        | `=BlueGamma.SWAP_RATE_BY_ID("swap_abc123")`                      |
| [`FIXING`](/documentation/integrations/excel-add-in/functions/get-fixing.md)                    | Get the published daily fixing for a given index and date   | `=BlueGamma.FIXING("SOFR", "2025-06-01")`                        |
| [`ZERO_RATE`](/documentation/integrations/excel-add-in/functions/get-zero-coupon-rates.md)      | Fetches zero-coupon rates for a specified index and date    | `=BlueGamma.ZERO_RATE("SOFR", "2026-06-30", "2025-01-01")`       |

## 🌍 FX & Macro Functions

| Function                                                                                       | Description                                                             | Example                                         |
| ---------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------- | ----------------------------------------------- |
| [`FX`](/documentation/integrations/excel-add-in/functions/get-fx-rate.md)                      | Get the spot FX rate for a currency pair                                | `=BlueGamma.FX("EURUSD")`                       |
| [`FX_FORWARD`](/documentation/integrations/excel-add-in/functions/get-fx-forward-rate.md)      | Get the forward FX rate for a currency pair on a future date            | `=BlueGamma.FX_FORWARD("GBPUSD", "2026-01-01")` |
| [`GOV_YIELD`](/documentation/integrations/excel-add-in/functions/get-government-bond-yield.md) | Return the zero-coupon government bond yield for a country and maturity | `=BlueGamma.GOV_YIELD("US", "10Y")`             |

👉 See the full [Function Reference](/documentation/integrations/excel-add-in/functions.md) for all available formulas and parameters.

***

## 📘 How-To Guides

Step-by-step tutorials for common tasks:

* [How to Pull a Forward Curve Directly into Excel](/documentation/integrations/excel-add-in/how-to-guides/how-to-pull-a-forward-curve-directly-into-excel.md)
* [How to Price a Swap in Excel Using BlueGamma's Add-in](/documentation/integrations/excel-add-in/how-to-guides/how-to-price-a-swap-in-excel-using-bluegammas-add-in.md)
* [How to Calculate Swap MtM in Excel](/documentation/integrations/excel-add-in/how-to-guides/how-to-calculate-swap-mtm-in-excel.md)
* [How to Pull Bond Yields in Excel](/documentation/integrations/excel-add-in/how-to-guides/how-to-pull-bond-yields-in-excel.md)
* [How to Calculate Discount Factors Using Government Bond Yields](/documentation/integrations/excel-add-in/how-to-guides/how-to-calculate-discount-factors-in-excel.md)

{% content-ref url="/pages/cAIEwz4KmqcFFA4f78Hc" %}
[How-To Guides](/documentation/integrations/excel-add-in/how-to-guides.md)
{% endcontent-ref %}

***

## Need Help?

| Resource               | Link                                                                                       |
| ---------------------- | ------------------------------------------------------------------------------------------ |
| **Troubleshooting**    | [Common issues and solutions](/documentation/integrations/excel-add-in/troubleshooting.md) |
| **Function Reference** | [All available formulas](/documentation/integrations/excel-add-in/functions.md)            |
| **Email Support**      | <support@bluegamma.io>                                                                     |
| **In-App Chat**        | Available at [app.bluegamma.io](https://app.bluegamma.io)                                  |


---

# Agent Instructions: Querying This Documentation

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

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://bluegamma.io/documentation/integrations/excel-add-in.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.