The Scenario
You're a fixed-income portfolio manager. Every morning your risk model reads Treasury yield data from an Excel workbook — eight maturities, two columns — before generating duration recommendations for the day. The data is supposed to arrive automatically. This morning, it didn't.
The overnight job that populated the workbook failed silently. You noticed when the model threw a divide-by-zero error at 7:55 AM. The portfolio committee call is at 9.
The bad version:
- Go to the Finage Treasury rates endpoint, retrieve the response, find the eight maturity values you need (1M, 3M, 6M, 1Y, 2Y, 5Y, 10Y, 30Y).
- Copy each maturity label and its rate, paste into columns A and B of the workbook, one row per maturity.
- Realize the rates came back as decimals (0.0527 for 5.27%) and your model expects whole percentages, so you multiply each value manually before the formulas will run correctly.
Your model was waiting on eight numbers. Getting those numbers into the right format should not be a 20-minute task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the workbook and calls Finage on your behalf. It fetches the current constant-maturity Treasury rates for the maturities you specify, formats them correctly, and writes them into the columns your model expects.
Pull today's Treasury CMT rates from Finage for all standard maturities and fill my Excel sheet with the maturity label and interest rate so I can chart the yield curve
What You Get
- Column A: maturity label (1M, 3M, 6M, 1Y, 2Y, 5Y, 10Y, 30Y)
- Column B: current rate expressed as a percentage (e.g., 5.27, not 0.0527)
- Eight rows, written in maturity order from shortest to longest, matching the layout your model expects
- A timestamp in a nearby cell showing when the rates were fetched
What If the Data Is Not Quite Ready
Your model also needs last week's rates for comparison alongside the current rates
Fetch the current US Treasury CMT rates for maturities 1M through 30Y from Finage and write maturity in column A and the current rate in column B, then fetch the rates from 7 days ago and write them in column C so the model can calculate the week-over-week shift
You want to add a third column calculating the week-over-week basis point change
Fetch current and prior-week Treasury CMT rates from Finage for maturities 1M, 3M, 6M, 1Y, 2Y, 5Y, 10Y, and 30Y, write current rate in column B and prior-week rate in column C, then add column D with the change in basis points (current minus prior, multiplied by 100)
You want to flag if the curve is inverted at any maturity point
Fetch current Treasury CMT rates from Finage, write maturity and rate into columns A and B, then in column C write "INVERTED" for any maturity where the rate is higher than the next longer maturity, and write "NORMAL" otherwise
You want to clear yesterday's rates, load today's, check for inversion, and add a summary note in one operation
Clear columns A through D on my Yield Curve worksheet, fetch current US Treasury CMT rates from Finage for maturities 1M through 30Y, write maturity in A and rate in B, flag inversions in column C, and in a summary cell write either "CURVE NORMAL" or "CURVE INVERTED AT: [list of inverted points]" based on what you find
One prompt handles the data pull, the inversion check, and the summary flag in a single operation.
Try It
Open an Excel workbook with your yield curve model. Get the 7-day free trial of SheetXAI and ask it to populate current Finage Treasury rates formatted for your duration model and inversion check. You can also ask it to pull sector performance data for your macro overlay, or return to the Finage hub for the full integration overview.