Use case · Quarter-end valuations

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

It's March 31. Every floating-rate position in the book needs cash flows projected off the forward curve as of today's close — SOFR for the US loans, EURIBOR for the euro bonds, each one locked to the valuation date. One legacy loan needs the risk-free curve as of its origination date, four years back. And when a client questions a mark in three weeks, you'll need to re-pull exactly that curve, not whatever the market says in April.

Last updated: July 2026 · 8 min read

The short answer

Set the valuation date in BlueGamma's curve configuration and download the SOFR, EURIBOR or SONIA forward curve as of that exact close — into Excel, via the add-in, or through the API. BlueGamma is an interest rate data and pricing platform used by 80+ financial institutions for swap rates, forward curves and cap pricing across 30+ currencies.

This page walks through the quarter-end workflow as valuation teams actually run it — the same process used by loan-valuation advisors, CLO equity valuers, fund-services platforms, Big Four valuation desks, private credit funds, listed infrastructure funds and renewables operators on BlueGamma today. The cadence varies — daily NAV strikes for open-ended funds, monthly model-driven valuations of illiquid loan books, quarterly marks for private credit and insurance reporting, semi-annual reviews for listed infrastructure — but the job is the same: a curve locked to a date. And for most teams it's narrow and repetitive: as a valuations lead at a US middle-market advisory firm put it, "At this stage I would say like 99% is really looking at historical and forward curves."

How teams describe this job

The same request, in the words of the people who run it — from ad-hoc historical pulls to a locked quarterly calendar:

"We might come to you and say we need SONIA swaps as at some point last year… Just a curve for one particular date."

Director at a UK valuation-software and analytics firm (portfolio valuations, ALM, stress testing)

"Many times users will go in and say OK, price this loan five years ago… what is, you know, on December 31st, 2020 — so we needed to pull the curves from that date."

CEO of a US commercial-real-estate debt valuation platform

"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 of a valuations firm serving credit funds (floating-rate loans priced as a spread over SONIA or EURIBOR)

"Basically we would need the quarterly figures as for the end of each quarter. So basically for 31st of March, 30th of June, 30th of September and 31st of December."

Finance lead at a listed German renewables operator

"Normally what we do is every quarter more or less we update those macro assumptions in the financial models, like interest rate curves and swap rates… once a quarter, and then also when a project reaches financial close."

Financial analyst at a Dutch solar developer

"I used to download the data from [the terminal], update a spreadsheet, then I send the spreadsheet to the other team so they can link with the data."

Treasury analyst at a Brazilian industrial group — the monthly intercompany-loan revaluation, before automating it

How you're probably getting curves today

Four routes dominate, and each one breaks somewhere between the valuation date and the audit file.

~$3,000/mo floor — before export rights

A premium-terminal setup you barely use

Per-security data licensing carries a minimum fee of roughly $1,000/month regardless of how much data you take — and to see what you're pulling, you realistically need a terminal at ~$2,200/month on top. A market-data consultant who negotiates these contracts for a living put the practical floor at about $3,000/month — before the "external purpose" surcharge that applies the moment the data feeds client valuations rather than internal use. Even then, export is where it bites: a derivatives-valuation lead at a global consulting firm found forward-curve downloads were "a whole nother 50,000 a year … You can see them. You can't copy them" — and one valuations founder admitted, "We've had to resort to using screenshots on our phones of the data because we can't download it."

Your own time, every single quarter

Bootstrapping your own curves

Perfectly doable if you know what you're doing — pull swap rates, build the curve, keep the sheet alive. But conventions drift, instruments roll, and every quarter the sheet needs care. Often the whole thing rests on one Excel built by "a colleague from investment banking, who already left." The maintenance is the real cost, and "I built it myself" is a harder sentence in front of a client or auditor than "we used an independent provider."

No as-of-date history, no commercial licence

Free data sources

Free pages give you today's curve — not the curve as of your valuation date. Reconstructing a historical rate from an official source can mean digging through a government website that was never built for it, and most free sources carry no licence for commercial valuation use. Trust is the other problem — one credit-fund adviser who cross-checked a free site against the terminal asked out loud: "Is it intentionally just a little bit off? … is it still backable by your side?"

Per-deal fees, someone else's timetable

Someone else pulls it for you

A Big Four firm delivers "the final interest curve" monthly; a broker fills in your rate sheet ("we'd send the sheet and it would say OK, please fill it out until today or 31st of December … But we no longer work with them, so I have to do it myself now"); a bank treasury desk answers when they're free ("it's basically just phoning friends, effectively, which isn't ideal"). Every one of these is a dependency with a lag, a fee, or a person who leaves.

The DIY route was summed up on a call by a CLO equity valuation specialist in Germany: "I could do it myself … on the bootstrapping and all that kind of stuff … but the maintenance is of course some work and therefore I see the benefit of … having a provider like you." And the timing pressure never moves: as a valuations team member at a Big Four firm in the Middle East put it, "we kind of mostly price for the end of the month, or a specific time period where you have a lot of audit work — so it's very time sensitive."

The quarter-end curve pull, step by step

1

Set the valuation date in the curve configuration

Open the forward curve page, click the configuration cog and set the model valuation date to your close — March 31, June 30, any historical business day, back years if your methodology needs the curve as of a loan's origination date. Set the curve start date and payment frequency (1M / 3M / 6M / 12M) to match the deal docs; monthly-pay books can simply click "use end of month date" so every future period falls on the same day of the month. Teams running a fixed reporting calendar lock the dates once — "I wanted to run it on the 30th of June and the 30th September, 31st December … I lock in actually specific dates to align with the model," as a treasury lead at a global energy group in Sydney described his BBSW setup.

2

Pick the benchmark

SOFR, EURIBOR, SONIA, ESTR — plus less-covered indices like BBSW, BKBM, SAIBOR, NIBOR, CIBOR, CORRA, JIBAR and TONA across 30+ currencies. Government bond yields (US Treasuries, OATs, gilts, plus long points like 15Y Australia or 20Y Germany for risk-free-rate reads) and their zero-coupon and forward curves live under the Government Bonds tab. Teams that run their own discounting pull historical swap curves, zero rates and discount factors directly instead.

3

Download the curve as of that exact close

One click gives you the forward curve as of the valuation date as a file you can drop straight into the model — built for valuation use, not just a strip of swap rates you still have to bootstrap. Need multiple tenors of the same index — say 1M, 3M and 6M SOFR because different loans reset differently? Pull them all down at once. As one private credit analyst put it: "being able to pull that all down at once is nice."

4

Or pull it programmatically

The Excel add-in gives you =BG formulas with a locked as-of date — a start date, end date, index and valuation date returns the exact forward rate for that period, so a quarterly model refresh is literally F9. ("Every quarter when we're doing valuation … you just open up, press F9 and we know," as a project finance lead at a MENA renewables fund described it.) For a valuation stack, the API's get_forward_curve, get_forward_rate, get_zero_rate and get_discount_factor endpoints return the same numbers as the app when the configuration matches; teams use the forward rate endpoint when payment dates must line up exactly with the deal schedule, and the discount-factor endpoint when they'd rather digest a ready curve than calculate zeros themselves.

5

Archive the download as audit evidence

Save the dated export to your deal file — end-of-day rates for a past date don't change, so teams building automated stacks store each close once and never re-query it. When the mark is questioned in April — or in next year's audit — you re-pull or produce the exact curve the valuation was struck on, from an independent third-party source.

Quarter-end curves: BlueGamma vs the alternatives

BlueGammaA premium market-data terminal (per-security + terminal)DIY bootstrappingFree data sources
As-of-date curve historyYes — set any historical valuation date in the curve configYes — with per-data-point charges on each pullOnly if you archived the inputs yourself, every closeNo — today's curve only; historical retrieval is manual and painful
Refresh cadenceEvery 30 secondsReal-time (trading-grade, priced accordingly)Whenever you rebuild the sheetOften prior-day or hours-delayed
Licence for commercial valuation useYes — valuation and derived-data use covered in the contractInternal use only on the cheapest tier; client-facing valuation is "external purpose" and costs extraYou still need a licensed source for the input swap ratesTypically none for commercial use
Price anchorFlat monthly subscription — no per-download fees~$1,000/mo per-security minimum + ~$2,200/mo terminal ≈ ~$3,000/mo floor"Free" — plus analyst hours each quarter and key-person risk£0
Output formatValuation-ready forward curve — web download, =BG Excel formulas, JSON APIRaw quotes; you assemble the curve (or pay for the calculated version)Whatever your sheet producesScreen-scrape or manual re-key
Export & download rightsIncluded — download, Excel add-in and API on every planView-only in practice on many contracts — forward-curve export quoted as a separate licence ("you can see them, you can't copy them"); teams hit download caps and surprise usage billsYours by definitionCopy-paste, at your own licensing risk
Coverage for this job30+ currencies: SOFR, EURIBOR, SONIA, ESTR, BBSW, BKBM, SAIBOR, NIBOR, CORRA, JIBAR … + government bond curves, zero rates and discount factorsEverything — "you can get a lot of more data" than the job needsWhatever you've built and maintainedMajors only, conventions unstated

Premium-terminal figures as described on a recorded call by a market-data contracts consultant (15 years in the industry): "a minimum fee of $1000 per month, regardless of how much data you take … You probably need [the terminal] as well. So that is another $2200 per month … then you are at a $3000 roundabout per month." Verify current list pricing with the vendor. The variable charges are their own complaint — a private credit manager described being "nickel and dimed in fees that we can't really trace back … we have a bad month and, like, what's going on here?", and a corporate treasury analyst simply noted "every month there are small fees that I don't know how they calculate."

Teams already running quarter end on BlueGamma

A fund-services and valuation platform serving credit funds moved its quarterly client valuation runs onto the BlueGamma API: the team pulls SOFR, BBSW, BKBM and Treasury curves on each client's valuation date, converts the JSON to files on SharePoint, and rolls the rates forward to the valuation analysts. They transitioned their live valuations to BlueGamma curves within weeks of onboarding. Elsewhere, the private credit arm of a large US investment fund runs its quarterly floating-rate revaluations off BlueGamma SOFR forwards, and a listed German renewables operator took its period-end curves through an external audit on the first cycle.

"The API stuff has been doing really well for the team."

Delivery lead at a fund-services & valuation platform (quarterly client valuation runs)

"We already know the payment dates and valuation date … once the valuation date is over, we pull those rates on the specific days and then it's a roll forward to the team to support their valuation analysis."

Delivery lead at a fund-services & valuation platform

"The practice line leader is pulling curves … we know there's some alarm bells going off."

Valuations lead at a US middle-market advisory firm — on why curve pulls should be a two-minute analyst task, not an MD's problem

"We wanted to … find the French treasury rate for early January this year. And actually it was pretty painful to find it in the French treasury website, as opposed to … going into the history in BlueGamma."

Infrastructure investment director at a French fund manager (monthly regulatory valuations)

"There's much more value in the data than in the service that comes with it."

Infrastructure investment director at a French fund manager — on internalising the curve workflow instead of paying an advisor per deal

"I can download it … I can archive it and then that's fine for me. So then I have it."

CLO equity valuation specialist, Germany — on archiving the dated curve download as evidence for quarterly valuations

"Many of those private credit investments are floating rate and we've been using the forward SOFR curves from [BlueGamma], which we felt is a simple solution to incorporate those into our valuation models."

Valuations lead for the private credit arm of a large US investment fund (quarterly revaluations)

"We received your data, everything was fine. I also spoke to the auditor … everything's fine from their side."

Finance lead at a listed German renewables operator — after the first period-end run on BlueGamma curves

"For the zero rate … you have the discount factor, so I don't have to calculate. I literally just digest the curve, put it in my little [model] and then I have a number."

Derivatives valuation desk lead at a global consulting firm — values USD, GBP and JPY swap books for large solar and wind owners under US GAAP

"A lot of our stuff is quarterly or monthly pay at the end of the month and we can just click, like, use end of month date … so that future periods will fall on the same day of the month."

Private credit analyst at a large US investment fund — on payment-date-aligned curve pulls

"If everything was on the platform it would be easier, especially if I can easily extract them using the add-in … You set it once and then it automates the process basically."

Finance team at a listed infrastructure fund — semi-annual valuations off government bond risk-free rates (15Y Australia, 20Y Germany, 20Y Netherlands) after their broker stopped filling in the rate sheet
30+
currencies — SOFR, EURIBOR, SONIA, ESTR, BBSW, SAIBOR, NIBOR, CORRA & more, plus government bond curves
30 sec
data refresh cadence
Direct
from a leading regulated interdealer broker — the same OTC market data the major terminals build from
Flat
monthly subscription — no per-pull or per-data-point charges
14 days
free trial, no card required

FAQs

Run your next quarter end on curves you can defend

Pull a curve as of your last close during the trial and compare it to your current source — that comparison is the whole evaluation.

Try Free for 14 Days
No card required · Full portal access · Flat monthly subscription