BSAD Forward Contracts 2017-18

This is the data for financial year 2017-18.

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=16fe508d-27da-4282-b8af-1fa519b6f480&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "16fe508d-27da-4282-b8af-1fa519b6f480" LIMIT 5`

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

var data = {
  resource_id: '16fe508d-27da-4282-b8af-1fa519b6f480', // 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=16fe508d-27da-4282-b8af-1fa519b6f480&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date of balancing service adjustments
Type	date
Description	Date and time at which balancing service adjustments occurred. Given in (Coordinated Universal Time) UTC or UTC+1 during British Summer Time.
Comment
Example	30/09/2018
Unit

Settlement Period

Title	Settlement Period
Type	integer
Description	The half hourly period at which balancing service adjustments occurred. Settlement period 1 runs from 00:00-00:30.
Comment
Example	5
Unit

BCA (£)

Title	Buy Cost Adjustment
Type	number
Description	Net Buy Price Cost Adjustment
Comment
Example	0
Unit	£

BSA (MWh)

Title	Gross Volume Purchased
Type	number
Description	Gross Volume Purchased (Trades)
Comment
Example	120
Unit	MWh

BVA (MWh)

Title	Buy Volume Adjustment
Type	number
Description	Net Buy Price Volume Adjustment
Comment
Example	100
Unit	MWh

SCA (£)

Title	Sell Cost Adjustment
Type	integer
Description	Net Sell Price Cost Adjustment
Comment
Example	50
Unit	£

SSA (MWh)

Title	Gross Volume Sold
Type	number
Description	Gross Volume Sold (Trades)
Comment
Example	50
Unit	MWh

SVA (MWh)

Title	Sell Volume Adjustment
Type	number
Description	Net Sell Price Volume Adjustment
Comment
Example	300
Unit	MWh

For any queries or feedback please contact [email protected]

You are now signed in

BSAD Forward Contracts 2017-18

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

Settlement Period

BCA (£)

BSA (MWh)

BVA (MWh)

SCA (£)

SSA (MWh)

SVA (MWh)