ED.REER.AWARDS
Project-by-project results of the four 2021-2022 REER auctions.
Signature
ED.REER.AWARDS([auction], [tech], [company])Description
List individual awards from the four Spanish REER (Régimen Económico de Energías Renovables) auctions held under RD 960/2020 in 2021-2022. Each row is one Unidad de Adjudicación (UA) — a single project can have several UAs. Source: BOE resolutions (BOE-A-2021-1251, BOE-A-2021-17335, BOE-A-2022-17796, BOE-A-2022-20540).
The REER mechanism is a CfD-style PPA between the project and the government: the awarded MWh are paid the strike price set in the auction, with a make-whole if market prices are lower (and a clawback if higher). See /docs/concepts section 8 for the full RRE vs REER comparison.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| auction | string | — | Auction identifier — see table below. Omit for all. |
| tech | string | — | Technology — see table below. Case-insensitive. |
| company | string | — | Fuzzy match on company name (e.g. "iberdrola"). |
Valid values for auction
| Code | Description |
|---|---|
| 2021-01 | First REER auction (January 2021) — RD-Ley 23/2020 + Orden TED/1161/2020. |
| 2021-10 | Second auction (October 2021). |
| 2022-10 | Third auction (October 2022). |
| 2022-11 | Fourth auction (November 2022) — innovative technologies only. |
Valid values for tech
| Code | English alias | Description |
|---|---|---|
| eolica | wind | Onshore wind. |
| fotovoltaica | solar_pv | Solar photovoltaic. |
| termosolar | solar_thermal | Concentrated solar thermal. |
| biomasa | biomass | Biomass, biogas, and agricultural/forestry residues. |
| eolica_marina | offshore_wind | Offshore wind — auction 4 only. |
The add-in accepts either the canonical Spanish code or the English alias — both are equivalent.
Returns
Spill array with header: Auction, UA Code, Company, CIF, Technology, Subgrupo, Strike €/MWh, MW, BOE.
Examples
=ED.REER.AWARDS()— All 219 awards across four auctions=ED.REER.AWARDS("2021-01")— Just the first auction (Jan 2021)=ED.REER.AWARDS(,"solar_pv")— All PV awards (English alias)=ED.REER.AWARDS(,"fotovoltaica")— Same in Spanish — equivalent=ED.REER.AWARDS(,,"iberdrola")— All Iberdrola awardsNotes
- REER (post-2020 auction-based PPA, RD 960/2020) is distinct from RRE (pre-2020 régimen retributivo específico, RD 413/2014). The two acronyms are easy to confuse — see /docs/concepts section 8.
- Many awarded projects have since been renounced or are stalled at grid-access stage.