Functions

25 Excel custom functions, grouped by what they expose. Click any function for the full reference page.

Prices

Wholesale day-ahead spot prices.

ED.OMIE

Day-ahead spot price (EUR/MWh) for a single timestamp.

ED.OMIE.RANGE

Spot price time series with temporal aggregation. Auto-formatted spill array.

Generation

Power generation by technology and per production unit.

ED.GEN

Power generation by technology (MW) — single value.

ED.GEN.RANGE

Generation time series by technology — average power (MW) or total energy (MWh).

ED.UNIT

Generation per Spanish production unit — average power (MW) or total energy (MWh).

ED.UNIT.RANGE

Generation time series for one production unit — average power (MW) or total energy (MWh).

ED.PROGRAM

ESIOS scheduling programs (PBF/PVP/PHFC/P48) by tech — mix matrix or single series.

Capture price

Production-weighted average price per technology.

ED.CAPTURE

Production-weighted average price (EUR/MWh) or capture rate (%).

ED.CAPTURE.RANGE

Capture price (EUR/MWh) or capture rate (%) time series by technology.

ED.CURTAIL.RANGE

Renewable curtailment — economic (forecast vs PBF) or technical (PBF vs P48).

Battery (BESS)

Optimal battery spread between cheap and expensive hours.

ED.BESS

Optimal battery spread for a day (EUR/MWh per cycle).

ED.BESS.RANGE

Battery spread time series — backtest BESS economics over time.

Installed capacity

Capacity stock (MW) by tech and region.

ED.CAPACITY

Installed generation capacity (MW) by technology and region.

ED.CAPACITY.RANGE

Installed capacity time series (MW) — monthly snapshots.

Registry

Production-unit and owner directory (REE + ENTSO-E).

ED.UPS

List ENTSO-E production units (~300) with code, name, tech, owner.

ED.UP.SEARCH

Full Spanish UP registry search (8000+ market participants).

ED.OWNERS

Spanish market players ranked by number of UPs they own.

Settlement

OMIE wholesale settlement and government PPA auction awards.

ED.REER.AWARDS

Project-by-project results of the four 2021-2022 REER auctions.

ED.OMIE.SEGMENTS

Monthly OMIE wholesale settlement by market segment (MWh + €).

Grid access

REE grid-access capacity (PDF history + portal snapshot).

ED.GRIDACCESS

REE grid-access capacity (GW) — monthly historical, since Aug 2019.

ED.GRIDACCESS.PORTAL

REE grid-access interactive portal snapshot — 8 techs, RdT/RdD split.

Generic + metrics

Single-value, range, and the metric catalog.

ED.GET

Generic single-value access for any of 120+ metrics.

ED.RANGE

Generic time-series access for any of 120+ metrics — average value or total energy.

ED.PCT.AT.PRICE

Share of a volume metric whose hours fall on one side of a price threshold.

ED.METRICS

List every metric exposed by the API with its unit and description.

Need a metric that doesn't map to a dedicated function? Use ED.GET with any of the 120+ catalog metrics.