Real-time oil & commodity price data in your spreadsheets
Professional-grade API at 98% less cost than Bloomberg Terminal
=OILPRICE("BRENT_CRUDE_USD")Use =OILPRICE() formulas directly in cells. No coding required.
Fetch prices with a simple interface. Select commodities and go.
Standardize all prices to $/MMBtu for easy comparison.
Access 20+ years of daily price history for analysis.
Prices update every 15 minutes. Always current data.
1,000 requests/month free. No credit card required.
// Get latest Brent Crude price
=OILPRICE("BRENT_CRUDE_USD")
// Output: 71.45
// Get 30 days of WTI history
=OILPRICE_HISTORY("WTI_USD", 30)
// Output: Array of [date, price] pairs
// Convert to $/MMBtu for comparison
=OILPRICE_CONVERT("NATURAL_GAS_GBP")
// Output: 99.30 (automatically converted)
// Or use the sidebar:
Extensions → OilPriceAPI → Fetch Prices
→ Select commodities
→ Click Fetch
→ Data appears in "Data" sheet
Currently in development. Expected launch: Early 2026
Track Brent, WTI, Natural Gas side-by-side. Auto-update every 15 minutes.
Chart price trends over months or years. Identify patterns and correlations.
Calculate energy costs based on volume and commodity prices.
Compare energy sources in $/MMBtu. Make informed procurement decisions.
Export data for analysis in Python, R, or other tools.
Set up conditional formatting to highlight price changes.