ED.DAYAHEAD
Day-ahead spot price (EUR/MWh) for a single timestamp, any supported European zone.
Signature
ED.DAYAHEAD([date], [hour], [quarter], [zone], [tz])Description
Returns the day-ahead electricity spot price (EUR/MWh) for one timestamp. Sources: OMIE (the official Iberian MIBEL spot market, published around 13:00 CET each day for the next 24 hours) for ES / PT; ENTSO-E Transparency Platform for the rest of Europe.
With no arguments it returns the latest 15-minute price published for Spain. Pass date and hour for the hourly average; add quarter (1-4) for one of the four 15-minute slots inside that hour. The zone argument selects the bidding zone — Iberian (ES, PT), central / western (FR, DE, BE, NL, AT, CH), CEE (PL, HU, CZ, SK, SI, HR), or one of the seven Italian zones (IT_NORD, IT_CNOR, IT_CSUD, IT_SUD, IT_CALA, IT_SARD, IT_SICI).
Every cell is auto-formatted as EUR/MWh with two decimals. For range queries (a series of prices over time) use ED.DAYAHEAD.RANGE.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| date | date | — | YYYY-MM-DD, DD/MM/YYYY, or an Excel date cell. Omit for the latest 15-min price. |
| hour | 0-23 | — | Hour of day in Madrid local time. Omit for the latest hour. |
| quarter | 1-4 | — | Quarter of the hour: 1=:00, 2=:15, 3=:30, 4=:45. Omit for the hourly average. |
| zone | string | "ES" | Bidding zone code. Iberia: "ES", "PT". Central/west: "FR", "DE", "BE", "NL", "AT", "CH". CEE: "PL", "HU", "CZ", "SK", "SI", "HR". Italy: "IT_NORD", "IT_CNOR", "IT_CSUD", "IT_SUD", "IT_CALA", "IT_SARD", "IT_SICI". |
| tz | 0/"madrid" | 1/"cet" | 2/"utc" | "madrid" | Interpretation of the date/hour input. Madrid is DST-aware; CET is fixed UTC+1; UTC is fixed offset 0. |
Returns
Number — price in EUR/MWh.
Examples
=ED.DAYAHEAD()— Latest 15-min ES price (auto-refreshes)=ED.DAYAHEAD("2025-07-01", 14)— ES hour 14 average=ED.DAYAHEAD("2025-12-01", 14, 2)— ES quarter 2 (14:15) of hour 14=ED.DAYAHEAD("2025-07-01", 14, , "PT")— Portugal hour 14=ED.DAYAHEAD("2026-05-15", 14, , "DE")— Germany hour 14 (ENTSO-E)=ED.DAYAHEAD("2026-05-15", 14, , "IT_NORD")— Italy North zone hour 14=ED.DAYAHEAD("2025-10-26", 2, , , "cet")— Fall-DST 02:00 in fixed-CET (disambiguates the duplicated "02:00")Notes
- Quarter-hourly granularity available since 2025-10-01 (EU 15-min settlement period rollout). For earlier dates the hourly value is returned regardless of
quarter. - Portugal and Spain prices are usually identical except during congestion events.
- Availability for non-OMIE zones (FR, DE, BE, NL, AT, CH, PL, HU, CZ, SK, SI, HR, IT_*) depends on the backfill state — see ADR-008. On-demand fetch is not yet wired for these zones; if the requested date predates the latest backfill window the call may return 404. Use
ED.DAYAHEAD.RANGEto inspect coverage.