Methodology & Data Sources

Documentation of data sources, calculations, and methodology used in this dashboard

Data Sources

Live API Data (Free, No Auth Required)

Elexon Insights API

Primary source for GB electricity balancing market data

System prices (SBP/SSP)BOA acceptancesBSAD/DISBSADGeneration outturnDemand data

Refresh: 5 minutes

Carbon Intensity API

National Grid ESO carbon intensity and generation mix

Real-time carbon intensity (gCO2/kWh)Generation mix by fuel type48-hour forecastsRegional breakdown

Refresh: 30 minutes

National Grid ESO Data Portal

System operator data via CKAN API

Wind/solar forecastsDemand forecastsInterconnector flowsSystem frequency

Refresh: 30 minutes

Periodic Data (Manual Updates)

Ofgem Price Cap

Quarterly price cap announcements

Annual bill levelsUnit rates (p/kWh)Standing chargesRegional variations

Refresh: Quarterly

MCS Installation Database

Microgeneration Certification Scheme statistics

Domestic solar PV installationsBattery storage deploymentsHeat pump installationsCapacity and cost data

Refresh: Quarterly

REPD (Renewable Energy Planning Database)

Large-scale renewable projects (>150kW)

Planning applicationsProject statusCapacity by technologyDeveloper information

Refresh: Quarterly

Placeholder Data (Requires Integration/License)

Nord Pool / EPEX SPOTPlaceholder

Day-ahead and intraday market prices

Auction clearing pricesTraded volumesCross-border flows

Refresh: Daily

Ancillary Services AuctionsPlaceholder

Frequency response and reserve procurement

DC/DM/DR auction resultsReserve pricesProcured volumes

Refresh: Daily

DNO Flexibility PlatformsPlaceholder

Distribution network constraint management

Flexibility tendersCleared pricesContract volumes

Refresh: Varies

Calculation Methodology

Capture Rate Calculation

Capture Rate = (Weighted Average Price / Baseload Price) × 100%
  • Weighted Average Price = Σ(generation × price) / Σ(generation)
  • Baseload Price = Simple average of all half-hourly day-ahead prices
  • Calculation performed per settlement period (30-minute intervals)
  • Aggregated to monthly/seasonal views

A capture rate below 100% indicates price cannibalization - renewable generators receive less than the average market price due to their output correlation with low-price periods.

Asset Classification (FoM/BtM)

Classification based on BMU ID patterns
  • T_ prefix: Transmission-connected (Front of Meter)
  • E_ prefix: Embedded/Distribution-connected (Behind the Meter)
  • I_ prefix: Interconnectors
  • Additional pattern matching for asset types (BESS, WIND, CCGT, etc.)

Classification is heuristic-based and may not be 100% accurate for all BMUs. Known major assets have explicit mappings.

Bill Forecast Methodology

Annual Bill = (Electricity kWh × Unit Rate) + (Gas kWh × Unit Rate) + Standing Charges
  • Typical household usage: 2,700 kWh electricity, 11,500 kWh gas (Ofgem standard)
  • Price cap based on Ofgem quarterly announcements
  • Forecasts derived from wholesale futures curves
  • Regional variation based on DNO network charges

Bill breakdown percentages based on Ofgem published methodology: ~42% wholesale, ~23% network, ~10% policy costs, ~5% VAT, ~5% supplier margin.

BtM Installation Statistics

Cumulative totals from quarterly MCS data
  • Solar PV: MCS-certified domestic installations since 2010
  • Battery Storage: MCS-certified installations (April 2024+)
  • Heat Pumps: Air and ground source combined
  • Capacity calculated from installation count × average system size

MCS data covers certified installations only. Actual market deployment may be 10-20% higher due to non-certified installations.

Data Quality & Limitations

Important Caveats

  • Real-time data may have 5-15 minute delays from source APIs
  • Historical data quality depends on original source accuracy
  • Interconnector flows shown are illustrative where live data unavailable
  • Capture rate calculations use simplified methodology
  • Bill forecasts are indicative only - actual bills vary by tariff and usage

Data Refresh Rates

  • System prices & BOAs: Every 5 minutes
  • Generation mix & carbon intensity: Every 30 minutes
  • Price cap & MCS data: Updated quarterly when published
  • Manual refresh available via dashboard button
Dashboard Version 1.0.0Last methodology update: January 2026