Excel Add-in
Welcome to the BlueGamma Excel Add-In support guide.
Use the Excel Add-In to access live and historical interest rate data directly in Excel — including swap rates, forward curves, and discount factors — without needing to write code.
👇 Popular functions:
What you want to do
Function
Example Formula
Get a swap rate
SWAP_RATE
=BlueGamma.SWAP_RATE("SOFR", "2024-01-01", "2034-01-01", "6M")
Get a forward rate
FORWARD_RATE
=BlueGamma.FORWARD_RATE("SOFR", "2027-12-31", "2028-03-31")
Get a discount factor
DISCOUNT_FACTOR
=BlueGamma.DISCOUNT_FACTOR("SOFR", "2027-01-01")
Get swap rate by saved ID
SWAP_RATE_BY_ID
=BlueGamma.SWAP_RATE_BY_ID("swap_abc123")
For information on our functions hit next!
Last updated