Potential Alternative April 2021 - March 2022

List of potential alternative actions from April 2021 to March 2022 compared to issued BOAs. Defines the alternative actions and provides reasons why these actions may not have been taken by the control room.

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=2233f302-8dfe-49fb-bba4-7911879ff21b&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "2233f302-8dfe-49fb-bba4-7911879ff21b" LIMIT 5`

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

var data = {
  resource_id: '2233f302-8dfe-49fb-bba4-7911879ff21b', // 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=2233f302-8dfe-49fb-bba4-7911879ff21b&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

SETT DATE

Title	Settlement Date
Type	datetime
Description	Settlement date of record.
Comment
Example	2021-03-28T00:00:00
Unit

SETT PERIOD

Title	Settlement Period
Type	number
Description	Settlement period of record.
Comment
Example	5
Unit

ACCEPTED BMU

Title	Accepted BMU
Type	string
Description	Balancing Mechanism Unit (BMU) name of the unit issued with the BOA.
Comment
Example	HUMR-1
Unit

BOA REF

Title	BOA Reference Number
Type	number
Description	BOA reference number, unique to the accepted BMU.
Comment
Example	166026
Unit

BID/OFFER

Title	Bid / Offer Indicator
Type	string
Description	Indicates whether the BOA is a bid or offer.
Comment
Example	BID
Unit

BOA PRICE (GBP/MWh)

Title	BOA Price
Type	number
Description	Price of the BOA. Recorded as £ per MWh.
Comment
Example	-50
Unit	£ / MWh

ALTERNATIVE BMU

Title	Alternative BMU
Type	string
Description	BMU name of the unit identified as a potential alternative to the BOA unit.
Comment
Example	FASN-4
Unit

REASON GROUP

Title	Reason Group
Type	string
Description	List of reasons why the alternative unit was not instructed, left blank if no reason identified. Definition of reasons held in the methodology.
Comment
Example	Incomplete, Zonal Management
Unit

BID PRICE (GBP/MWh)

Title	Bid Price
Type	number
Description	Bid price of the alternative action, blank if not applicable. Recorded as £ per MWh.
Comment
Example	28
Unit	£ / MWh

OFFER PRICE (GBP/MWh)

Title	Offer Price
Type	number
Description	Offer price of the alternative action, blank if not applicable. Recorded as £ per MWh.
Comment
Example	20
Unit	£ / MWh

APPROX ALTERNATIVE VOL (MWh)

Title	Approximate Alternative Action Volume
Type	number
Description	Estimation of the energy from the alternative action. Recorded as MWh.
Comment
Example	147
Unit	MWh

ABS PRICE DIFFERENCE (GBP/MWh)

Title	Absolute Price Difference
Type	number
Description	Absolute price difference between the BOA and alternative action. Recorded as £ per MWh.
Comment
Example	23.85
Unit	£ / MWh

DIFFERENTIAL CASHFLOW (GBP)

Title	Differential Cashflow
Type	number
Description	Estimation of the cost difference between the BOA and the alternative action. Recorded as £.
Comment
Example	40
Unit	£

For any queries or feedback please contact [email protected]

You are now signed in

Potential Alternative April 2021 - March 2022

CKAN Data API

Data Explorer

Data Explorer

Table Information

SETT DATE

SETT PERIOD

ACCEPTED BMU

BOA REF

BID/OFFER

BOA PRICE (GBP/MWh)

ALTERNATIVE BMU

REASON GROUP

BID PRICE (GBP/MWh)

OFFER PRICE (GBP/MWh)

APPROX ALTERNATIVE VOL (MWh)

ABS PRICE DIFFERENCE (GBP/MWh)

DIFFERENTIAL CASHFLOW (GBP)