ED.CAPTURE.RANGE
Capture price (EUR/MWh) or capture ratio (%) time series by technology.
Signature
ED.CAPTURE.RANGE([tech], [start], [end], [agg], [unit], [zone], [headers], [noDate], [method], [tz])Description
Capture price time series. Pair with ED.GEN.RANGE (production volumes) and ED.OMIE.RANGE (spot reference) on the same dates and agg to build a complete revenue picture.
Aggregation is controlled by agg: 0=native, 5min/10min/15min, 1=hourly, 2=daily (default), 3=monthly, 4=quarterly, 5=semiannual, 6=annual, 7=total.
With unit="pct" the spill returns a **capture ratio** (%): the capture price ÷ a reference price × 100, where 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. Daily buckets divide by that day's reference; monthly and longer buckets and the total weight the days by generation. It is **not** the capture rate AFRY/Ember/Aurora publish (capture ÷ the period's 24-hour average day-ahead price) and can differ from it by several points: Spanish solar, January–October 2026, 46.7% here against 48.8% with the 24-hour baseload; wind 110.4% against 90.5%. Most of that gap comes from weighting the days by generation, not from the hours: for Spanish wind, nuclear and hydro the reference is in practice the 24-hour mean (they are scheduled every hour), so their gap is almost all weighting; for Spanish solar the weighting accounts for about −3.6 points and the producing hours for about +1.5. For that ratio, divide the EUR/MWh series by ED.DAYAHEAD.RANGE over the same dates, agg and zone.
**Granularity floor:** the underlying capture_daily series is daily by construction — there is no hourly capture price. Aggregations finer than daily (agg=0/RAW, "5min", "15min", "30min", or agg=1/H) are silently promoted to daily rather than rejected.
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. |
| start | date | — | Start. Defaults: omit end for today (Madrid, with a small overnight cutoff), omit start for 30 days before end. |
| end | date | — | End. Omit for today. |
| agg | 2-7 | string | 2 (daily) | Aggregation is controlled by agg: 0=native, 5min/10min/15min, 1=hourly, 2=daily (default), 3=monthly, 4=quarterly, 5=semiannual, 6=annual, 7=total. Sub-daily aggregations (0/RAW, 5min, 15min, 30min, 1/H) are accepted but silently promoted to daily — the metric has no sub-daily resolution. |
| unit | "" | "pct" | "" (EUR/MWh) | Output unit. Default returns capture price in EUR/MWh per bucket. "pct": capture as % of the average day-ahead price of the hours the tech produced; not the 24-h-baseload capture rate (see notes). |
| 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.) |
| headers | 0 | 1 | 0 | Set 1 for header row. |
| noDate | 0 | 1 | 0 | Set 1 to omit the period column. |
| method | 0 | 1 | 0 (realized) | 0=realized, 1=PBF (ES only). |
| tz | 0 | 1 | 2 | "madrid" | Accepted for parity with the other range functions, but **no-op here**: capture_daily is computed once per Madrid civil day, so the period buckets are the same regardless of tz. |
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
Spill array — [period, value] rows. Value is EUR/MWh by default, or % when unit="pct".
Examples
=ED.CAPTURE.RANGE(2, "2025-01-01",, 6)— Wind annual capture price=ED.CAPTURE.RANGE(1, "2025-01-01", "2025-12-31", 3, "pct")— Solar monthly capture ratio (%) — vs the day-ahead average of its producing hours, not the 24-h baseload=ED.CAPTURE.RANGE(1, "2025-01-01", "2025-12-31", 3, , "ES", 1)— Solar monthly EUR/MWh with headers=ED.CAPTURE.RANGE("solar", "2024-01-01",, 3, , , 1, 0, 1)— Solar monthly PBF (ex-ante), EUR/MWh, with headersNotes
- **BREAKING in v8.0.0 (manifest 8.0.0.0)**: the
unitparameter was inserted betweenaggandzone. Calls that passedzone/headers/noDate/method/tzpositionally need an empty slot forunit. Example: v7=ED.CAPTURE.RANGE(1, A1, A2, 3, "ES", 1, 0, 1)(method=PBF) becomes v8=ED.CAPTURE.RANGE(1, A1, A2, 3, , "ES", 1, 0, 1). Calls that only passed the first four args 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). - Daily (and finer) buckets divide by that day's reference; agg 3-7 (monthly to total) weight the days by generation: Σ(capture × gen) / Σ(reference × gen) × 100.
- Granularity floor is daily — sub-daily
aggvalues are promoted, not rejected. If you need hourly EUR/MWh weighted prices, build them yourself viaED.OMIE.RANGE × ED.GEN.RANGEon hourly buckets. tzis a no-op for the same reason: the daily bucket is identical under Madrid / CET / UTC interpretation.