All Metrics
70 metrics across 11 categories. All available via ED.GET() and ED.RANGE().
⚡ Electricity Prices
Day-ahead spot prices, intraday, PVPC regulated tariff
Day-ahead spot price
15-minOMIE Iberian day-ahead electricity market price. Quarter-hourly since June 2025, hourly before.
=ED.OMIE()Continuous intraday (XBID) avg
hourlyWeighted average price from the OMIE continuous intraday market (XBID platform).
=ED.GET("continuous_avg")Continuous intraday max
hourlyMaximum price from the continuous intraday market.
=ED.GET("continuous_max")Continuous intraday min
hourlyMinimum price from the continuous intraday market.
=ED.GET("continuous_min")PVPC regulated tariff
hourlyPrecio Voluntario para el Pequeño Consumidor — regulated electricity price for households.
=ED.GET("pvpc")Final price (all components)
hourlyHourly final electricity price including all market components.
=ED.GET("pvpc_final")Intraday session 1 price
15-minPrice from intraday auction session 1 (ES + PT).
=ED.GET("intraday_s1_price")Intraday session 2 price
15-minPrice from intraday auction session 2.
=ED.GET("intraday_s2_price")Intraday session 3 price
15-minPrice from intraday auction session 3.
=ED.GET("intraday_s3_price")🔋 Generation
Real-time generation by technology from REE/ESIOS
Solar PV generation
hourlyReal-time solar photovoltaic generation in the peninsular system. Uses gen_solar pre-2020, gen_solar_pv post-2020.
=ED.GEN(,, 1)Wind generation
hourlyReal-time wind generation in the peninsular system.
=ED.GEN(,, 2)Nuclear generation
hourlyReal-time nuclear generation (Almaraz, Ascó, Cofrentes, Trillo, Vandellós).
=ED.GEN(,, 3)Hydro generation
hourlyReal-time conventional hydroelectric generation (UGH).
=ED.GEN(,, 4)Gas CCGT generation
hourlyReal-time combined cycle gas turbine generation.
=ED.GEN(,, 5)Coal generation
hourlyReal-time coal thermal generation.
=ED.GEN(,, 6)Solar thermal generation
hourlyConcentrated solar power (CSP/solar thermal) generation.
=ED.GET("gen_solar_thermal")📊 Demand
Electricity demand: real, forecast, and scheduled
Real demand
hourlyActual real-time electricity demand in the peninsular system.
=ED.GET("demand_real")Scheduled demand
hourlyDay-ahead scheduled electricity demand.
=ED.GET("demand_scheduled")Renewable forecast D+1
hourlyDay-ahead forecast of wind + solar generation.
=ED.GET("forecast_renewable_d1")Residual demand forecast
15-minForecast of demand minus renewable generation.
=ED.GET("forecast_residual_demand")🎯 Capture Prices
Production-weighted average electricity price by technology
Solar PV capture price
dailyΣ(price×gen)/Σ(gen) — the average price solar generators actually receive. Generation-weighted.
=ED.CAPTURE(,1)Wind capture price
dailyProduction-weighted average price for wind generators.
=ED.CAPTURE(,2)Nuclear capture price
dailyProduction-weighted average price for nuclear generators.
=ED.CAPTURE(,3)Hydro capture price
dailyProduction-weighted average price for hydro generators.
=ED.CAPTURE(,4)Gas CCGT capture price
dailyProduction-weighted average price for CCGT generators.
=ED.CAPTURE(,5)Coal capture price
dailyProduction-weighted average price for coal generators.
=ED.CAPTURE(,6)⚖️ Balancing Services
Secondary (aFRR), tertiary (mFRR), and imbalance prices
aFRR band price (up)
hourlySecondary regulation band price for upward reserve.
=ED.GET("afrr_band_price_up")aFRR band price (down)
hourlySecondary regulation band price for downward reserve.
=ED.GET("afrr_band_price_down")aFRR energy price (up)
hourlySecondary regulation energy activation price upward.
=ED.GET("afrr_energy_price_up")aFRR energy price (down)
hourlySecondary regulation energy activation price downward.
=ED.GET("afrr_energy_price_down")mFRR-SA price (up)
hourlyTertiary regulation scheduled activation marginal price upward.
=ED.GET("mfrr_sa_price_up")mFRR-DA price (up)
hourlyTertiary regulation direct activation weighted average price upward.
=ED.GET("mfrr_da_price_up")Imbalance price (up)
hourlyImbalance settlement price for upward deviations.
=ED.GET("imbalance_price_up")Imbalance price (down)
hourlyImbalance settlement price for downward deviations.
=ED.GET("imbalance_price_down")🔧 Technical Constraints (Redispatch)
Redispatch Phase I, Phase II, real-time, costs, and curtailment (ERNI)
Redispatch Phase I energy (up)
hourlyEnergy redispatched upward in day-ahead technical constraints resolution.
=ED.GET("redispatch_daily_energy_up")Redispatch Phase I energy (down)
hourlyEnergy redispatched downward in day-ahead.
=ED.GET("redispatch_daily_energy_down")Redispatch Phase I price (up)
hourlyAverage price for upward redispatch in day-ahead.
=ED.GET("redispatch_daily_price_up")Redispatch Phase I total cost
15-minTotal cost of Phase I technical constraints resolution.
=ED.GET("redispatch_daily_cost")Redispatch real-time energy (up)
hourlyReal-time upward redispatch energy.
=ED.GET("redispatch_rt_energy_up")Redispatch real-time total cost
15-minTotal cost of real-time technical constraints.
=ED.GET("redispatch_rt_cost")Renewable curtailment (ERNI)
dailyPercentage of renewable energy not integrated due to technical constraints.
=ED.GET("curtailment_pct")💰 System Cost
Monthly price decomposition: day-ahead + RRTT + balancing
RRTT cost component
monthlyMonthly cost of technical constraints per MWh of demand. Official REE calculation, ~2 month lag.
=ED.GET("rrtt_cost_mwh")Ancillary services component
monthlyMonthly total ancillary services cost (RRTT + balancing) per MWh.
=ED.GET("component_ancillary_monthly")Final price (all components)
monthlyMonthly final electricity price including all market components.
=ED.GET("total_system_cost")📈 Futures & Forward
OMIP SPEL Base Futures: monthly, quarterly, yearly, PPA
Monthly futures (M+1)
dailyFront month OMIP SPEL Base Futures settlement price.
=ED.GET("futures_m")Quarterly futures (Q+1)
dailyFront quarter OMIP SPEL Base Futures settlement price.
=ED.GET("futures_q")Yearly futures (Cal+1)
dailyFront year (calendar year) OMIP SPEL Base Futures settlement price.
=ED.GET("futures_yr")PPA reference (10yr)
dailyOMIP 10-year PPA reference price. Forward curve from Cal+1 to Cal+10.
=ED.GET("futures_ppa")🛢️ Commodities
Oil, gas, and carbon prices from international markets
Brent crude oil
dailyEurope Brent Spot Price FOB. The global benchmark for crude oil pricing.
=ED.GET("brent")WTI crude oil
dailyWest Texas Intermediate Spot Price at Cushing, Oklahoma.
=ED.GET("wti")Henry Hub natural gas
dailyUS Henry Hub natural gas spot price.
=ED.GET("henry_hub")EU ETS carbon (EUA)
dailyEuropean Union Allowance spot price. EU Emissions Trading System.
=ED.GET("eua_co2")EU natural gas (TTF)
monthlyEuropean natural gas price at Title Transfer Facility (Netherlands). World Bank proxy.
=ED.GET("eu_gas_ttf")Dubai crude oil
monthlyDubai/Oman crude oil benchmark price for Asian markets.
=ED.GET("dubai_crude")📋 C2 Settlement (Liquidation)
Definitive settlement values from REE C2 liquidation files. ~40 day delay but official values.
C2 RRTT redispatch price
hourlySettled RRTT PBF (pay-as-bid) redispatch price. Definitive values from C2 liquidation.
=ED.GET("c2_rrtt_price")C2 RRTT total cost
hourlySettled RRTT total cost per hour. Definitive from C2 liquidation.
=ED.GET("c2_rrtt_cost")C2 RRTT energy (up)
15-minSettled upward redispatch energy from RRTT. Quarter-hourly resolution.
=ED.GET("c2_rrtt_energy_up")C2 RRTT energy (down)
15-minSettled downward redispatch energy from RRTT. Negative values = curtailment.
=ED.GET("c2_rrtt_energy_down")C2 RR energy (up)
15-minSettled Replacement Reserve (RR) upward energy. European balancing product.
=ED.GET("c2_rr_energy_up")C2 RR energy (down)
15-minSettled Replacement Reserve (RR) downward energy.
=ED.GET("c2_rr_energy_down")C2 RR price
15-minSettled Replacement Reserve marginal price per quarter-hour.
=ED.GET("c2_rr_price")C2 deviation price (up)
15-minSettled imbalance/deviation price for upward deviations. UNICO/DUAL.
=ED.GET("c2_dev_price_up")C2 deviation price (down)
15-minSettled imbalance/deviation price for downward deviations.
=ED.GET("c2_dev_price_down")C2 net deviation energy
15-minNet system deviation energy per quarter-hour. Definitive settlement value.
=ED.GET("c2_dev_energy_net")🔌 Storage & Interconnections
Batteries, pumped hydro, and cross-border flows
Battery charging
hourlyBattery storage charging power.
=ED.GET("battery_charge")Battery delivery
hourlyBattery storage discharge/delivery power.
=ED.GET("battery_delivery")Pumped hydro consumption
hourlyPumped hydro storage energy consumption.
=ED.GET("pumped_consumption")France interconnection net
hourlyNet electricity exchange with France.
=ED.GET("xborder_france_net")Portugal interconnection net
hourlyNet electricity exchange with Portugal.
=ED.GET("xborder_portugal_net")Morocco interconnection net
hourlyNet electricity exchange with Morocco.
=ED.GET("xborder_morocco_net")All metrics accessible with one formula
Use ED.GET("metric_name") for any single value, or ED.RANGE("metric_name", start, end, agg) for time series.