Documentation
EnergyData Iberia Excel Add-in — Function Reference v3.0
Install the Excel Add-in
In Excel: Insert → Get Add-ins → My Add-ins → Upload My Add-in → select the manifest.xml file. All functions use the ED. namespace.
All Metrics Catalog — 70 metrics
Complete list of every metric with description, unit, resolution, data source, and available date range. Grouped by category.
Quick Start
=ED.OMIE()— Latest spot price=ED.OMIE.RANGE("2025-01-01",, 3)— Monthly prices=ED.CAPTURE("2025-07-01", 1)— Solar capture=ED.GET("brent")— Brent crude=ED.METRICS()— List all metricsAggregation Codes
| Code | Meaning | Output |
|---|---|---|
| 0 | 15-minute | 96 rows/day |
| 1 | Hourly | 24 rows/day |
| 2 | Daily (default) | 1 row/day |
| 3 | Monthly | 1 row/month |
| 4 | Quarterly | 1 row/quarter |
| 5 | Semiannual | 1 row/semester |
| 6 | Annual | 1 row/year |
| 7 | Total | Single value |
ED.OMIE
ED.OMIE([date], [hour], [quarter], [zone])
Day-ahead spot price (EUR/MWh). Returns latest 15-min value when called without arguments.
=ED.OMIE()— Latest 15-min price=ED.OMIE("2025-07-01", 14)— Hour 14 average=ED.OMIE("2025-12-01", 14, 2)— Quarter 2 of hour 14=ED.OMIE("2025-07-01", 14, , "PT")— PortugalED.OMIE.RANGE
ED.OMIE.RANGE([start], [end], [agg], [zone], [headers])
Spot price range with temporal aggregation. Returns auto-formatted spill array.
=ED.OMIE.RANGE("2025-07-01", "2025-07-01", 0)— 15-min (96 rows)=ED.OMIE.RANGE("2025-01-01",, 3)— Monthly to today=ED.OMIE.RANGE("2001-01-01",, 6)— Annual since 2001ED.GEN / ED.GEN.RANGE
ED.GEN([date], [hour], [tech]) | ED.GEN.RANGE([start], [end], [agg], [tech], [headers])
Generation by technology. Tech: 1=Solar, 2=Wind, 3=Nuclear, 4=Hydro, 5=Gas, 6=Coal.
=ED.GEN("2025-07-01", 14, 1)— Solar at hour 14=ED.GEN.RANGE("2025-01-01",, 3, 2)— Wind monthlyED.CAPTURE / ED.CAPTURE.RANGE
ED.CAPTURE([date], [tech], [zone]) | ED.CAPTURE.RANGE([start], [end], [agg], [tech], [zone], [headers])
Production-weighted average electricity price for a technology. Generation-weighted aggregation for monthly/annual.
=ED.CAPTURE("2025-07-01", 1)— Solar capture=ED.CAPTURE.RANGE("2025-01-01",, 6, 2)— Wind annualED.GET / ED.RANGE
ED.GET(metric, [date], [hour], [zone]) | ED.RANGE(metric, [start], [end], [agg], [zone], [headers])
Generic access to any of 120+ metrics by name. Use ED.METRICS() to list all available.
=ED.GET("demand_real", "2025-07-01", 14)— Real demand=ED.GET("brent")— Brent crude=ED.GET("futures_yr")— Cal+1 future=ED.RANGE("eua_co2", "2020-01-01",, 3)— CO2 monthlyED.METRICS
ED.METRICS()
Returns a spill array listing all available metrics with their units and descriptions.
=ED.METRICS()— List all 120+ metrics120+ metrics available
Spot prices, generation, capture prices, futures, commodities, balancing, redispatch, and more.
View live data coverage →