Spanish energy market data. In Excel. In seconds.
120+ metrics from OMIE, ESIOS, OMIP, and international commodities. Spot prices, generation, capture prices, futures, balancing, and more — all with a simple Excel formula.
=ED.OMIE()→ 72.45=ED.CAPTURE("2025-07-01", 1)→ 35.37=ED.GEN(,, 2)→ 12,450=ED.GET("brent")→ 67.63=ED.GET("eua_co2")→ 73.15=ED.GET("futures_yr")→ 55.95Everything you need for energy analysis
One add-in. 120+ metrics. All major Iberian energy data sources.
Day-Ahead Spot
15-minOMIE prices ES/PT
Futures & PPA
Cal+10OMIP M/Q/Y/PPA
Capture Prices
6 techsSolar, wind, nuclear...
Balancing
aFRR/mFRRSecondary, tertiary
Tech Constraints
Phase I+IIRedispatch + ERNI
Commodities
Brent/CO2Oil, gas, carbon
Capture prices for 6 technologies
Production-weighted average electricity price — validated against industry sources.
Solar
=ED.CAPTURE(,1)
Wind
=ED.CAPTURE(,2)
Nuclear
=ED.CAPTURE(,3)
Hydro
=ED.CAPTURE(,4)
Gas
=ED.CAPTURE(,5)
Coal
=ED.CAPTURE(,6)
9 functions. Infinite possibilities.
From a single spot price to a full forward curve analysis — all from Excel formulas you already know how to use. Auto-formatted dates, prices, and volumes.
// Monthly solar capture price 2025
=ED.CAPTURE.RANGE("2025-01-01", , 3, 1)
// Auto-formatted dates + EUR/MWh
Simple, transparent pricing
Start free. Upgrade when you need more.
Pro
$19/mo
- Hourly + 15-min data
- Full history (2014+)
- 120+ metrics
- Capture prices (6 techs)
- Futures + commodities
- Balancing + RRTT
Premium
$39/mo
- Everything in Pro
- RRTT by unit (liquidation)
- 15-min resolution
- Clean spark/dark spread
- Forward curve analysis
- Priority support
Built for energy professionals
Market Analysts
Daily prices, generation mix, demand forecasts, spreads
Renewable Developers
Capture prices, RRTT impact, curtailment analysis
Financial Modelers
Historical data for DCFs, sensitivity, PPA valuation
Consultants & Academics
Easy access to structured data for reports and research
Start exploring Spanish energy data
Free tier available. No credit card required.