Treasury Rate - 1 Year
Returns the 1-year constant maturity Treasury rate from FRED.
Data Source
Data is sourced from the Federal Reserve H.15 release via FRED, updated daily.
Notes
- Expressed as annual percentage yield
- Risk-free rate benchmark
- Used for short-term discounting
Syntax
=TreasuryRate1y()Returns
number
1-year Treasury rate as percentage
Examples
1-year Treasury rate
Yield curve slope (10y-1y)
When to Use
- Risk-free rate calculations
- Yield curve analysis
- Fixed income research
- Bond pricing benchmarks
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Long-term rate | TreasuryRate10y() |
| Very short-term | TreasuryRate3m() |
| Medium-term | TreasuryRate5y() |
Common Issues & FAQ
Is this a bid or ask rate?
It's the constant maturity rate, derived from the yield curve.
How often is this updated?
Daily, following market close.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- U.S - Euro Foreign Exchange Rate
- U.S - UK Foreign Exchange Rate
- U.S Dollar Index
- Unemployment Rate
- Vehicle Sales - Light Weight
- Wilshire 5000 Total Market Index
- Average Hourly Earnings - Private
- Average Weekly Hours of Production
See TreasuryRate1y used in a complete workbook: Yield Curve Dashboard Excel: June 2026 Recession Indicator and Treasury Spread Tracker
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?