Monetary Base
Summary
Primary Use: Returns the Monetary Base - the total amount of currency in circulation plus commercial bank reserves held at the central bank.
Returns: Numeric value (billions of dollars) or table of historical observations.
When to Use:
- Money supply analysis
- Monetary policy research
- Federal Reserve balance sheet analysis
- Liquidity assessment
When NOT to Use:
- For currency only (use CurrencyInCirculation)
- For interest rates (use FederalFundsRate)
- For broader money supply (use M2 functions)
Alternatives:
- CurrencyInCirculation() - Currency component only
- FederalFundsRate() - Monetary policy rate
- Money supply functions
For Templates: Use =MonetaryBase("lp") for the most recent monetary base value.
Syntax
=MonetaryBase([parameter1], [parameter2])Parameters
| Parameter | Required | Description |
|---|---|---|
| parameter1 | No | Number of observations, date, "lp" for last period, or "status" |
| parameter2 | No | End date when parameter1 is a start date |
Examples
Get Most Recent Monetary Base
=MonetaryBase("lp")Get Last 12 Months
=MonetaryBase(12)Get Date Range
=MonetaryBase("2022-01-15","2022-10-15")Related Functions
- CurrencyInCirculation() - Currency in circulation
- FederalFundsRate() - Federal funds rate
- Money supply functions
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?