ED.OMIE.SEGMENTS
Monthly OMIE wholesale settlement by market segment (MWh + €).
Signature
ED.OMIE.SEGMENTS([scope], [segment], [start], [end])Description
OMIE monthly wholesale-market settlement, broken down by segment. One row per (month, segment, scope) with energy traded (MWh), cash flows (€), and weighted average prices (€/MWh).
Segments cover the whole MIBEL stack: mercado_diario (day-ahead), intradiario_subastas (intraday auctions), intradiario_continuo (continuous intraday), reer (post-2020 REER auction settlement specifically), and total (sum across all market sessions).
Scopes select a subset of participants: mibel_total (everything), mibel_es / mibel_pt (per country), or regesp (only RD 413/2014 plants — the historical RRE régime). Source: OMIE ZIP_COMUN public files.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| scope | string | — | Subset of participants — see table below. |
| segment | string | — | Market segment — see table below. |
| start | date | — | Start month (YYYY-MM-DD or YYYY-MM-01). |
| end | date | — | End month. |
Valid values for scope
| Code | English alias | Description |
|---|---|---|
| mibel_total | — | Full MIBEL (Spain + Portugal aggregated). |
| mibel_es | — | Participants with delivery point in Spain only. |
| mibel_pt | — | Participants with delivery point in Portugal only. |
| regesp | rre_plants | Plants under régimen retributivo específico only (RRE, RD 413/2014). |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Valid values for segment
| Code | English alias | Description |
|---|---|---|
| mercado_diario | day_ahead | Day-ahead auction — the bulk of MIBEL volume. |
| intradiario_subastas | intraday_auctions | Intraday auctions (1-3 sessions per day). |
| intradiario_continuo | intraday_continuous | Continuous intraday market (15-min slots). |
| reer | — | REER auction settlement specifically (RD 960/2020). |
| total | — | Sum of every segment in the month. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Returns
Spill array with header: Month, Segment, Scope, MWh sold, MWh bought, EUR collection, EUR payment, EUR balance, €/MWh sold, €/MWh bought.
Examples
=ED.OMIE.SEGMENTS("mibel_es", "total", "2024-01-01", "2026-04-30")— Monthly trajectory of total wholesale value in Spain=ED.OMIE.SEGMENTS("rre_plants", "day_ahead", "2024-01-01", "2026-04-30")— Day-ahead revenue collected by RD 413/2014 plants (English aliases)=ED.OMIE.SEGMENTS("regesp", "mercado_diario", "2024-01-01", "2026-04-30")— Same query in Spanish — equivalent=ED.OMIE.SEGMENTS("mibel_total", "reer", "2024-01-01", "2026-04-30")— REER-auction settlement volumes & balances