Crude Oil Prices
Returns the spot price of crude oil (typically WTI - West Texas Intermediate), a key benchmark for global energy markets.
Data Source
Energy Information Administration (EIA) via FRED.
Usage Notes
- No parameters required
- Returns price in U.S. dollars per barrel
- Data updated daily
- Key driver of inflation and energy sector
Oil Price Context
| Price Range | Market Condition |
|---|---|
| < $40 | Low - stress for producers |
| $40-70 | Moderate |
| $70-100 | Elevated |
| > $100 | High - inflationary pressure |
Economic Impact
Oil prices affect:
- Transportation costs
- Inflation (CPI energy component)
- Energy sector earnings
- Consumer spending
Syntax
=CrudeOilPrice()Returns
number
Crude oil spot price in dollars per barrel
Examples
Crude oil spot price ($/barrel)
When to Use
- Tracking energy prices
- Inflation forecasting
- Energy sector analysis
- Transportation cost modeling
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need real-time oil quotes | Last() with oil futures symbol |
| Need gasoline prices | GasolinePrice() |
| Need natural gas | NaturalGasPrice() |
| Need energy CPI | ConsumerPriceindexEnergy() |
Common Issues & FAQ
Is this WTI or Brent?
Check the data source - typically this is WTI (West Texas Intermediate), the U.S. benchmark.
How do I get real-time oil prices?
Use =Last("CL=F") for WTI crude oil futures quotes.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Currency In Circulation
- Dow Jones Industrial Average
- Employees - Goods Producing
- Employees - Government
- Employees - Nonfarm Payroll
- Employees - Private
- Employees - Service Providing
- Federal Debt
See CrudeOilPrice used in a complete workbook: Google Finance API: Essential Tips and Professional Alternatives for 2026
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?