Money Supply - M2
Returns the M2 money supply in billions of dollars. M2 is a broader measure of money supply that includes M1 plus savings deposits, small time deposits, and retail money market funds.
Data Details
| Attribute | Value |
|---|---|
| Source | Federal Reserve / FRED |
| Frequency | Weekly/Monthly |
| Unit | Billions of USD |
| Components | M1 + Savings + Small Time Deposits + Retail MMFs |
Notes
- M2 is the most commonly watched money supply measure
- Includes near-money assets that can be quickly converted to cash
- Federal Reserve stopped publishing M3 in 2006
Syntax
=MoneySupplyM2()Returns
number
M2 money supply in billions of dollars
Examples
Current M2 money supply
=MoneySupplyM2()/1000Near-money portion
=MoneySupplyM2()/Population()When to Use
- Analyzing money supply trends
- Tracking monetary policy effects
- Inflation forecasting
- Economic research on money and growth
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need only liquid money | MoneySupplyM1() |
| Need monetary base | MonetaryBase() |
| Need just currency | CurrencyInCirculation() |
Common Issues & FAQ
What unit is the result in?
Billions of U.S. dollars.
What is included in M2?
M1 (currency, checking deposits) plus savings deposits, small time deposits, and retail money market funds.
Why is M2 important?
M2 growth is closely watched as an indicator of future inflation and economic activity.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Mortgage Rate - 15 Year
- Mortgage Rate - 30 Year
- Natural Gas Price
- Personal Savings Rate
- Population
- Producer Price Index - Crude Goods
- Producer Price Index - Final Demand
- Producer Price Index - Final Demand (Excluding Food and Energy)
See MoneySupplyM2 used in a complete workbook: Buffett Indicator Dashboard Excel: June 2026 Market Cap to GDP Valuation Tool
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?