ED.CAPTURE
Production-weighted average price (EUR/MWh) or capture ratio (%).
Signature
ED.CAPTURE([tech], [date], [zone], [unit], [method], [tz])Description
Capture price for a technology and date. The capture price is the production-weighted average wholesale price a technology earned over the period — different from the simple time-weighted average because high-output hours can coincide with low (solar) or high (peakers) prices.
With unit="pct" the function returns a **capture ratio** instead: that day's capture price ÷ a reference price × 100. The reference is the average day-ahead price over the hours in which the technology produced — in Spain the hours with a PBF schedule (solar, wind, nuclear, hydro, gas), for Spanish coal and in France and Germany the hours with metered output — not the 24-hour baseload, whichever method you choose. Below 100% means the technology produced more in the cheaper of those hours. It is therefore **not** the capture rate AFRY/Ember/Aurora publish (capture ÷ the 24-hour average day-ahead price) and can differ from it by several points (see ED.CAPTURE.RANGE). For a single day only the hours matter: Spanish wind, nuclear and hydro are scheduled every hour, so their reference is in practice the 24-hour mean and the day's ratio is in practice the industry one; for gas, and for solar since March 2025 (when its PBF schedule stopped covering all 24 hours), it is not. For that ratio, divide the EUR/MWh capture price by the day-ahead average of the same day (ED.DAYAHEAD.RANGE with that date as start and end and agg=7).
Method 0 (default) = realized: dayahead × metered generation. Matches the figures published by industry reports (Aurora, AleaSoft, REE annual). Method 1 = PBF: dayahead × ex-ante OMIE schedule. Spain only, available before realized data because PBF schedules are published the day-ahead.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| tech | 1-6 | string | 1 (solar_pv) | Tech code or name (see table below). Capture is only computed for the 6 main techs — for solar_thermal use ED.GEN.RANGE × ED.OMIE.RANGE manually. |
| date | date | — | Date. With a date, exactly that day (#N/A if it has no value). Omit for the latest: in EUR/MWh mode the latest day with a realized price (usually yesterday); with unit="pct" the latest day with a ratio (usually today, computed on the PBF schedule until the realized data arrive). |
| zone | "ES" | "FR" | "DE" | "ES" | Realized capture is computed for ES, FR and DE. PBF (method=1) is ES only. (PT is not currently computed.) |
| unit | "" | "pct" | "" (EUR/MWh) | Output unit. Default returns the capture price in EUR/MWh (historical behaviour). "pct": capture as % of the average day-ahead price of the hours the tech produced; not the 24-h-baseload capture rate (see notes). |
| method | 0 | 1 | 0 (realized) | 0=realized (matches published figures), 1=PBF (ex-ante schedule, ES only). |
| tz | 0 | 1 | 2 | "madrid" | Accepted for parity with the other functions, but **no-op here**: the underlying capture_daily series is computed once per Madrid civil day and has no sub-daily resolution to re-bucket. |
Valid values for tech
| Code | English alias | Description |
|---|---|---|
| 1 | solar_pv, solar, pv | Solar PV (uses gen_solar_pv as production weight; from 2025-12-11 that weight includes REE's estimate of PV self-consumption without telemetry, history not restated). |
| 2 | wind, eolica | Onshore wind. |
| 3 | nuclear | Nuclear. |
| 4 | hydro, hidraulica | Reservoir + run-of-river hydro. |
| 5 | combined_cycle, ccgt, gas | Combined-cycle gas (CCGT). |
| 6 | coal, carbon | Coal-fired thermal. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Returns
Number — EUR/MWh by default, or % when unit="pct".
Examples
=ED.CAPTURE(1, "2025-07-01")— Solar capture price (EUR/MWh), realized=ED.CAPTURE(1, "2025-07-01", , "pct")— Solar capture ratio (%): realized capture ÷ day-ahead average of the hours solar produced (not the 24-h baseload)=ED.CAPTURE(2, "2025-07-01", , , 1)— Wind capture price, PBF ex-ante (note empty unit slot)=ED.CAPTURE("nuclear", "2025-07-01")— Nuclear capture price (named tech)Notes
- **BREAKING in v8.0.0 (manifest 8.0.0.0)**: the
unitparameter was inserted betweenzoneandmethod. Calls that passedmethodortzpositionally need an empty slot forunit. Example: v7=ED.CAPTURE(1, "2025-07-01", "ES", 1)(method=PBF) becomes v8=ED.CAPTURE(1, "2025-07-01", "ES", , 1). Calls that only passedtech/date/zoneare unaffected. - Capture ratio:
unit="pct"returns capture ÷ reference × 100, where the reference is the average day-ahead price over the hours the technology produced (ES: hours with a PBF schedule; FR, DE and ES coal: hours with metered output), not the 24-hour baseload; it is not the industry capture rate (capture ÷ 24-hour baseload). The reference is the same column whatevermethod; thebaseloadfield of the capture API is this reference, not a 24-hour baseload. - PBF (method=1) is available the day before realized — useful for forward-looking analysis. Spain only.
- Capture price = SUM(price × MWh) / SUM(MWh) over the chosen period.
- Native granularity is daily — there's no hourly capture price to expose, so
tzis a no-op (capture is always Madrid-civil by construction).