Skip to main content
Excel Add-in

Live Commodity PricesRight in Your Spreadsheet

Pull real-time oil, gas, and energy prices into Excel with simple formulas. No VBA. No macros. Just powerful custom functions that work like built-in Excel formulas.

Join WaitlistUse API Now

Add-in launching Q1 2025 • API available today

As Easy as =SUM()

Your Formulas

=OILPRICE("WTI_USD")
=OILPRICE("BRENT_CRUDE_USD", "2024-01-15")
=OILPRICE_AVG("DIESEL_USD", 30)

Live Results

$73.45
$78.32
$2.89

Built For Your Workflow

🏭

Procurement Teams

Compare vendor quotes against live market prices. Calculate optimal purchase timing.

=IF(OILPRICE("DIESEL") < B2, "BUY", "WAIT")
📊

Financial Analysts

Build hedge effectiveness models. Test price volatility scenarios in real-time.

=STDEV(OILPRICE_RANGE("WTI", 90))
💼

Energy Consultants

Create client reports with live data. Historical analysis at your fingertips.

=SPARKLINE(OILPRICE_HISTORY("BRENT", 365))

Powerful Features

⚡

Auto-Refresh

Set refresh intervals. Your spreadsheet stays current automatically.

📅

Historical Data

Pull years of pricing history. Build trend analyses and forecasts.

🌍

100+ Commodities

Oil, gas, diesel, heating oil, metals, currencies, and more.

📈

Aggregation Functions

Built-in AVG, MIN, MAX, STDEV functions for price analysis.

🔒

Secure & Private

Your API key stored securely. Data never leaves your control.

☁️

Works Everywhere

Excel Desktop, Excel Online, and Excel for Mac supported.

Custom Functions Reference

All the formulas you need for energy price analysis

OILPRICE(code, [date])

Get price for a commodity. Optional date for historical prices.

Example: =OILPRICE("WTI_USD", "2024-01-15")
OILPRICE_AVG(code, days)

Calculate average price over specified number of days.

Example: =OILPRICE_AVG("BRENT_CRUDE_USD", 30)
OILPRICE_MIN(code, days)

Find minimum price in specified period.

Example: =OILPRICE_MIN("DIESEL_USD", 90)
OILPRICE_MAX(code, days)

Find maximum price in specified period.

Example: =OILPRICE_MAX("NATURAL_GAS_USD", 365)
OILPRICE_CHANGE(code, days)

Calculate percentage change over period.

Example: =OILPRICE_CHANGE("WTI_USD", 7)
OILPRICE_RANGE(code, days)

Return array of prices for charting or analysis.

Example: =SPARKLINE(OILPRICE_RANGE("BRENT", 90))

Why OilPriceAPI for Excel?

Bloomberg Terminal

$2,000/mo

  • ✗ Expensive per-user licensing
  • ✗ Steep learning curve
  • ✗ Limited Excel integration
  • ✗ Overkill for most needs

Manual Copy-Paste

Free (but...)

  • ✗ Time-consuming daily updates
  • ✗ Human error prone
  • ✗ No historical automation
  • ✗ Doesn't scale
BEST CHOICE

OilPriceAPI

$15/mo

  • ✓ Simple Excel formulas
  • ✓ Auto-refresh data
  • ✓ Full historical access
  • ✓ Unlimited spreadsheets

Real-World Examples

Fuel Procurement Calculator

Compare vendor quotes to market prices and calculate optimal purchase volume.

Market Price: =OILPRICE("DIESEL_USD")
Vendor Margin: =(B2-A2)/A2
Recommendation: =IF(C2<0.05, "Good Deal", "Too High")

Monthly Price Report

Generate monthly summary with averages, highs, lows, and volatility.

Avg Price: =OILPRICE_AVG("WTI_USD", 30)
High: =OILPRICE_MAX("WTI_USD", 30)
Volatility: =STDEV(OILPRICE_RANGE("WTI", 30))

Hedge Effectiveness Test

Calculate correlation between actual and hedged commodity exposure.

Actual: =OILPRICE_RANGE("BRENT", 90)
Hedged: =B2:B91 * $C$1
Correlation: =CORREL(A2:A91, D2:D91)

Budget Forecast Model

Project fuel costs based on historical trends and volume estimates.

30d Trend: =OILPRICE_CHANGE("DIESEL", 30)
Projected Price: =OILPRICE("DIESEL")*(1+A2)
Budget Impact: =B2 * VolumeEstimate

Be First to Get the Excel Add-in

Launching Q1 2025. Join the waitlist for early access and exclusive launch pricing.

Or start using the API today

Frequently Asked Questions

When will the Excel add-in be available?

We're targeting Q1 2025 for the initial release. Join the waitlist to be notified when it launches and get early access pricing.

Will it work with Excel for Mac?

Yes! The add-in uses Office.js which works across Excel Desktop (Windows & Mac), Excel Online, and Excel for iPad.

Do I need to know programming?

No. If you can write Excel formulas like =SUM() or =VLOOKUP(), you can use our custom functions. No VBA or coding required.

How much data can I pull?

Depends on your API plan. The add-in uses your OilPriceAPI account. Plans start at 10,000 requests/month (plenty for most spreadsheets).

Can I use the API directly today?

Yes! While the add-in is in development, you can use our REST API with Power Query or VBA. Full documentation available.

Is there an additional cost for the Excel add-in?

No. The add-in is included free with your OilPriceAPI subscription. You only pay for API usage.