Beta — Data under validation. Values may contain errors.
Back to docs

Functions

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

Prices

Wholesale day-ahead spot prices.

ED.DAYAHEAD

Day-ahead spot price (EUR/MWh) for a single timestamp, any supported European zone.

ED.DAYAHEAD.RANGE

Day-ahead spot price time series, any supported European zone, with temporal aggregation.

ED.OMIE

Deprecated alias of ED.DAYAHEAD. Same signature, multi-zone.

ED.OMIE.RANGE

Deprecated alias of ED.DAYAHEAD.RANGE. Same signature, multi-zone.

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).

ED.CURTAIL.ECON

Strict OMIE-based economic curtailment for must-run renewables (solar/wind/vre).

ED.OMIE.BIDS

Raw OMIE day-ahead bidding behavior by technology — offered + cleared volumes, prices, clearing rate, marginal. Companion to ED.CURTAIL.ECON, no curtailment claim.

ED.OFFER.STRATEGY

OMIE day-ahead offer strategy by tech — splits offered volume into 4 price tiers (negative, zero, positive real, safety-bid). Companion to ED.OMIE.BIDS focused on bidding behavior rather than volumes.

ED.OFFER.CURVE

OMIE day-ahead offer curve histogram by tech — 8 price bins of offered volume. Finer-grained companion to ED.OFFER.STRATEGY (which collapses everything into 4 tiers).

ED.OFFER.HEATMAP

OMIE day-ahead 24h × 12m heatmap of the bid price (or volume) a single tech offered over one year. Companion to ED.OFFER.STRATEGY (4-tier) and ED.OFFER.CURVE (8-bin histogram) — same dataset, different lens (intraday × seasonal).

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.