Balancing Reserve Day ahead auction requirements forecast

This data file contains the detailed day ahead forecast of Balancing reserve requirements. The file is updated daily ahead of the Balancing reserve auction with the final requirements forecast. Requirements, in MW, for Positive and Negative balancing reserve are given for all 48 service windows available in the current day ahead auction.

This data file only contains the current auction requirements, it will be appended to the history file and overwritten with the next auction requirement on a daily basis.

For forward requirements please look at the Balancing Reserve Medium Term requirements data file.

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=019f6fba-4f17-4056-9ef8-31df44ff2e30&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "019f6fba-4f17-4056-9ef8-31df44ff2e30" LIMIT 5`

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

var data = {
  resource_id: '019f6fba-4f17-4056-9ef8-31df44ff2e30', // 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=019f6fba-4f17-4056-9ef8-31df44ff2e30&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Auction Date

Title	Auction Date
Type	date
Description	The date of the auction event that these requirements apply to
Comment
Example	2024-01-24
Unit

Service Delivery Date

Title	Service Delivery Date
Type	date
Description	The service day for delivery of the service.
Comment	Please Note that service window 1 starts at 23:00 D-1 with regards to service date
Example	2024-01-25
Unit

Service Window

Title	Service Window
Type	string
Description	Service window identifier
Comment	Please note this is not the same as Settlement Period. The first service window, window 1 starts on 23:00 Service date-1. For GMT to BST clock change service window 7x and 8x are the repeated hour. For BST to GMT clock change day there is no service window 5 or 6
Example	7x
Unit

Service window start time

Title	Service window start time
Type	datetime
Description	Start time and date of service window
Comment	Time given in local time
Example	2024-01-24T23:00:00
Unit

Service Window End Time

Title	Service Window End Time
Type	datetime
Description	End time and date of service window
Comment	Time given in local time
Example	2024-01-24T23:29:59
Unit

Positive Balancing Reserve Requirement MW

Title	Positive Balancing Reserve Requirement MW
Type	integer
Description	Requirement for Positive Balancing reserve
Comment
Example	651
Unit	MW

Negative Balancing Reserve Requirement MW

Title	Negative Balancing Reserve Requirement MW
Type	integer
Description	Requirement for Negative Balancing reserve
Comment
Example	751
Unit	MW

Forecast produced on

Title	Forecast produced on
Type	date
Description	Date that the forecast was produce
Comment	NA
Example	2024-01-24
Unit	NA

Forecast type

Title	Forecast type
Type	string
Description	Type of forecast
Comment	Either day ahead forecast or Medium term
Example	Day ahead
Unit

For any queries or feedback please contact [email protected]

You are now signed in

Balancing Reserve Day ahead auction requirements forecast

CKAN Data API

Data Explorer

Data Explorer

Table Information

Auction Date

Service Delivery Date

Service Window

Service window start time

Service Window End Time

Positive Balancing Reserve Requirement MW

Negative Balancing Reserve Requirement MW

Forecast produced on

Forecast type