Beta — Data under validation. Values may contain errors.

Documentation

EnergyData Iberia Excel Add-in — 22 custom functions, 253+ metrics.

Live Data

Install the add-in

Excel Web, Desktop (Win + Mac).

Concepts

Zones, timezone, agg codes, capture methods, DST.

Function reference

22 functions, full per-function pages.

Metrics catalog

253 metrics with unit, source, range.

Changelog

Add-in version history & breaking changes.

Quick start

=ED.OMIE()— Latest spot price
=ED.OMIE.RANGE("2025-01-01",, 3)— Monthly prices
=ED.CAPTURE(1, "2025-07-01")— Solar capture
=ED.GET("brent")— Brent crude
=ED.METRICS()— List every metric

Zones

Pass the zone argument to switch markets. Default "ES" when not provided. Coverage varies — check the metrics catalog for each metric × zone availability.

ES
España
PT
Portugal
FR
France
DE
Germany
BE
Belgium
NL
Netherlands

Aggregation codes

CodeMeaningOutput
0 / "5min" / "10min" / "15min"Native / sub-hourly5–96 rows/day depending on metric
1Hourly24 rows/day (25 on fall-DST day)
2Daily (default)1 row/day
3Monthly1 row/month
4Quarterly1 row/quarter
5Semiannual1 row/semester
6Annual1 row/year
7TotalSingle value over the whole period

⚡ MW power vs MWh energy

Generation, demand, balancing-band capacity and cross-border flows are stored in MW — instantaneous power. When you aggregate (e.g. agg=6 for annual) the API returns the average MW over the bucket, not the total energy delivered.

In numbers: =ED.GEN.RANGE(1, "2025-01-01", "2025-12-31", 6) may return ~3,500— that's the average power, not 3.5 GWh. The total energy is roughly 3,500 × 8,760 ≈ 30.7 TWh.

Pass unit="MWh"to convert. The conversion uses each metric's native sample interval (5 min for ESIOS Spain gen/demand, 15 min for balancing, 60 min for ENTSO-E zones), so the result is exact down to the sample:

=ED.GEN.RANGE(1, "2025-01-01", "2025-12-31", 6)— Solar PV avg power (MW)
=ED.GEN.RANGE(1, "2025-01-01", "2025-12-31", 6, , , , "MWh")— Solar PV total energy (MWh)
=ED.RANGE("demand_real", "2025-01-01",, 6, , , , , , "MWh")— Annual demand in MWh
=ED.RANGE("gen_total", "2025-01-01", "2025-12-31", 6, , , , , , "MWh")— Annual generation 2025 (all techs, MWh)
=ED.RANGE("gen_renewable", "2025-01-01", "2025-12-31", 6, , , , , , "MWh")— Annual renewable generation (MWh)

Available on ED.GEN.RANGE and ED.RANGE since v7.1.10. Virtual aggregates (gen_total, gen_renewable, gen_thermal, gen_fossil) sum the per-tech series at each native timestamp — same MW/MWh logic. Calling unit="MWh" on a price metric (EUR/MWh) or already-MWh metric returns a 400 error.

Shared parameters

These show up across multiple functions with consistent semantics.

tz0/"madrid" (default) | 1/"cet" | 2/"utc"

How to interpret the date/hour/minute argument and how to bucket range output. Madrid is DST-aware (24-25 hour days). CET is fixed UTC+1, no DST → 8760 hourly buckets/year. UTC is fixed offset 0.

noDate0 (default, include) | 1 (omit)

On *.RANGE functions: whether to include the date/period column in the spill array. Useful when you already have your own time index.

method0/"real" (default) | 1/"pbf"

ED.CAPTURE only. realized = dayahead × metered generation (matches what publications report). PBF = dayahead × ex-ante OMIE schedule (Spain only, available before realized data).

Functions

Click a function for the full reference. Or browse all on a single 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 (MW) — single value.

ED.UNIT.RANGE

Generation time series for one production unit (MW).

Capture price

Production-weighted average price per technology.
ED.CAPTURE

Production-weighted average price (EUR/MWh) — capture price.

ED.CAPTURE.RANGE

Capture price time series by technology (EUR/MWh).

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

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

253+ metrics available

Spot prices, generation, capture prices, futures, commodities, balancing, redispatch, and more.

View live data coverage →