ED.OWNERS
Spanish market players ranked by number of UPs they own.
Signature
ED.OWNERS([type], [minUps])Description
Aggregate of the UP registry by company. Useful for sizing market participants — e.g. "Iberdrola represents 142 UPs (138 sellers, 4 buyers) across PENINSULA and BALEARES".
Derived from the same daily C2 ZIP feed as ED.UP.SEARCH. minUps filters out one-off entries (a company with only 1 UP is often a single rooftop installation).
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| type | "seller" / "V" | "buyer" / "C" | — | Filter by participant role. Omit for both. |
| minUps | number | 1 | Minimum UPs per owner to include in the result. Useful to filter long-tail noise. |
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: Company, Total UPs, Sellers, Buyers, Zones.
Examples
=ED.OWNERS()— All owners (8000+ rows)=ED.OWNERS("seller")— Generation companies only (English alias)=ED.OWNERS("V")— Same in Spanish — equivalent=ED.OWNERS(, 5)— Owners with 5+ UPs (filters noise)