Live Oil & Gas PricesDirectly in Excel
Stop copying prices manually. Get real-time WTI, Brent, Natural Gas, and 100+ commodities with custom Excel formulas.No coding required. Free tier included.
| Commodity | Price | Change |
|---|---|---|
| Brent Crude | $82.30 | +2.3% |
| WTI Crude | $78.45 | +1.8% |
| Natural Gas | $2.45 | -0.5% |
Why Excel? Because That's Where You Work
90% of energy traders, analysts, and procurement teams use Excel for analysis. Bloomberg's #1 feature? Excel integration ($24,000/year).Ours is free.
No Coding Required
Simple formulas like =OILPRICE("WTI"). If you know Excel, you're already an expert.
Your Existing Workflows
Keep using your spreadsheets, models, and reports. Just add live data with one formula.
Auto-Refresh Data
Set it and forget it. Prices update automatically every 5 minutes during trading hours.
Everything You Need
Professional features without the Bloomberg price tag
Custom Excel Functions
FREEUse =OILPRICE(), =OILPRICE_HISTORY(), =OILPRICE_CONVERT() in any cell
Real-Time Updates
FREEPrices refresh every 5 minutes during trading hours
Historical Data
Pull 20+ years of price history for trend analysis
Unit Conversions
FREEAutomatic $/barrel to $/MBtu conversions for gas equivalents
Enterprise Security
FREESOC 2 certified, bank-level encryption, HTTPS-only
Team Sharing
FREEShare workbooks with colleagues, everyone stays in sync
Get Started in 2 Minutes
Three simple steps to live oil prices in Excel
Install the Add-In
30 secondsClick "Install Free Add-In" → Opens in Excel → Click "Get It Now"
Get Your Free API Key
1 minuteSign up at OilPriceAPI.com → Copy your key → Paste in Excel sidebar
Start Using Formulas
30 secondsType =OILPRICE("BRENT_CRUDE_USD") in any cell → Press Enter → Done!
See It In Action
Watch how easy it is to get live oil prices in Excel
Demo Video Coming Soon
60-second walkthrough showing installation to first formula
Start Free, Upgrade When Ready
100 free requests to get started. Need more? Plans start at $15/month.
Who Uses Our Excel Add-In?
Trusted by energy professionals across industries
Energy Traders
Monitor Brent-WTI spreads in real-time for arbitrage opportunities
2-5 minute faster reaction to price movements
Financial Analysts
Build valuation models with live commodity price inputs
Models stay current without manual updates
Procurement Teams
Track diesel and fuel oil prices for contract negotiations
Better timing on bulk fuel purchases
Frequently Asked Questions
Is it really free?
Yes! 100 lifetime API requests included free. No credit card required. Upgrade to paid plans for higher request limits and historical data.
Do I need to know programming?
Not at all. If you know how to use Excel formulas like =SUM() or =AVERAGE(), you already know everything you need.
Which commodities are supported?
WTI, Brent, Natural Gas, Coal, Gasoline, Diesel, and 100+ others including futures, metals, and currencies.
How often do prices update?
Every 5 minutes during trading hours. You can manually refresh anytime or set automatic updates.
Can I share spreadsheets with my team?
Yes! Anyone with the add-in installed can use your shared workbooks. Each person needs their own free API key.
Is historical data included?
Historical data (20+ years) requires a paid plan starting at $15/month. Real-time current prices are always free.
Ready to Stop Copy-Pasting Prices?
Join energy analysts, traders, and procurement teams using our Excel add-in.Free forever. 2-minute setup. No credit card.
Have questions? Check our support guide or contact us