The Scenario
You're a fixed-income analyst and your morning routine includes plotting the current US Treasury yield curve. Your model reads maturity-rate pairs from a Google Sheet, builds the chart, and flags if the curve is inverted. The sheet needs to be populated before 8 AM when your desk starts making duration decisions.
Your analyst intern set this up three weeks ago. He built a script that pulled the data manually. He graduated last Friday. The script is gone, and you have the Treasury rates tab open and empty on a Monday morning.
The bad version:
- Go to the Finage Treasury rates endpoint, retrieve the response, identify the eight standard maturities 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 sheet, one row per maturity.
- Realize the rates came back as percentages in decimal form (0.0527 for 5.27%) and your chart axis is calibrated to display whole percentages, so you multiply each value by 100 manually before the chart renders correctly.
Your model needs the data in a specific format. The intern knew that. You do now.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the sheet 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.
Fetch the current US Treasury bond rates for maturities 1M, 3M, 6M, 1Y, 2Y, 5Y, 10Y, and 30Y from Finage and write maturity and rate into columns A and B of my Google Sheet
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 chart model expects
- A timestamp in cell D1 showing when the rates were fetched
What If the Data Is Not Quite Ready
Your model also needs the previous 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 point — specifically if any shorter maturity has a higher rate than a longer one
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 sheet, 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 cell D1 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 a Google Sheet 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 chart and inversion logic. 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.