Producer Price Index - Finished Goods (Excluding Food and Energy)
Returns the core Producer Price Index (PPI) for finished goods, excluding volatile food and energy components to reveal underlying inflation trends.
Data Details
| Attribute | Value |
|---|---|
| Source | Bureau of Labor Statistics (BLS) / FRED |
| Frequency | Monthly |
| Unit | Index |
| Excludes | Food and energy components |
Notes
- Core measure removes volatile food and energy prices
- Shows underlying trend in finished goods prices
- Historical series (newer methodology uses final demand)
Syntax
=ProducerPriceIndexFinishedGoodsWithoutFoodEnergy()Returns
number
Core PPI for finished goods excluding food and energy
Examples
=ProducerPriceIndexFinishedGoodsWithoutFoodEnergy()=ProducerPriceIndexFinishedGoods()-ProducerPriceIndexFinishedGoodsWithoutFoodEnergy()When to Use
- Analyzing underlying finished goods inflation
- Removing food/energy volatility from PPI
- Historical core PPI analysis
- Long-term inflation trend analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need headline finished goods PPI | ProducerPriceIndexFinishedGoods() |
| Need current core PPI methodology | ProducerPriceIndexFinalDemandWithoutFoodEnergy() |
| Need consumer core CPI | ConsumerPriceindexWithoutFoodEnergy() |
Common Issues & FAQ
Why exclude food and energy?
These categories are highly volatile and can distort the underlying inflation picture.
Should I use this or final demand core PPI?
Final demand methodology is current standard, but finished goods has longer historical data.
Is this the same as core CPI?
No, this is producer prices; CPI is consumer prices. Both exclude food and energy for "core" measure.
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?