ED.CAPACITY.RANGE
Installed capacity time series (MW) — monthly snapshots.
Signature
ED.CAPACITY.RANGE(tech, [start], [end], [region], [headers], [noDate], [agg], [mode])Description
Time series of installed capacity (MW) for a technology. Capacity is a stock variable, not a flow — that has two consequences:
1. Native granularity is monthly: REE publishes one snapshot per month-end. Sub-monthly aggregations are rejected.
2. There are two ways to collapse a multi-month bucket. mode=1 (default, end-of-period snapshot) reports the value at the last month of the bucket — the industry standard used by IEA / ENTSO-E / REE annual reports. mode=2 (period average) takes the simple mean of monthly values across the bucket.
Pass region="all" to get a wide matrix with one column per CCAA — useful for charts and regional comparisons. Otherwise omit region for the national total or pass a single CCAA name.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| tech* | string | — | Technology code. See valid values below. |
| start | YYYY-MM | — | Start month. Omit for 2 years before today. |
| end | YYYY-MM | — | End month. Omit for the latest. |
| region | string | "all" | — | CCAA name (e.g. "Andalucía") or "all" for a wide matrix. Omit for the national total. |
| headers | 0 | 1 | 0 | Set 1 for header row. |
| noDate | 0 | 1 | 0 | Set 1 to omit the period column. |
| agg | 3 | 4 | 5 | 6 | 3 (monthly) | 3=monthly, 4=quarterly, 5=semiannual, 6=annual. Sub-monthly is invalid. |
| mode | 1 | 2 | 1 (end-of-period) | 1=end-of-period snapshot (industry standard), 2=average across the period. |
* Required.
Valid values for tech
| Code | Description |
|---|---|
| solar_pv | Solar photovoltaic |
| wind | Onshore wind |
| nuclear | Nuclear |
| hydro | Hydro (reservoir + run-of-river) |
| pumped_hydro | Pumped storage (reversible hydro) |
| ccgt | Combined-cycle gas (CCGT) |
| coal | Coal |
| diesel | Diesel engines (non-mainland island systems) |
| gas_turbine | Open-cycle gas turbine |
| steam_turbine | Conventional steam turbine |
| solar_thermal | Concentrated solar thermal |
| cogeneration | Cogeneration |
| other_renewable | Other renewables (biomass, biogas, geothermal…) |
| waste_renewable | Renewable waste (organic fraction) |
| waste_non_renewable | Non-renewable waste |
Returns
Spill array — [period, MW] rows. With region="all", a wide matrix [period, CCAA1, CCAA2, ...].
Examples
=ED.CAPACITY.RANGE("solar_pv")— Default: national monthly series for the last 2 years=ED.CAPACITY.RANGE("solar_pv", "2018-01", "2025-12", , , , 6)— Annual end-of-year (industry standard)=ED.CAPACITY.RANGE("solar_pv", "2018-01", "2025-12", , , , 6, 2)— Annual average across the year=ED.CAPACITY.RANGE("wind", "2024-01", "2026-04", "all", 1)— All-CCAA matrix with headersNotes
- Capacity is monthly — sub-monthly aggregations (
agg0-2) are rejected at the API level. - For a single 'capacity at this date' use
ED.CAPACITYinstead — the range function withagg=7would be unusual for a stock variable.