Consumer Price Index - Energy
Returns the Consumer Price Index for energy commodities and services, measuring price changes in gasoline, fuel oil, electricity, and natural gas.
Data Source
Bureau of Labor Statistics (BLS) - Consumer Price Index.
Usage Notes
- No parameters required
- Index value (1982-84 base = 100)
- Data updated monthly
- Highly volatile due to oil price swings
Energy CPI Components
| Component | Examples |
|---|---|
| Energy commodities | Gasoline, fuel oil |
| Energy services | Electricity, natural gas (utility) |
Volatility Note
Energy prices are among the most volatile CPI components, which is why they're excluded from "core" inflation measures.
Syntax
=ConsumerPriceindexEnergy()Returns
number
CPI Energy index value
Examples
Current CPI energy index
When to Use
- Tracking energy inflation
- Analyzing fuel cost trends
- Understanding inflation volatility
- Energy sector analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need headline CPI | ConsumerPriceindex() |
| Need core CPI | ConsumerPriceindexWithoutFoodEnergy() |
| Need crude oil spot price | CrudeOilPrice() |
| Need gasoline price | GasolinePrice() |
Common Issues & FAQ
Why is energy CPI so volatile?
Energy prices are heavily influenced by global oil markets, geopolitical events, and seasonal demand, making them highly volatile.
Does this include electricity?
Yes, it includes both energy commodities (gasoline, fuel oil) and energy services (electricity, natural gas utilities).
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?