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()
Excel Desktop (Windows)

Examples

Current M2 money supply
=MoneySupplyM2()/1000
Convert to trillions
Near-money portion
M2 per capita

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.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Money Supply - M2 and Other Financial Formulas
How does MarketXLS work?