Back to Market Data
Day-Ahead Spot Prices
OMIE Iberian electricity market day-ahead prices (EUR/MWh). Data from 2001.
Last 30 Days
Daily average price
=ED.OMIE.RANGE(,, 2)— Last 30 days dailyMonthly Averages
Last 2 years
=ED.OMIE.RANGE("2024-01-01",, 3)— Monthly since 2024Annual Averages
Since 2001 — 25 years of data
=ED.OMIE.RANGE("2001-01-01",, 6)— Annual since 2001Data available from
June 2001
Resolution
15-minute, hourly, daily
Zones
Spain (ES), Portugal (PT)
Excel Formulas
=ED.OMIE()— Latest 15-min spot price=ED.OMIE("2025-07-01", 14)— Specific date and hour=ED.OMIE.RANGE("2025-01-01",, 3)— Monthly range=ED.OMIE.RANGE("2025-07-01", "2025-07-01", 0)— Quarter-hourly (96 values)