Daily Balancing Costs 2024-2025

On a settlement period basis, the total balancing cost (per MWh) is given, alongside the total volume of services provided and an average cost for the settlement period.

CKAN Data API

Access resource data via a web API with powerful query support.
Further information in the main CKAN Data API and DataStore documentation.

The Data API can be accessed via the following actions of the CKAN action API.

Query
`https://api.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=527a5f40-942b-416b-99df-81a51c30d041&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "527a5f40-942b-416b-99df-81a51c30d041" LIMIT 5`

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
  resource_id: '527a5f40-942b-416b-99df-81a51c30d041', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.nationalgrideso.com/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function(data) {
    alert('Total results found: ' + data.result.total)
  }
});

A simple ajax (JSONP) request to the data API using jQuery.

import urllib2
  url = 'https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=527a5f40-942b-416b-99df-81a51c30d041&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

SETT_DATE

Title	Settlement Date
Type	date
Description	The Payment Date in relation to an Initial Settlement Run.
Comment
Example	13/04/2023
Unit

SETT_PERIOD

Title	Settlement Period
Type	integer
Description	A period of 30 minutes beginning on the hour or the half-hour
Comment
Example	15
Unit

Energy Imbalance

Title	Energy Imbalance
Type	number
Description	Energy imbalance is the difference between the amount of energy generated in real time, the amount of energy consumed during that same time, and the amount of energy sold ahead of the generation time for that specific time period. The monthly energy imbalance cost can be negative or positive depending on whether the market was predominantly long or short.
Comment
Example	151358.6
Unit	£

Frequency Control

Title	Frequency Control
Type	number
Description	Response and Fast reserve
Comment
Example	36987.2
Unit	£

Positive Reserve

Title	Positive Reserve
Type	number
Description	Positive Reserve is required to operate the transmission system securely and provides the reserve energy required to meet the demand when there are shortfalls, due to demand forecast changes or generation breakdowns.
Comment
Example	4562.3
Unit	£

Constraints

Title	Constraints
Type	number
Description	Running the transmission network also requires actions to protect equipment, enable access to the system, keep within the Security and Quality of Supply Standard (SQSS) and prevent the loss of large parts of the network.
Comment
Example	112659.5
Unit	£

Negative Reserve

Title	Negative Reserve
Type	number
Description	Description A Negative Reserve service can provide the flexibility to reduce generation or increase demand to ensure supply and demand are balanced. The service is held in reserve to cover unforeseen fluctuations in demand, or generation from demand side PV and wind.
Comment
Example	5225.3
Unit	£

Other

Title	Other
Type	number
Description	BM actions, which are not easily accounted for in the previously reported categories. Other general costs; trading option fees, bank charges, sterling adjustments. Non-Delivery and Reconciliation
Comment
Example	1263.6
Unit	£

For any queries or feedback please contact [email protected]

You are now signed in

Daily Balancing Costs 2024-2025

CKAN Data API

Data Explorer

Data Explorer

Table Information

SETT_DATE

SETT_PERIOD

Energy Imbalance

Frequency Control

Positive Reserve

Constraints

Negative Reserve

Other