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
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.
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."
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."
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?"
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
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.
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.
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."
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.
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
| BlueGamma | A premium market-data terminal (per-security + terminal) | DIY bootstrapping | Free data sources | |
|---|---|---|---|---|
| As-of-date curve history | Yes — set any historical valuation date in the curve config | Yes — with per-data-point charges on each pull | Only if you archived the inputs yourself, every close | No — today's curve only; historical retrieval is manual and painful |
| Refresh cadence | Every 30 seconds | Real-time (trading-grade, priced accordingly) | Whenever you rebuild the sheet | Often prior-day or hours-delayed |
| Licence for commercial valuation use | Yes — valuation and derived-data use covered in the contract | Internal use only on the cheapest tier; client-facing valuation is "external purpose" and costs extra | You still need a licensed source for the input swap rates | Typically none for commercial use |
| Price anchor | Flat 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 format | Valuation-ready forward curve — web download, =BG Excel formulas, JSON API | Raw quotes; you assemble the curve (or pay for the calculated version) | Whatever your sheet produces | Screen-scrape or manual re-key |
| Export & download rights | Included — download, Excel add-in and API on every plan | View-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 bills | Yours by definition | Copy-paste, at your own licensing risk |
| Coverage for this job | 30+ currencies: SOFR, EURIBOR, SONIA, ESTR, BBSW, BKBM, SAIBOR, NIBOR, CORRA, JIBAR … + government bond curves, zero rates and discount factors | Everything — "you can get a lot of more data" than the job needs | Whatever you've built and maintained | Majors 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 sheetFAQs
In BlueGamma, open the SOFR forward curve, set the model valuation date in the curve configuration to your historical close (e.g. March 31), and download. The curve is rebuilt from the swap rates as of that date, so the same request always returns the same curve — which is what you need when a mark gets questioned weeks later.
Yes. BlueGamma covers EURIBOR (1M/3M/6M/12M), SONIA, SOFR, ESTR and 30+ currencies including less-covered indices like BBSW, SAIBOR, NIBOR, CIBOR, CORRA, JIBAR and TONA. You choose the payment frequency and valuation date so the curve's period structure matches the instrument you're valuing, then pull it via web download, the Excel add-in or the API.
Yes. Beyond forward curves, BlueGamma provides historical swap curves, zero-coupon rates and discount factors as of any historical business day — the "SONIA swaps as at some point last year, just a curve for one particular date" request that valuation firms make constantly. That covers methodologies that need the risk-free curve as of a loan's origination date, sometimes years back, as well as teams that would rather ingest a ready discount curve than bootstrap zeros themselves. Historical curves are end-of-day snapshots, and a past close doesn't change — worth knowing there's no single industry convention for the "official" close (3:00 PM New York vs 5:00 PM London both circulate), so what auditors actually look for is a consistent, documented source applied the same way every period.
Overnight SOFR. BlueGamma's curves are derived from compounded-overnight SOFR swaps — the instruments that carry the overwhelming majority of market volume. Term SOFR is separately licensed by its benchmark administrator, so BlueGamma does not provide it; if your credit docs specifically require term SOFR fixings, you'll need a source licensed by the administrator. For forward-looking projections the two are usually close, but check what your docs reference.
The underlying swap rates are sourced directly from a leading regulated interdealer broker — the same source the major terminals use — and the data refreshes every 30 seconds. Curves are bootstrapped from those swap rates using the same model across the web app, Excel add-in and API — so with the same configuration, all three return the same numbers.
It should tie out as long as you compare like for like — the same input convention (e.g. annual-compounded overnight SOFR swaps), the same valuation date and end-of-day snap. Differences almost always trace back to convention mismatches or term vs overnight SOFR, not the underlying market data. We encourage trialists to run this comparison against their existing provider before committing.
Yes — the JSON API exposes forward curves, single-period forward rates, swap curves, discount factors, government bond yields and FX forwards. For valuation schedules where the payment dates must match the deal docs exactly, use the forward rate endpoint with explicit start and end dates; the forward curve endpoint is better suited to charting a whole curve. An Excel add-in with =BG formulas covers the analysts updating models by hand.
A premium terminal's per-security data licensing carries a minimum of roughly $1,000/month regardless of usage, and in practice you need a terminal (~$2,200/month) alongside it — about $3,000/month before external-use fees for client-facing valuations. BlueGamma is a flat monthly subscription with valuation use covered and a 14-day free trial, which makes sense precisely when curves are 99% of what you need and the rest of the terminal would sit idle. One valuations founder who came to BlueGamma by asking an AI assistant for "the best interest rate data provider that doesn't require an institutional subscription" framed the category exactly right — specialist depth without terminal economics.
This is the most common shape of the job, not the exception: many BlueGamma valuation customers describe it as "just a quarterly exercise — the rest of the quarter we don't need anything; one of the team members would extract the data and that's it," or use it "maximum one or two days a month." There are no per-pull or per-data-point charges, so the subscription is the whole cost — compare it against a ~$3,000/month terminal floor, a per-deal advisory fee, or the analyst hours spent reconstructing curves from free sources each close.
Usually not safely. Most free sources don't licence commercial or derived-data use, don't publish as-of-date curve history, and can lag by hours or a day. For an audit-facing valuation you need a source you can name, a licence that covers the use, and the ability to reproduce the exact curve behind each mark — that's the gap a paid, specialist provider closes.
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.
Related situations
More scenario guides from the same desk.