Spiral gives your agent every tool with one account. Browse the tools →

Codex · Finance

How to Use U.S. Treasury average interest rates in Codex

Returns monthly average interest rates for marketable and nonmarketable Treasury securities. Use it to compare borrowing rates by security type over time; interest expense measures the dollar cost.

Prompts to try with U.S. Treasury average interest rates in Codex

Copy an example into Codex, or ask in your own words.

Use U.S. Treasury average interest rates to fetch Treasury bill and note rates for 2020 through 2024, then add a comparison chart to this project's reporting page.

U.S. Treasury average interest ratesCodex
Try asking
  • Use U.S. Treasury average interest rates to fetch total marketable debt rates for 2023 and 2024, then add a percentage-point comparison to the project's report.

  • Use U.S. Treasury average interest rates to look this up and give me the result as a table. Save the result in ./assets.

  • Pull the latest numbers from U.S. Treasury average interest rates and tell me what changed since last week.

  • Check U.S. Treasury average interest rates and summarize what you find in three bullet points.

How to set up U.S. Treasury average interest rates in Codex

Pick the way that suits you. Each takes about two minutes.

Use Spiral's MCP server

  1. Add the hosted server
    codex mcp add spiral --url https://api.spiral.ai/mcp
  2. Sign in

    Codex opens the browser: sign in to Spiral and click Authorize. No API key. codex mcp list then shows Spiral.

    codex mcp login spiral

Use the Spiral skill

  1. Send Codex this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run U.S. Treasury average interest rates

    One request; the result comes back by polling or a webhook.

    curl https://api.spiral.ai/v1/runs \
      -H "Authorization: Bearer $SPIRAL_API_KEY" \
      -H "Content-Type: application/json" \
      -H "Idempotency-Key: $(uuidgen)" \
      -d '{
        "provider": "alexandria",
        "model": "treasury-fiscal-data/debt/average-interest-rates",
        "input": {
          "sort": "<sort>"
        }
      }'

Then paste one of the prompts above: Codex finds U.S. Treasury average interest rates on Spiral, shows the price and runs it.

U.S. Treasury average interest rates providers and prices

Spiral runs U.S. Treasury average interest rates through Alexandria. Open a card for today's price, with every fee included.

AlexandriaFinance
Treasury Fiscal Data · Average interest rates
treasury-fiscal-data/debt/average-interest-rates

Settings you can ask for

Ask Codex for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Page[size]a number up to 10000100

Rows per page, 1 to 10,000. The default of 100 is fine for a summary series and far too small for a full auction history.

Page[number]a number1

Page number, 1-indexed. meta.total-pages in the response says how many there are.

Every API field of Treasury Fiscal Data · Average interest rates is on its tool page: open its card above.

What can you do with U.S. Treasury average interest rates in Codex?

Build a federal debt chart or reporting table from Treasury observations in your project. Keep debt balances, interest percentages, and interest expense in separate series with their reporting periods attached.

Fiscal year briefing

Explain a completed fiscal year with annual debt, the daily debt split near year-end, monthly average rates, and reported interest expense.

Compare 2020 with 2024

Compare debt levels, public and intragovernmental holdings, average rates, and interest expense across the two years. Present the measures separately before discussing their relationship.

Check a national debt article

Check claims about debt growth, borrowing rates, and interest costs against Treasury observations. Match each claim to a daily, monthly, or annual reporting period.

Teach debt and borrowing costs

Build a lesson using actual Treasury figures to distinguish outstanding debt, average interest rates, and interest expense. Include the difference between total debt and debt held by the public.

Monthly borrowing cost review

Compare changes in reported average rates with changes in monthly interest expense. Keep percentages and dollar amounts on separate charts.

Questions about U.S. Treasury average interest rates in Codex

Can Codex use U.S. Treasury average interest rates?

Yes. Add Spiral to Codex as an MCP server, and Codex can find and run U.S. Treasury average interest rates like any built-in tool.

How much does U.S. Treasury average interest rates cost in Codex?

$0.001746 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Codex plan is separate.

Do I need an Alexandria account to use U.S. Treasury average interest rates in Codex?

No. Spiral runs U.S. Treasury average interest rates on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up U.S. Treasury average interest rates in Codex?

About two minutes: add the hosted server, then sign in.

Does Codex wait while U.S. Treasury average interest rates runs?

U.S. Treasury average interest rates runs in the background. Codex starts the run, checks on it and gives you the json when it's ready.

Where does Treasury's debt data come from?

Fiscal Data draws from government operational systems, including debt management and summary debt accounting systems. Its coverage is public government finances; it does not provide personal financial records.

What reporting intervals do these Treasury datasets cover?

Debt to the Penny provides daily observations, historical debt outstanding summarizes fiscal years, and average interest rates provides monthly figures. Interest expense supplies both monthly and fiscal year-to-date amounts.

How far back can I compare federal debt?

Historical debt outstanding covers fiscal years from 1789 onward. It supplies total debt without the public-versus-intragovernmental breakdown available in Debt to the Penny.

Do Treasury's combined average rates include every security type?

The combined rates for total marketable, total nonmarketable, and total interest-bearing debt exclude TIPS and Floating Rate Notes. Keep that coverage boundary visible when discussing the government's average borrowing rate.

Does reported interest expense mean cash paid during the month?

Treasury describes its interest information for outstanding interest-bearing securities as calculated using modified accrual accounting. Avoid labeling every reported expense amount as a cash payment.

Get started

Start using U.S. Treasury average interest rates in Codex

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Codex:

Set up Codex

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options