Day-ahead spot prices

Spain electricity market clearing price (EUR/MWh) per delivery period. Native 15-min for ES/PT (OMIE) and hourly for FR/DE/BE/NL (ENTSO-E A44). Spans the full intraday auction history where available; intraday-continuous (XBID) is on the dedicated continuous_avg metric.

Zone: SpainSource: OMIESince: 2001See all 12 Electricity Prices metrics in the catalog →

Last 30 Days

Daily average price

=ED.OMIE.RANGE(,, 2)— Last 30 days daily

Monthly Averages

Last 2 years

=ED.OMIE.RANGE("2024-01-01",, 3)— Monthly since 2024

Annual Averages

Historical annual average prices

=ED.OMIE.RANGE("2001-01-01",, 6)— Annual averages

Country

Spain

Resolution

15-minute (OMIE)

Source

OMIE

Excel Formulas

=ED.OMIE()— Latest 15-min spot price (ES)

=ED.OMIE("2025-07-01", 14)— Specific date and hour

=ED.OMIE("2025-07-01", 14, , "PT")— Portugal price

=ED.OMIE("2025-07-01", 14, , "FR")— France price (ENTSO-E)

=ED.OMIE.RANGE("2025-01-01",, 3)— Monthly range