Federal Funds Rate
Returns the effective federal funds rate, the interest rate at which banks lend reserve balances to other banks overnight. This is the primary monetary policy tool of the Federal Reserve.
Data Source
Federal Reserve via FRED.
Usage Notes
- No parameters required
- Returns rate as a percentage
- Data updated daily
- This is the EFFECTIVE rate (actual market rate), not the target
Fed Funds Rate Significance
The fed funds rate is the most important interest rate in the U.S. economy:
| Impact Area | How It Affects |
|---|---|
| Borrowing costs | Higher rate = higher loans, mortgages |
| Savings rates | Higher rate = better deposit yields |
| Asset prices | Higher rate = lower stock/bond prices |
| Dollar strength | Higher rate = stronger USD |
Current Cycle Context
The Fed raises rates to fight inflation and lowers rates to stimulate growth.
Syntax
=FederalFundsRate()Returns
Effective federal funds rate as a percentage
Examples
When to Use
- Tracking Federal Reserve monetary policy
- Interest rate analysis
- Economic forecasting
- Building fixed income models
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need mortgage rates | MortgageRate30y() |
| Need corporate bond yields | BondYieldAAA() |
| Need Treasury yields | TreasuryInflationProtectedSecurities10y() |
Common Issues & FAQ
Is this the target rate or effective rate?
This is the EFFECTIVE federal funds rate (actual market rate), which trades close to but not exactly at the Fed's target.
When does the Fed change rates?
The FOMC meets 8 times per year and can adjust the target range. Rate decisions are announced at 2:00 PM ET on meeting days.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Federal Outlays
- Federal Receipts
- Federal Surplus or Deficit
- Gasoline Price
- GDP Price Deflator
- Hires - Nonfarm
- House Price Index
- House Price Index - Shiller 20 City
See FederalFundsRate used in a complete workbook: Jobs Report Tracker Excel: Live Labor Market Dashboard for May 2026 NFP
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today