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
Type	any
Description
Comment
Example
Unit

Service Delivery Date

Title
Type	any
Description
Comment
Example
Unit

Service Window

Title
Type	any
Description
Comment
Example
Unit

Service window start time

Title
Type	datetime
Description
Comment
Example
Unit

Service Window End Time

Title
Type	datetime
Description
Comment
Example
Unit

Positive Balancing Reserve Requirement MW

Title
Type	any
Description
Comment
Example
Unit

Negative Balancing Reserve Requirement MW

Title
Type	any
Description
Comment
Example
Unit

Forecast produced on

Title
Type	any
Description
Comment
Example
Unit

Forecast type

Title
Type	string
Description
Comment
Example
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