Back to data
Day-ahead spot prices
Great Britain electricity market clearing price (GBP/MWh) per delivery period. Native 15-min for ES/PT (OMIE) and hourly for the EU cluster (ENTSO-E A44). GB is a live external feed (daily cron, runs current) in native GBP; the read path also returns value_eur.
Zone: Great BritainSource: ENTSO-E A44 / Elexon BMRSSince: 2001See all 12 Electricity Prices metrics in the catalog →
Last 30 Days
Daily average price
=ED.DAYAHEAD.RANGE(,, 2, , "GB")— Last 30 days dailyMonthly Averages
Last 2 years
=ED.DAYAHEAD.RANGE("2024-01-01",, 3, , "GB")— Monthly since 2024Annual Averages
Historical annual average prices
=ED.DAYAHEAD.RANGE("2001-01-01",, 6, , "GB")— Annual averagesCountry
Great Britain
Resolution
Hourly
Currency
GBP (native) · value_eur
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