Real Personal Consumption Expenditures
Summary
Primary Use: Returns Real Personal Consumption Expenditures (monthly) - the inflation-adjusted measure of consumer spending on goods and services.
Returns: Numeric value (billions of dollars) or table of historical observations.
When to Use:
- Consumer spending analysis
- GDP component research
- Economic growth indicators
- Recession analysis
When NOT to Use:
- For services only (use RealPersonalConsumptionExpServices)
- For nondurable goods (use RealPersonalConsumptionExpNondurableGoods)
- For nominal spending
Alternatives:
- RealPersonalConsumptionExpServices() - Services spending
- RealPersonalConsumptionExpNondurableGoods() - Nondurable goods
- SalesRetailFood() - Retail sales
For Templates: Use =RealPersonalConsumptionExpMonthly("lp") for the most recent consumer spending.
Syntax
=RealPersonalConsumptionExpMonthly([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 Consumer Spending
=RealPersonalConsumptionExpMonthly("lp")Get Last 12 Months
=RealPersonalConsumptionExpMonthly(12)Get Date Range
=RealPersonalConsumptionExpMonthly("2022-01-15","2022-10-15")Related Functions
- RealPersonalConsumptionExpServices() - Services spending
- RealPersonalConsumptionExpNondurableGoods() - Nondurable goods
- SalesRetailFood() - Retail sales
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?