Producer Price Index - Final Demand
Returns the Producer Price Index (PPI) for final demand, which measures price changes for goods and services sold to final users (consumers, government, businesses for investment, exports).
Data Details
| Attribute | Value |
|---|---|
| Source | Bureau of Labor Statistics (BLS) / FRED |
| Frequency | Monthly |
| Unit | Index |
| Base Period | November 2009 = 100 |
Notes
- Key measure of producer-level inflation
- Often seen as a leading indicator for CPI
- Includes all final demand categories (personal consumption, government, investment, exports)
Syntax
=ProducerPriceIndexFinalDemand()Returns
number
Producer Price Index for final demand
Examples
Current PPI final demand
Food & energy contribution
When to Use
- Tracking producer-level inflation
- Forecasting consumer inflation
- Cost analysis for businesses
- Economic research on prices
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need core PPI (ex food/energy) | ProducerPriceIndexFinalDemandWithoutFoodEnergy() |
| Need consumer prices | ConsumerPriceindex() |
| Need crude materials prices | ProducerPriceIndexCrudeGoods() |
Common Issues & FAQ
What is the base period?
November 2009 = 100.
How is PPI different from CPI?
PPI measures prices received by producers; CPI measures prices paid by consumers. PPI often leads CPI.
What is final demand?
Goods and services sold to final users (not for resale or further processing).
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
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?