ED.CAPTURE
Production-weighted average price (EUR/MWh) — capture price.
Signature
ED.CAPTURE([tech], [date], [zone], [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.
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. Omit for the latest. |
| zone | "ES" | "PT" | "ES" | MIBEL zone. |
| method | 0 | 1 | 0 (realized) | 0=realized (matches published figures), 1=PBF (ex-ante schedule, ES only). |
| tz | 0 | 1 | 2 | "madrid" | Timezone interpretation. |
Valid values for tech
| Code | English alias | Description |
|---|---|---|
| 1 | solar_pv, solar, pv | Solar PV (uses gen_solar_pv as production weight). |
| 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 — price in EUR/MWh.
Examples
=ED.CAPTURE(1, "2025-07-01")— Solar capture, realized=ED.CAPTURE(2, "2025-07-01", , 1)— Wind capture, PBF ex-ante=ED.CAPTURE("nuclear", "2025-07-01")— Nuclear capture (named tech)Notes
- 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.