Daily Balancing Costs 2021-2022

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=8d89e8ee-85d7-4395-813e-a9233b3bdb7c&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "8d89e8ee-85d7-4395-813e-a9233b3bdb7c" LIMIT 5`

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

var data = {
  resource_id: '8d89e8ee-85d7-4395-813e-a9233b3bdb7c', // 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=8d89e8ee-85d7-4395-813e-a9233b3bdb7c&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	22/07/2021
Unit

SETT_PERIOD

Title	Settlement Period
Type	integer
Description	A period of 30 minutes beginning on the hour or the half-hour
Comment	On the first day of BST when clock change happens there will be 46 half hours (SP's) in the day. Similarly the first day of GMT will have 50 half hours as the clock goes back 1 hour at 2am.
Example	15
Unit	Number

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 whether the market was predominantly long or short.
Comment	The Energy Imbalance could be a negative number
Example	5.23
Unit	£m

Frequency Control

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

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	12.2
Unit	£m

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. In order to do this, we sometimes ask a generator to reduce, or constrain, the amount of electricity it’s producing. When we do that, we still need the electricity it would have produced – so we can balance the system – but we can’t move it in or out of a certain area. We make up the difference by buying energy from another generator in a different part of the transmission network. It can also happen the other way around: we might need to produce more energy in some areas, which means we need to reduce production elsewhere.
Comment
Example	15.24
Unit	£m

Negative Reserve

Title	Negative Reserve
Type	number
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	5.6
Unit	£m

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	5.0
Unit	£m

For any queries or feedback please contact [email protected]

You are now signed in

Daily Balancing Costs 2021-2022

CKAN Data API

Data Explorer

Data Explorer

Table Information

SETT_DATE

SETT_PERIOD

Energy Imbalance

Frequency Control

Positive Reserve

Constraints

Negative Reserve

Other