Beta — Data under validation. Values may contain errors.

ED.CAPTURE

Production-weighted average price (EUR/MWh) or capture ratio (%).

Capture price

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

NameTypeDefaultDescription
tech1-6 | string1 (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.
datedate—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).
method0 | 10 (realized)0=realized (matches published figures), 1=PBF (ex-ante schedule, ES only).
tz0 | 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

CodeEnglish aliasDescription
1solar_pv, solar, pvSolar 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).
2wind, eolicaOnshore wind.
3nuclearNuclear.
4hydro, hidraulicaReservoir + run-of-river hydro.
5combined_cycle, ccgt, gasCombined-cycle gas (CCGT).
6coal, carbonCoal-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 unit parameter was inserted between zone and method. Calls that passed method or tz positionally need an empty slot for unit. 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 passed tech/date/zone are 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 whatever method; the baseload field 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 tz is a no-op (capture is always Madrid-civil by construction).

Related functions