If you’d like to provide feedback on the ESO Data Portal, please contact us at box.OpenData.ESO@nationalgrideso.com

Upcoming Trades

Upcoming Trades

Download (csv)

API

This dataset displays all upcoming GTMA (Grid Trade Master Agreement) trades due to be delivered. The data is refreshed every ten minutes.

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.

Endpoints

The Data API can be accessed via the following actions of the CKAN action API.

Query	`https://data.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)	`https://data.nationalgrideso.com/api/3/action/datastore_search_sql`

Querying

Query example (first 5 results)

https://data.nationalgrideso.com/api/3/action/datastore_search?resource_id=0b7e84ec-eded-4458-b111-d29ba4508e85&limit=5

Query example (via SQL statement)

https://data.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "0b7e84ec-eded-4458-b111-d29ba4508e85" LIMIT 5

Example: Javascript

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

  
var data = {
resource_id: '0b7e84ec-eded-4458-b111-d29ba4508e85', // the resource id
limit: 5 // get 5 results
};
$.ajax({
url: 'https://data.nationalgrideso.com/api/3/action/datastore_search',
data: data,
dataType: 'jsonp',
success: function(data) {
alert('Total results found: ' + data.result.total)
}
});

Example: Python

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

  
import urllib2
url = 'https://data.nationalgrideso.com/api/3/action/datastore_search?resource_id=0b7e84ec-eded-4458-b111-d29ba4508e85&limit=5'
fileobj = urllib2.urlopen(url)
print fileobj.read()

Table Information

ID

Title	Trade ID
Type	String
Description	ID of the GMTA Trade
Comment	N/A
Example	ES00101010
Unit	N/A

Date

Title	Settlement date
Type	Date
Description	Settlement date
Comment	Settlement date of the trade.
Example	2020-01-05T00:00:00
Unit	N/A

SP

Title	Settlement period
Type	Integer
Description	Settlement period number that trade is delivered.
Comment	A typical day is split into 48 30 minute segments, starting from 00:00. Long days contain 50 segments, while shorter days contain 46 Settlement periods.
Example	10
Unit	N/A

Volume

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

Price

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

Cost

Title	Cost
Type	Float
Description	Cost of the Trade to National Grid ESO
Comment	Cost = Price * Volume * Duration. The value is rounded to up to 2 decimal places
Example	38.57
Unit	£

SO_Flag

Title	System Flag
Type	String
Description	The SO-Flag indicates whether or not the Action was potentially taken for reasons other than balancing the short-term energy imbalance of the Transmission System.
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	String
Description	Detailed reason for the Trade
Comment	This can be for voltage, thermal constraints, ROCOF, upwards margin or downwards reserve etc
Example	V_SE_England/ROCOF
Unit	N/A

Note

Title	Note
Type	String
Description	Notes or comments
Comment	N/A
Example	Trade approved for reason - XXX
Unit	N/A

Last_Updated

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