How do I automate the rates market update I send clients every week?
Build the update once as a dashboard that refreshes itself. Set up your curves, rate tables and bond comps as widgets, export a PDF when the update is due, and let Claude draft the commentary from the same data.

- 30 to 60 minof copy-paste per edition, as advisory teams describe it
- 1 exportto a PDF of the whole dashboard
- 30 seclive rate refresh; widgets update on open
Today, and with BlueGamma
How it usually gets done
- One tab for Treasuries, one for swaps, one for the forward curve, then paste and fix the axes.
- No memory of last month’s curve, so teams keep their own archive of downloads.
- The same slide rebuilt by hand, edition after edition.
With BlueGamma
- A saved dashboard that pulls current data every time it opens.
- Today’s curve against one, three or twelve months ago, as one chart.
- A PDF in one export, and a first draft of the commentary from Claude.
Not the right fit if the update is a one-off. A dashboard pays back when the same slide goes out every week.
How it works
- 01
Build the dashboard once
Create a dashboard and add the widgets your update reports on: forward curves, a historical swap rate table with the changes, government bond yields and a saved bond comps list. Gulf or Australian client? Add the EIBOR or BBSY curve.
- 02
Add the "what changed" view
The chart clients read is the curve now against the curve a month or three ago. Overlay any as-of date on the chart, or show a rate’s range over the quarter, instead of rebuilding it from archived downloads.
app.bluegamma.io/usd/sofr
- 03
Export, and let Claude draft the words
Export the dashboard as a PDF, or feed your own template with Excel formulas. Then connect the MCP connector and schedule Claude to draft the commentary from the same data. It writes the skeleton; you add the view.

In their words
“That market commentary wording was spot on. That's exactly what I pretty much said [to a client] the other day.”
“You could just set up a task to write me a report with some commentary on the daily movements in swaps. It'd just be that they're in my inbox on a daily basis. I don't have to log in, I don't have to download anything.”
“We have to rely on the last time we downloaded a forward curve, looking at forward curves now versus what the forward curve was a month ago, or two months ago, or three months ago.”
Among the 100+ financial institutions on BlueGamma
Your options, compared
Free websites cost you an hour of copy-paste per edition, and a terminal means rebuilding the deck each time. BlueGamma turns the update into open, export, send.
| Criterion | BlueGamma dashboard | Copying from free websites | Premium terminal |
|---|---|---|---|
| How long does each edition take? | Minutes: open, export, send | 30 to 60 minutes of copy-paste | Re-run the extracts and rebuild the deck |
| How up to date are the rates? | Live, refreshed every 30 seconds | Often from the day before, or hours old | Live |
| Can you show today's curve against an earlier one? | Yes, overlaid on one chart | Only if you saved the old downloads | Yes, but you rebuild the chart by hand each time |
| Can you download the data in bulk? | Yes: dashboard, PDF and Excel | No | Depends on the vendor |
| Can you use it in client materials? | Yes, your plan covers it | Depends on each site's licence | Only within the terminal's licence terms |
Questions teams ask
Yes. Build the update once as a BlueGamma custom dashboard of forward curves, historical swap rates, live rates and a bond comps list, and it refreshes itself every time you open it. When the update is due, export the dashboard as a PDF or download the data into your own deck template.
Yes. From the dashboard menu, choose Export, then Download as PDF, and every widget is captured as of that moment. Many advisory teams instead download the time series into their own branded template; both routes are supported.
Yes. The BlueGamma MCP connector lets Claude pull live data and draft commentary on the week’s moves, on a schedule, or build a slide straight into your deck. Because the numbers come from BlueGamma rather than the model’s memory, the draft is grounded. The connector reads market data, and the only swaps it can see or change are the ones in your own BlueGamma account.
Forward curves and curve comparisons, historical swap rate tables, live swap rates, government bond yields, a bond comps list you define, FX spot and forwards, inflation and cross-currency spreads. Coverage runs across 30+ currencies, including SOFR, SONIA, EURIBOR, SARON, EIBOR and BBSY.
Yes, as a native chart. Overlay the current curve against the curve as of any prior date in one view. Historical actuals and forwards come from the same data, so the two series meet where they should, with no manual join.
Yes. The Excel add-in pulls live and historical rates into your workbook with =BlueGamma. formulas, so charts keep your fonts and branding and refresh on open. One agricultural-finance consultancy started with dashboard screenshots in its monthly newsletter and moved to branded Excel charts this way.
Use in client deliverables, such as charts and rate tables in client updates, newsletters and pitch decks, is covered by your plan; ask us before publishing rates publicly. Systematic redistribution of raw data, for example inside a software product, is a separate tier that we define in the contract up front.
Related guides
Send next week's update without rebuilding it
Set up your dashboard on the trial in your first session, or book a demo and we will build it with you on the call.