Market Data
Spanish energy market data. Updated daily from official sources.
Last update: 2026-04-07
OMIE Day-Ahead Price
Last 30 days, daily average (EUR/MWh)
=ED.OMIE.RANGE("2025-01-01", , 2)
Generation Mix
Last 7 days, daily average (MW)
=ED.GEN.RANGE("2025-01-01", , 2, 1)
Capture Prices
Solar vs Wind vs Baseload, monthly (EUR/MWh)
=ED.CAPTURE.RANGE("2024-01-01", , 3, 1)
Commodities
Brent Crude (USD/bbl) & EU ETS CO2 (EUR/t), last 12 months
=ED.GET("brent") | =ED.GET("eua_co2")
Get all this data in Excel
120+ metrics with a simple formula. Free tier available.
Install Excel Add-in