Daily Balancing Volume 2022-2023

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=0cb9b169-a14a-4d1f-b08a-273b21519465&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "0cb9b169-a14a-4d1f-b08a-273b21519465" LIMIT 5`

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

var data = {
  resource_id: '0cb9b169-a14a-4d1f-b08a-273b21519465', // 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=0cb9b169-a14a-4d1f-b08a-273b21519465&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	20/07/2022
Unit

SETT_PERIOD

Title	Settlement Period
Type	number
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	12
Unit

Energy Imbalance (MWh)

Title	Energy Imbalance (MWh)
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
Example	-168.125
Unit	MWh

Frequency Control Offers (MWh)

Title	Frequency Control (MWh)
Type	number
Description	Frequency response offers are predominantly required overnight when generation is running closer to its SEL, and offers are required to lift a unit’s position to enable them to provide high frequency response (reducing output)
Comment
Example	6.519
Unit	MWh

Frequency Control Bids (MWh)

Title	Frequency Control Bids (MWh)
Type	number
Description	The required Frequency Response Bid volume is dependent on the relative market synchronised position of the generation based on its upper and lower output limits.
Comment
Example	-135.75
Unit	MWh

Positive Reserve (MWh)

Title	Positive Reserve (MWh)
Type	number
Description	The Operating Reserve volume uses the half hourly reserve requirement and market length less market synchronised headroom to define the volume of reserve required per half hour. When there is enough market synchronised headroom or the market is sufficiently long, there will be no reserve requirement and therefore there should be no procured reserve volume.
Comment
Example	110
Unit	MWh

Constraint Offers (MWh)

Title	Constraint Offers (MWh)
Type	number
Description	Submitted offers on a unit to increase its output.
Comment
Example	97.5
Unit	MWh

Constraint Bids (MWh)

Title	Constraint Bids (MWh)
Type	number
Description	Submitted bids on a unit to reduce its output.
Comment
Example	-605
Unit	MWh

Negative Reserve (MWh)

Title	Negative Reserve (MWh)
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	-3.15
Unit	MWh

Other (MWh)

Title	Other (MWh)
Type	number
Description	BM actions, which are not easily accounted for in the previously reported categories.
Comment
Example	225.36
Unit	MWh

For any queries or feedback please contact [email protected]

You are now signed in

Daily Balancing Volume 2022-2023

CKAN Data API

Data Explorer

Data Explorer

Table Information

SETT_DATE

SETT_PERIOD

Energy Imbalance (MWh)

Frequency Control Offers (MWh)

Frequency Control Bids (MWh)

Positive Reserve (MWh)

Constraint Offers (MWh)

Constraint Bids (MWh)

Negative Reserve (MWh)

Other (MWh)