Historic GTMA Trades FY 23-24

This data set displays the detail of Historic GTMA trades for Financial Year 23-24.

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=f659641a-668f-446c-92c5-72d387121330&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "f659641a-668f-446c-92c5-72d387121330" LIMIT 5`

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

var data = {
  resource_id: 'f659641a-668f-446c-92c5-72d387121330', // 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=f659641a-668f-446c-92c5-72d387121330&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

ID

Title	Trade ID
Type
Description	ID of the GTMA trade
Comment	N/A
Example	ES00101011
Unit	N/A

StartTime

Title	Start Time (UTC)
Type
Description	Start time of the trade in UTC format
Comment	N/A
Example	2020-01-05T00:00:00
Unit	UTC ISO 8601

EndTime

Title	End Time (UTC)
Type
Description	End time of the trade in UTC format
Comment	N/A
Example	2020-01-06T00:00:00
Unit	UTC ISO 8601

Volume

Title	Average Volume
Type
Description	Average Volume of the trade
Comment	A positive number represents the action increase generation /decrease demand or provide upwards margin; a negative number represents the action reducing generation / increase demand or provide downwards margin. Value is rounded to up to 1 decimal place
Example	10.9
Unit	MW

Price

Title	Price
Type
Description	Average price of the trade
Comment	The value is rounded to up to 2 decimal places
Example	200.01
Unit	£/MWh

Cost

Title	Cost
Type
Description	Total cost to Nationalgrid ESO for the trade
Comment	Cost = Volume * Price * Duration. The value is rounded to up to 2 decimal places
Example	38.57
Unit	£/h

SO_Flag

Title	System Flag
Type
Description	System flag indicating whether the action is mainly for system security purpose
Comment	SO_Flag = T (True) means the action is mainly for system security reason, SO_Flag = F (False) means the action is mainly for balancing reason
Example	T,F
Unit	N/A

Reason

Title	Trade Reason
Type
Description	Detailed reason for the trade
Comment	This can be for voltage, thermal constraints, ROCOF, upwards margin or downwards reserve etc
Example	Voltage: V_Mersey, V_SouthEast (Votlage) Thermal: LE1, B6; ROCOF_BMU, ROCOF_IC, Margin, Downwards, Others
Unit	N/A

Note

Title	Note
Type
Description	Notes or comments
Comment	N/A
Example	N/A
Unit	N/A

Last_Updated

Title	Last Updated
Type
Description	Date and Time that the information has been last updated
Comment	N/A
Example	2020-01-05T00:00:00
Unit	UTC ISO 8601

For any queries or feedback please contact [email protected]

You are now signed in

Historic GTMA Trades FY 23-24

CKAN Data API

Data Explorer

Data Explorer

Table Information

ID

StartTime

EndTime

Volume

Price

Cost

SO_Flag

Reason

Note

Last_Updated