ED.GET
Generic single-value access for any of 120+ metrics.
Signature
ED.GET(metric, [date], [hour], [minute], [zone], [tz])Description
Generic accessor for any metric in the catalog. Returns one value at a single timestamp. Use ED.METRICS() to list every available metric with its unit and description.
Covers everything beyond the dedicated functions: real demand, PVPC retail tariff, balancing prices (aFRR, mFRR, RR), redispatch, curtailment, cross-border flows, gas markers (TTF, MIBGAS), CO2 (EUA), commodities (Brent, JKM, ARA), futures (Cal+1, M+1), and more.
Generation and demand metrics are available at native 5-min granularity — pass minute for an exact 5-min slot, omit for the hourly average.
Parameters
| Name | Type | Default | Description |
|---|---|---|---|
| metric* | string | — | Metric name (e.g. "demand_real", "pvpc", "afrr_band_price_up", "brent"). |
| date | date | — | Date. Omit for the latest. |
| hour | 0-23 | — | Hour. Omit for the latest. |
| minute | 0,5,10...55 | — | 5-min slot. Omit for the hourly average. |
| zone | "ES" | "PT" | "ES" | Zone. Most non-electricity metrics ignore this argument (commodities are global). |
| tz | 0 | 1 | 2 | "madrid" | Timezone interpretation. |
* Required.
Returns
Number — value with auto-formatting based on the metric's unit.
Examples
=ED.GET("demand_real", "2025-07-01", 14)— Real demand at hour 14=ED.GET("pvpc")— Latest PVPC tariff value=ED.GET("brent")— Brent crude (USD/bbl)=ED.GET("eua_co2")— EUA CO2 (EUR/t)=ED.GET("futures_yr")— Cal+1 electricity future=ED.GET("gen_total")— Latest total generation (MW) — virtual aggregate, T.Real real-time=ED.GET("gen_renewable", "2025-07-01", 14)— Renewable generation at hour 14=ED.GET("gen_total_measured", "2025-07-01", 14)— Official REE-measured total at hour 14 (settled, ~2-3 day lag, MWh)Notes
- Virtual generation aggregates available:
gen_total(all techs minus exchanges),gen_renewable(solar+wind+hydro+biomass+geothermal+other_renewable),gen_thermal(nuclear+ccgt+coal+oil+cogeneration+fuel_gas),gen_fossil(ccgt+coal+oil+cogeneration+fuel_gas — no nuclear). All return MW; for energy useED.RANGE(metric, …, "MWh"). - **T.Real vs Medida**:
gen_totalis computed from real-time per-tech indicators (T.Real series) — fastest, but provisional.gen_total_measured(ESIOS id 10043) is the post-settlement official figure REE prints in its reports — settled, ~2-3 day lag. The two typically differ by 1-2%; use the measured one for analysis that needs to match REE's published numbers.