How do I get a forward curve as of the valuation date for quarter end?

Set the valuation date in the curve configuration and download the forward curve as of that close, into Excel, through the API or as a file. Past closes are stored, so a re-pull of the same date reproduces the curve, and when a mark is questioned in three weeks you can show exactly what it was struck on.

No card needed · 14-day free trial
app.bluegamma.io/interest-rate-curves/usd/sofr
BlueGamma SOFR forward curve to 2055 with a Download SOFR Curve button
  • Any closequarter end, month end or a loan’s origination date
  • 30+currencies, plus zero rates and discount factors
  • Storedpast closes are stored, so a re-pull of the same date reproduces the curve

Today, and with BlueGamma

How it usually gets done

  • A terminal licence paid for all year to pull a handful of curves each quarter.
  • A bootstrapping sheet built by a colleague who has since left.
  • Free pages that show today's curve, not the one as of your valuation date.

With BlueGamma

  • Any historical close, set once in the curve configuration.
  • One model behind the web app, Excel and the API, so the numbers agree.
  • A dated file for the deal folder that reproduces the mark later.

Not the right fit if you need intraday marks on a trading book. This is built for period-end valuation and the audit trail behind it.

How it works

  1. 01

    Lock the curve to the valuation date

    Set the model valuation date to your close, then the start date and payment frequency to match the deal documents. Monthly-pay books can tick “use end of month date” so every future period lands on the same day. Teams on a fixed reporting calendar lock those dates once and press F9 each quarter.

    Excel curve tab: 3M SOFR forwards locked to the 26 Oct 2026 valuation date with BlueGamma.FORWARD_RATE
  2. 02

    Pull every index the book needs

    SOFR for the US loans, EURIBOR for the euro bonds, SONIA for sterling, several tenors of one index at once if loans reset differently. Feeding a valuation system? The API takes the same valuation time and returns the same numbers as the app.

    Terminal: the BlueGamma swap_rate endpoint called with a past valuation time, returning the 5-year SOFR rate of 4.531 for the 26 Oct 2026 close
  3. 03

    Archive the dated curve

    Save the export to the deal file. End-of-day rates for a past date don’t change, so when the mark is questioned in April, or in next year’s audit, you reproduce the exact curve the valuation was struck on, from an independent source.

In their words

Auditor signed off on the first period end
“We received your data, everything was fine. I also spoke to the auditor… everything's fine from their side.”
Finance lead, European renewables operator
“We'll need it every quarter… often they ask us to value things at a quarter end, but then also our methodology depends on going back in time and getting the risk-free curve as of the origination date of the loans.”
Founder, valuations firm serving credit funds
“I can download it… I can archive it and then that's fine for me. So then I have it.”
Valuation specialist, European credit investor

Your options, compared

Free sources only show today's curve, and building your own costs analyst hours. BlueGamma gives you the curve as of any business day, ready to value with.

CriterionBlueGammaPremium terminalBuilding curves yourselfFree sources
Can you get the curve as of a past date?Yes, any business dayYes, within the terminal's licence termsOnly if you saved the inputsNo, today's curve only
Are you licensed to use it in client valuations?Yes, your plan covers it; ask us before publishing ratesDepends on the vendorYou still need licensed inputsDepends on each source's terms
How do you get the data out?Web, Excel and APIOften needs a separate licenceIt's already yoursCopy and paste
What do you get?A curve ready for valuationRaw quotes you assembleWhatever your spreadsheet producesNumbers to re-type
What does it cost?A flat monthly subscriptionAn annual terminal licenceAnalyst hours every quarterFree, but licence terms vary

Questions teams ask

Pull this quarter’s curves before the close

Set the valuation date, download the curve, and keep a record that reproduces every mark.

Pull quarter-end curves free
No card needed · 14-day free trial