ED.GRIDACCESS.PORTAL
REE grid-access interactive portal snapshot — 8 techs, RdT/RdD split.
Signature
ED.GRIDACCESS.PORTAL([group], [scope], [region], [tech], [network])Description
Snapshot of REE's interactive grid-access portal. Wider technology coverage than the PDF feed (8 techs vs 3) and splits transmission (RdT) vs distribution (RdD) networks — but only the latest snapshot is available, no historical depth.
Default returns the latest snapshot for all rows. Capacity is in MW (note: the PDF endpoint returns GW; the portal uses MW). Use this when you need batteries / concentrated solar thermal / hydro / pumped storage coverage; use ED.GRIDACCESS when you need the time series.
The add-in accepts both Spanish canonical values (the database identifiers used by REE) and English aliases — see the value tables below.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| group | "renewable" / "GR" | "conventional" / "GC" | — | Renewable vs conventional generation group. |
| scope | "national" / "nacional" | "regional" / "ccaa" | — | Whether to return the national aggregate or per-region rows. |
| region | string | — | Spanish autonomous community name. |
| tech | string | — | Technology — see table below. |
| network | "transmission" / "RdT" | "distribution" / "RdD" | — | Transmission vs distribution grid. |
Valid values for group
| Code | English alias | Description |
|---|---|---|
| GR | renewable | Renewables (Generación Renovable). |
| GC | conventional | Conventional / non-renewable generation (Generación Convencional). |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Valid values for scope
| Code | English alias | Description |
|---|---|---|
| nacional | national | National aggregate row(s). |
| ccaa | regional | One row per autonomous community. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Valid values for tech
| Code | English alias | Description |
|---|---|---|
| eolica | wind | Onshore wind. |
| solar_fv | solar_pv | Solar photovoltaic. |
| baterias | batteries | Stand-alone battery storage. |
| hibridacion | hybridization | Hybridization (renewable + storage). |
| termosolar | solar_thermal | Concentrated solar thermal. |
| hidraulica | hydro | Hydro. |
| bombeo | pumped_storage | Pumped storage (reversible hydro). |
| otras | other | Other conventional technologies. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Valid values for network
| Code | English alias | Description |
|---|---|---|
| RdT | transmission | Transmission grid (red de transporte). |
| RdD | distribution | Distribution grid (red de distribución). |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Returns
Spill array with header: Date, Grupo, Ambito, CCAA, Tecnologia, Red, Estado, MW. Column values are the Spanish canonical forms.
Examples
=ED.GRIDACCESS.PORTAL()— Latest snapshot, all rows=ED.GRIDACCESS.PORTAL("renewable", "national")— Renewables, national view=ED.GRIDACCESS.PORTAL("renewable", "regional", "Andalucía", "batteries")— Batteries in Andalucía=ED.GRIDACCESS.PORTAL(, , , "hydro", "transmission")— Hydro on transmission grid only=ED.GRIDACCESS.PORTAL("GR", "ccaa", "Andalucía", "baterias")— Same query in Spanish — equivalent