BSAD Forward Contracts 2022-23

This is the data for financial year 2022-23.

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=38f74f2c-f735-46fb-8e26-32545011a310&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "38f74f2c-f735-46fb-8e26-32545011a310" LIMIT 5`

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

var data = {
  resource_id: '38f74f2c-f735-46fb-8e26-32545011a310', // 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=38f74f2c-f735-46fb-8e26-32545011a310&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Date

Title	Date of balancing service adjustments
Type	timestamp
Description	Date at which balancing service adjustments occurred. Given in (Coordinated Universal Time) UTC or UTC+1 during British Summer Time.
Comment	N/A
Example	2019-01-04T00:00:00
Unit	N/A

SettlementPeriod

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

BCA

Title	Buy Cost Adjustment
Type	float
Description	Net Buy Price Cost Adjustment
Comment	N/A
Example	120.00
Unit	£

BSA

Title	Gross Volume Purchased
Type	float
Description	Gross Volume Purchased (Trades)
Comment	N/A
Example	120.00
Unit	MWh

BVA

Title	Buy Volume Adjustment
Type	float
Description	Net Buy Price Volume Adjustment
Comment	N/A
Example	120.00
Unit	MWh

SCA

Title	Sell Cost Adjustment
Type	float
Description	Net Sell Price Cost Adjustment
Comment	N/A
Example	120.00
Unit	£

SSA

Title	Gross Volume Sold
Type	float
Description	Gross Volume Sold (Trades)
Comment	N/A
Example	120.00
Unit	MWh

SVA

Title	SellVolumeAdjustment
Type	float
Description	Net Sell Price Volume Adjustment
Comment	N/A
Example	120.00
Unit	MWh

For any queries or feedback please contact [email protected]

You are now signed in

BSAD Forward Contracts 2022-23

CKAN Data API

Data Explorer

Data Explorer

Table Information

Date

SettlementPeriod

BCA

BSA

BVA

SCA

SSA

SVA