Day-ahead spot prices

Suiza 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: SuizaSource: ENTSO-ESince: 2001See all 12 Electricity Prices metrics in the catalog →

Last 30 Days

Daily average price

=ED.DAYAHEAD.RANGE(,, 2, , "CH")— Last 30 days daily

Monthly Averages

Last 2 years

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

Annual Averages

Historical annual average prices

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

Country

Suiza

Resolution

Hourly (ENTSO-E)

Source

ENTSO-E

Excel Formulas

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

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

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

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

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