ED.OMIE
Day-ahead spot price (EUR/MWh) for a single timestamp.
Signature
ED.OMIE([date], [hour], [quarter], [zone], [tz])Description
Returns the OMIE day-ahead electricity price (EUR/MWh) for one timestamp. Source is the official Iberian (MIBEL) spot market, published by OMIE around 13:00 CET each day for the next 24 hours.
With no arguments it returns the latest 15-minute price published. 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 switches between Spain ("ES") and Portugal ("PT"), which can diverge during transmission congestion.
Every cell is auto-formatted as EUR/MWh with two decimals. For range queries (a series of prices over time) use ED.OMIE.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 | "ES" | "PT" | "ES" | MIBEL zone. |
| 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.OMIE()— Latest 15-min price (auto-refreshes)=ED.OMIE("2025-07-01", 14)— Hour 14 average=ED.OMIE("2025-12-01", 14, 2)— Quarter 2 (14:15) of hour 14=ED.OMIE("2025-07-01", 14, , "PT")— Portugal hour 14=ED.OMIE("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.