Producer Price Index - Material
Returns the Producer Price Index (PPI) for materials from the Federal Reserve Economic Data (FRED). This measures the average change over time in selling prices received by domestic producers for materials.
Data Source
Data is sourced from FRED (Federal Reserve Economic Data), updated monthly.
Notes
- Value represents the index level (base period = 100)
- No parameters required - returns the most recent value
- Historical data can be accessed through FRED directly
Syntax
=ProducerPriceIndexMaterial()Returns
number
Producer Price Index for materials
Examples
Current PPI for materials
When to Use
- Analyzing producer-level inflation
- Tracking material cost changes
- Economic research and analysis
- Inflation forecasting models
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Consumer price data | ConsumerPriceIndex() |
| Specific commodity prices | Commodity-specific functions |
| Historical time series | FRED direct access |
Common Issues & FAQ
Why is there no date parameter?
This function returns the most recent available data point. For historical data, access FRED directly.
How often is this updated?
Monthly, following FRED's release schedule.
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?