ED.UP.SEARCH
Full Spanish UP registry search (8000+ market participants).
Signature
ED.UP.SEARCH([q], [zone], [type])Description
Search the full Spanish UP (Unidad de Programación) registry — every market participant registered with REE, refreshed daily from the OMIE C2 ZIP. ~8000 entries including small renewables, retailers, consumers, and the large generators that also appear in ED.UPS.
This is a directory only — there is no per-unit MW time-series for these UPs (only the ~300 in ED.UPS have that). Use this function to identify the company behind a UP code, find every unit owned by a given player, or filter by zone (mainland vs island systems).
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| q | string | — | Fuzzy match on code, name or company (case-insensitive). |
| zone | string | — | Bidding zone — see table below. |
| type | "seller" / "V" | "buyer" / "C" | — | Filter by participant role. Omit for both. |
Valid values for zone
| Code | Description |
|---|---|
| PENINSULA | Mainland (continental Spain) bidding zone. |
| BALEARES | Balearic Islands system. |
| GCANARIA | Gran Canaria. |
| TENERIFE | Tenerife. |
| LZ_FV | Lanzarote-Fuerteventura. |
| LA_PALMA | La Palma. |
| EL_HIERRO | El Hierro. |
| LA_GOMERA | La Gomera. |
| CEUTA | Ceuta. |
| MELILLA | Melilla. |
Valid values for type
| Code | English alias | Description |
|---|---|---|
| V | seller, generator | Vendedor — seller injecting energy into the grid. |
| C | buyer, retailer | Comprador — retailer or consumer purchasing energy. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Returns
Spill array with header: Code, Type, Name, Company, Zone, BRP.
Examples
=ED.UP.SEARCH("iberdrola")— All Iberdrola UPs=ED.UP.SEARCH("solar", "PENINSULA", "seller")— Mainland sellers matching "solar" (English alias)=ED.UP.SEARCH("solar", "PENINSULA", "V")— Same in Spanish-acronym form — equivalent=ED.UP.SEARCH(, "BALEARES")— All UPs in BalearesNotes
- Type "V" (vendedor) = seller injecting into the grid. Type "C" (comprador) = retailer or consumer.
- BRP = Balance Responsible Party (the entity responsible for imbalance settlement of that UP).