Skill Tracer
Skills › Scientific Agent Skills › usfiscaldata › datasets-interest-rates.md

datasets-interest-rates.md

190 lines · skills/usfiscaldata/references/datasets-interest-rates.md at 5f2bc03

Open on GitHub
1# Interest Rates & Exchange Rate Datasets — U.S. Treasury Fiscal Data
2

Interest Rates & Exchange Rate Datasets — U.S. Treasury Fiscal Data

Raw lines 1 to 2
3## Average Interest Rates on U.S. Treasury Securities
4
5**Endpoint:** `/v2/accounting/od/avg_interest_rates`
6**Frequency:** Monthly
7**Date Range:** January 2001 to present
8
9Average interest rates for marketable and non-marketable Treasury securities, broken down by security type.
11**Key fields:**
12| Field | Type | Description |
13|-------|------|-------------|
14| `record_date` | DATE | Month end date |
15| `security_desc` | STRING | Security description (e.g., "Treasury Bills") |
16| `security_type_desc` | STRING | "Marketable" or "Non-marketable" |
17| `avg_interest_rate_amt` | PERCENTAGE | Average interest rate (%) |
19```python
20# Get average rates for all marketable securities, most recent month
21resp = requests.get(
22 "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/avg_interest_rates",
23 params={
24 "filter": "security_type_desc:eq:Marketable",
25 "sort": "-record_date",
26 "page[size]": 50
27 },
28 timeout=30,
30resp.raise_for_status()
31df = pd.DataFrame(resp.json()["data"])
32latest = df[df["record_date"] == df["record_date"].max()]
33print(latest[["security_desc", "avg_interest_rate_amt"]])
35# First-page preview of historical rates for a specific security type
36resp = requests.get(
37 "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/avg_interest_rates",
38 params={
39 "fields": "record_date,avg_interest_rate_amt",
40 "filter": "security_desc:eq:Treasury Notes,record_date:gte:2010-01-01",
41 "sort": "-record_date"
42 },
43 timeout=30,
45resp.raise_for_status()
46```
48**Common security descriptions:**
49- `Treasury Bills`
50- `Treasury Notes`
51- `Treasury Bonds`
52- `Treasury Inflation-Protected Securities (TIPS)`
53- `Treasury Floating Rate Notes (FRN)`
54- `Federal Financing Bank`
55- `United States Savings Securities`
56- `Government Account Series`
57- `Total Marketable`
58- `Total Non-marketable`
59- `Total Interest-bearing Debt`
61---

Average Interest Rates on U.S. Treasury Securities

Endpoint: /v2/accounting/od/avg_interest_rates Frequency: Monthly Date Range: January 2001 to present

Average interest rates for marketable and non-marketable Treasury securities, broken down by security type.

Key fields:

FieldTypeDescription
record_dateDATEMonth end date
security_descSTRINGSecurity description (e.g., "Treasury Bills")
security_type_descSTRING"Marketable" or "Non-marketable"
avg_interest_rate_amtPERCENTAGEAverage interest rate (%)
# Get average rates for all marketable securities, most recent month
resp = requests.get(
    "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/avg_interest_rates",
    params={
        "filter": "security_type_desc:eq:Marketable",
        "sort": "-record_date",
        "page[size]": 50
    },
    timeout=30,
)
resp.raise_for_status()
df = pd.DataFrame(resp.json()["data"])
latest = df[df["record_date"] == df["record_date"].max()]
print(latest[["security_desc", "avg_interest_rate_amt"]])

# First-page preview of historical rates for a specific security type
resp = requests.get(
    "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/avg_interest_rates",
    params={
        "fields": "record_date,avg_interest_rate_amt",
        "filter": "security_desc:eq:Treasury Notes,record_date:gte:2010-01-01",
        "sort": "-record_date"
    },
    timeout=30,
)
resp.raise_for_status()

Common security descriptions:

  • Treasury Bills
  • Treasury Notes
  • Treasury Bonds
  • Treasury Inflation-Protected Securities (TIPS)
  • Treasury Floating Rate Notes (FRN)
  • Federal Financing Bank
  • United States Savings Securities
  • Government Account Series
  • Total Marketable
  • Total Non-marketable
  • Total Interest-bearing Debt

Raw lines 3 to 62
63## Treasury Reporting Rates of Exchange
65**Endpoint:** `/v1/accounting/od/rates_of_exchange`
66**Frequency:** Quarterly
67**Date Range:** March 2001 to present
69Official Treasury exchange rates for foreign currencies used by federal agencies for reporting purposes. Updated quarterly (March 31, June 30, September 30, December 31).
71**Key fields:**
72| Field | Type | Description |
73|-------|------|-------------|
74| `record_date` | DATE | Quarter end date |
75| `country` | STRING | Country name |
76| `currency` | STRING | Currency name |
77| `country_currency_desc` | STRING | Combined "Country-Currency" (e.g., "Canada-Dollar") |
78| `exchange_rate` | NUMBER | Units of foreign currency per 1 USD |
79| `effective_date` | DATE | Date rate became effective |
81Fetch the latest `record_date` first, then fetch **all pages** for that date with
82all columns retained. A fixed page of 200 rows can omit currencies/amendments.
83Use `country_currency_desc:eq:Euro Zone-Euro` for euro history, preserving both
84`record_date` and `effective_date`. See [examples.md](examples.md).
86Amendments are separate rows with later effective dates; a rate amended at month
87end applies to the remaining months of the quarter described in the official
88notes. Do not silently deduplicate a currency without choosing a reporting period.
89Multiply USD by the rate for foreign currency; divide foreign currency by the rate
90for USD. These are reporting rates, not daily market quotes.
92---

Treasury Reporting Rates of Exchange

Endpoint: /v1/accounting/od/rates_of_exchange Frequency: Quarterly Date Range: March 2001 to present

Official Treasury exchange rates for foreign currencies used by federal agencies for reporting purposes. Updated quarterly (March 31, June 30, September 30, December 31).

Key fields:

FieldTypeDescription
record_dateDATEQuarter end date
countrySTRINGCountry name
currencySTRINGCurrency name
country_currency_descSTRINGCombined "Country-Currency" (e.g., "Canada-Dollar")
exchange_rateNUMBERUnits of foreign currency per 1 USD
effective_dateDATEDate rate became effective

Fetch the latest record_date first, then fetch all pages for that date with all columns retained. A fixed page of 200 rows can omit currencies/amendments. Use country_currency_desc:eq:Euro Zone-Euro for euro history, preserving both record_date and effective_date. See examples.md.

Amendments are separate rows with later effective dates; a rate amended at month end applies to the remaining months of the quarter described in the official notes. Do not silently deduplicate a currency without choosing a reporting period. Multiply USD by the rate for foreign currency; divide foreign currency by the rate for USD. These are reporting rates, not daily market quotes.


Raw lines 63 to 93
94## TIPS and CPI Data
96Two data tables under `/v1/accounting/od/`:
98| Table | Endpoint | Description |
99|-------|----------|-------------|
100| Summary | `/v1/accounting/od/tips_cpi_data_summary` | Reference CPI numbers and daily index ratios (summary) |
101| Detail | `/v1/accounting/od/tips_cpi_data_detail` | Reference CPI numbers and daily index ratios (detail) |
103**Frequency:** Monthly
104**Date Range:** April 1998 to present
106Treasury Inflation-Protected Securities (TIPS) reference CPI data and index ratios used to calculate TIPS values.
108The summary table describes securities; daily observations live in detail. Neither table uses `record_date`.
110**Key fields:**
111| Field | Type | Description |
112|-------|------|-------------|
113| `cusip` | STRING | Security identifier in both tables |
114| `index_date` | DATE | Daily observation date in the detail table |
115| `index_ratio` | NUMBER | Detail table index ratio |
116| `ref_cpi` | NUMBER | Detail table reference CPI |
117| `ref_cpi_on_dated_date` | NUMBER | Base CPI in the summary table |
119---

TIPS and CPI Data

Two data tables under /v1/accounting/od/:

TableEndpointDescription
Summary/v1/accounting/od/tips_cpi_data_summaryReference CPI numbers and daily index ratios (summary)
Detail/v1/accounting/od/tips_cpi_data_detailReference CPI numbers and daily index ratios (detail)

Frequency: Monthly Date Range: April 1998 to present

Treasury Inflation-Protected Securities (TIPS) reference CPI data and index ratios used to calculate TIPS values.

The summary table describes securities; daily observations live in detail. Neither table uses record_date.

Key fields:

FieldTypeDescription
cusipSTRINGSecurity identifier in both tables
index_dateDATEDaily observation date in the detail table
index_ratioNUMBERDetail table index ratio
ref_cpiNUMBERDetail table reference CPI
ref_cpi_on_dated_dateNUMBERBase CPI in the summary table

Raw lines 94 to 120
121## FRN Daily Indexes
123**Endpoint:** `/v1/accounting/od/frn_daily_indexes`
124**Frequency:** Monthly release (daily index rows per CUSIP)
125**Date Range:** October 2024 onward (current API coverage)
127Daily index values for Treasury Floating Rate Notes (FRNs). The rate is based on the 13-week Treasury bill auction rate. Data is published monthly with daily index rows for each CUSIP.
129---

FRN Daily Indexes

Endpoint: /v1/accounting/od/frn_daily_indexes Frequency: Monthly release (daily index rows per CUSIP) Date Range: October 2024 onward (current API coverage)

Daily index values for Treasury Floating Rate Notes (FRNs). The rate is based on the 13-week Treasury bill auction rate. Data is published monthly with daily index rows for each CUSIP.


Raw lines 121 to 130
131## Treasury Certified Interest Rates
133Four certification periods, each with their own endpoint set:

Treasury Certified Interest Rates

Four certification periods, each with their own endpoint set:

Raw lines 131 to 134
135### Annual Certification
136**Frequency:** Annual
137**Date Range:** October 2006 to present (9 data tables)

Annual Certification

Frequency: Annual Date Range: October 2006 to present (9 data tables)

Raw lines 135 to 138
139### Monthly Certification
140**Frequency:** Monthly
141**Date Range:** October 2006 to present (6 data tables)

Monthly Certification

Frequency: Monthly Date Range: October 2006 to present (6 data tables)

Raw lines 139 to 142
143### Quarterly Certification
144**Frequency:** Quarterly
145**Date Range:** October 2006 to present (4 data tables)

Quarterly Certification

Frequency: Quarterly Date Range: October 2006 to present (4 data tables)

Raw lines 143 to 146
147### Semi-Annual Certification
148**Frequency:** Semi-Annual
149**Date Range:** January 2008 to present (1 data table)
151These certified interest rates are used for federal loans, financing programs, and other purposes requiring official Treasury-certified rates.
153---

Semi-Annual Certification

Frequency: Semi-Annual Date Range: January 2008 to present (1 data table)

These certified interest rates are used for federal loans, financing programs, and other purposes requiring official Treasury-certified rates.


Raw lines 147 to 154
155## Federal Credit Similar Maturity Rates
157**Endpoint:** `/v1/accounting/od/federal_maturity_rates`
158**Frequency:** Annual
159**Date Range:** September 1992 to present
161Interest rates used for valuing federal credit programs (loans and loan guarantees) under the Federal Credit Reform Act.
163---

Federal Credit Similar Maturity Rates

Endpoint: /v1/accounting/od/federal_maturity_rates Frequency: Annual Date Range: September 1992 to present

Interest rates used for valuing federal credit programs (loans and loan guarantees) under the Federal Credit Reform Act.


Raw lines 155 to 164
165## Historical Qualified Tax Credit Bond Interest Rates
167**Frequency:** Daily (Discontinued)
168**Date Range:** March 2009 – January 2018
170Historical interest rates for Qualified Tax Credit Bonds (QTCB). No longer updated.
172---

Historical Qualified Tax Credit Bond Interest Rates

Frequency: Daily (Discontinued) Date Range: March 2009 – January 2018

Historical interest rates for Qualified Tax Credit Bonds (QTCB). No longer updated.


Raw lines 165 to 173
174## State and Local Government Series (SLGS) Daily Rate Table
176**Endpoints:** `/v1/accounting/od/slgs_demand_deposit_rates` and
177`/v1/accounting/od/slgs_time_deposit_rates`
178**Frequency:** Daily
179**Date Range:** June 1992 to present
181Daily interest rates for State and Local Government Series securities, used by state and local issuers to comply with federal tax law arbitrage restrictions.

State and Local Government Series (SLGS) Daily Rate Table

Endpoints: /v1/accounting/od/slgs_demand_deposit_rates and /v1/accounting/od/slgs_time_deposit_rates Frequency: Daily Date Range: June 1992 to present

Daily interest rates for State and Local Government Series securities, used by state and local issuers to comply with federal tax law arbitrage restrictions.

Raw lines 174 to 182
183## Official sources
185Reviewed 2026-09-30 against the current dataset dictionaries and live API responses.
187- [Average Interest Rates Treasury Securities](https://fiscaldata.treasury.gov/datasets/average-interest-rates-treasury-securities/)
188- [Treasury Reporting Rates Exchange](https://fiscaldata.treasury.gov/datasets/treasury-reporting-rates-exchange/)
189- [Tips Cpi Data](https://fiscaldata.treasury.gov/datasets/tips-cpi-data/)
190- [Slgs Daily Rate Table](https://fiscaldata.treasury.gov/datasets/slgs-daily-rate-table/)

Official sources

Reviewed 2026-09-30 against the current dataset dictionaries and live API responses.

Raw lines 183 to 190