ED.OFFER.STRATEGY

OMIE day-ahead offer strategy by tech — splits offered volume into 4 price tiers (negative, zero, positive real, safety-bid). Companion to ED.OMIE.BIDS focused on bidding behavior rather than volumes.

Capture price

Signature

ED.OFFER.STRATEGY([tech], [start], [end], [agg], [zone], [headers])

Description

Returns the OMIE day-ahead offer strategy of each technology by splitting the offered volume (side='V', status='O') across 4 price tiers per (bucket, tech):

- mwh_neg — volume offered at **< 0 €/MWh** (plant is willing to pay to clear; must-run, hedge, gaming against the price floor). - mwh_zero — volume offered at **exactly 0 €/MWh** (exact price-takers: "clear me at whatever"). - mwh_pos_real — volume offered at **0 < p < 180 €/MWh** (competitive real bids). - mwh_safety — volume offered at **≥ 180 €/MWh** (safety bids near the cap; the plant is not really willing to clear at this price).

Plus the two headline percentages:

- pct_neg — 100 × mwh_neg / total_offered. - pct_safety — 100 × mwh_safety / total_offered.

And n_slots (count of distinct hourly slots with any offered volume in the bucket × tech).

**Killer insight** (Dec 2025 ES, default range): solar **88% negative** (cannibalised price-taker), gas/nuclear **30-50% safety** (rarely willing to clear above 180€/MWh). Nuclear paradox: ~46% negative (avoiding shutdowns) + ~10% safety (reserve capacity).

**Why this function exists**: ED.OMIE.BIDS returns volumes + clearing rates but doesn't explain *how* each tech bids. ED.OFFER.STRATEGY is the bidding-behavior companion: which tier dominates each tech's offer book over time.

**Tech enum (18 accepted values — identical to ED.OMIE.BIDS)**:

- *Renewables*: solar, wind, vre (= solar+wind+renewable_other+vre_unspecified), hydro, bombeo, bess, hybrid. - *Thermal*: nuclear, coal, thermal_gas, thermal_fueloil, thermal (alias for thermal_gas + thermal_fueloil), biomass, cogen. - *Other*: autoprod. - *Aggregator*: all (default) — every classified real tech, ex interconnects + non-generation labels. - *Special*: interconnect — INVERTED filter; returns only MIEU/MIP/MIE. Note: interconnects typically have **zero offered side** in OMIE data, so all four MWh bins may be 0 and the percentages NULL.

Rejected with 400 (with explanatory hints): placeholder, unknown, representation, venta_generica, and any other unrecognised string.

**Expansion semantics**: vre/all/thermal cause the output to spill ONE row per sub-tech. Single-tech values keep the literal you asked for as the row label.

Parameters

Name	Type	Default	Description
tech	string	"all"	Tech filter. Default `"all"` (= every classified real tech). Same 18-value enum as `ED.OMIE.BIDS`.
start	date	—	YYYY-MM-DD. Omit for `end − 1 year`.
end	date	—	YYYY-MM-DD. Omit for the first day after the last available month (OMIE publishes monthly with ~90-day lag).
agg	1..7	6	1=hourly, 2=daily, 3=monthly, 4=quarterly, 5=semiannual, 6=annual (default), 7=total. String aliases H/D/M/Q/S/Y/T also accepted.
zone	"es" \| "pt" \| "iberian"	"es"	Geographic filter. `es` → `pais IN ('ES','MI')` (default), `pt` → `pais IN ('PT','MI')`, `iberian` → `pais IN ('ES','PT','MI')` (includes the MIBEL `pais='MI'` bucket).
headers	0 \| 1	0	Set 1 for a header row.

Returns

Spill matrix — 9 columns: [bucket, tech, mwh_neg, mwh_zero, mwh_pos_real, mwh_safety, pct_neg, pct_safety, n_slots]. One row per (bucket, tech) pair. pct_neg/pct_safety are NULL when total offered is 0 in the bucket (e.g. interconnects). For agg=7 (total) bucket is the literal string "TOTAL".

Examples

=ED.OFFER.STRATEGY()— Last 12 months offer strategy all techs ES, yearly (all defaults)

=ED.OFFER.STRATEGY("solar", "2025-12-01", "2025-12-31", 3, "es")— Monthly solar Dec 2025 ES — pct_neg ≈ 88% (the headline cannibalised-solar insight)

=ED.OFFER.STRATEGY("thermal_gas", "2025-01-01", "2025-12-31", 6, "es")— Annual thermal_gas 2025 ES — pct_safety typically 30-50%

=ED.OFFER.STRATEGY("vre", "2025-01-01", "2025-12-31", 3, "iberian")— Monthly VRE 2025 Iberian (4 sub-techs spilling separately)

=ED.OFFER.STRATEGY("nuclear", "2025-01-01", "2025-12-31", 6, "es", 1)— Annual nuclear 2025 ES with header row (paradox: high pct_neg + non-trivial pct_safety)

=ED.OFFER.STRATEGY("all", "2024-01-01", "2026-01-01", 6, "es")— Annual all-tech 2024-2025 ES — yearly breakdown for board-deck charts

Notes

**Tier boundaries are fixed** at 0 and 180 €/MWh. The < 0 and = 0 split mirrors the conceptual difference between "willing to pay" (gaming the floor) and "price-taker" (exact zero). The 180 cap is the canonical safety-bid floor observed in MIBEL CCGT/nuclear behaviour (price-cap is 4,000 €/MWh but ≥180 captures the safety-bid intent). Re-bucket in Excel post-fetch if you need different thresholds.
**Granularity asymmetry (Schema A/B vs C)**: pre-March-2025 OMIE files are 60-min granularity (granularity_min=60); post-March-2025 are mixed 60-min + 15-min (granularity_min=15 for the 15-min product). The qty_mw * granularity_min / 60.0 normalisation is applied uniformly — no double-counting — but the share of slots will appear higher post-March-2025 (4× more 15-min slots per hour).
**History cliff**: OMIE bid-curve dataset starts in **January 2018**. Queries with start < 2018-01-01 will return rows starting at the dataset boundary; bucket aggregates will be partial for the boundary bucket.
**Publication lag**: OMIE publishes monthly bid-curve data with ~90-day confidentiality lag. Queries for too-recent dates return 404 with the last-available month in the body (last_available_mes).
**Special case tech=interconnect**: filter is INVERTED — keeps only MIEU/MIP/MIE. Tech bucket is the literal string 'interconnect'. Since interconnects typically have **zero offered side** in OMIE data, all four MWh bins may be 0 and the percentages NULL — informative as a sanity check, not as a strategy claim.
**Expansion semantics**: vre/all/thermal cause the output to spill ONE row per sub-tech. Single-tech literals keep that literal as the row label.
**Bucket format**: YYYY-MM for monthly, YYYY-MM-DD for daily, YYYY-MM-DD HH:MM for hourly, YYYY-Qn for quarterly, YYYY-Hn for semiannual, YYYY for annual, literal 'TOTAL' for agg=7.

Related functions

ED.OMIE.BIDS ED.CURTAIL.ECON ED.PCT.AT.PRICE

All functions Docs home