EAC ESO Buy Orders 2023-2024

This contains the ESO's targets to pay for different quantities procured for each service and period. It also includes the substitutability family of each order. It also includes information on the cleared quantity, cleared price and rejection codes for each buy Order ID.

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=1cf68f59-8eb8-4f1d-bccf-11b5a47b24e5&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "1cf68f59-8eb8-4f1d-bccf-11b5a47b24e5" LIMIT 5`

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

var data = {
  resource_id: '1cf68f59-8eb8-4f1d-bccf-11b5a47b24e5', // 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=1cf68f59-8eb8-4f1d-bccf-11b5a47b24e5&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

auctionID

Title	auctionID
Type	integer
Description	Unique auction identifier. All products auctioned in the same market
Comment	MANDATORY
Example	14
Unit	N/A

orderID

Title	orderID
Type	integer
Description	The ID for the submitted bid in the auction (generated by EAC)
Comment	MANDATORY
Example	1
Unit	N/A

serviceType

Title	serviceType
Type	string
Description	Service Identifier - [Response, Quick Reserve or Slow Reserve]
Comment	MANDATORY
Example	Response
Unit	N/A

auctionProduct

Title	auctionProduct
Type	string
Description	Service Type Identifier – [DCH,DCL,DMH,DML,DRH,DRL,NSR,PSR,NQR,PQR]
Comment	MANDATORY
Example	Dynamic Containment LF
Unit	N/A

deliveryStart

Title	deliveryStart
Type	datetime
Description	The time from which delivery of the Auction Product will commence
Comment	MANDATORY
Example	2023-06-19T13:30:00Z
Unit	N/A

deliveryEnd

Title	deliveryEnd
Type	datetime
Description	The time from which delivery of the Auction Product will end
Comment	MANDATORY
Example	2023-06-19T17:30:00Z
Unit	N/A

quantity

Title	quantity
Type	number
Description	The total volume of the bid
Comment	MANDATORY
Example	10
Unit	MW

price

Title	price
Type	number
Description	A price (£/MW/h) indicative of the willingness to pay to procure the quantity
Comment	MANDATORY
Example	100
Unit	£/MW/h

substitutabilityFamily

Title	substitutabilityFamily
Type	integer
Description	The identifier of the substitutability family to which the order belongs
Comment	OPTIONAL
Example	N/A
Unit	N/A

paradoxicallyAcceptanceAllowed

Title	paradoxicallyAcceptanceAllowed
Type	string
Description	If True, the order ID can be paradoxically accepted
Comment	MANDATORY
Example	FALSE
Unit	N/A

orderEntryTime

Title	orderEntryTime
Type	datetime
Description	The time at which the bid was submitted
Comment	MANDATORY
Example	2023-06-05T10:37:25Z
Unit	N/A

acceptanceRatio

Title	acceptanceRatio
Type	number
Description	A number between 0 and 1, indicating the proportion of an Offered Quantity or a Bid Quantity which has been matched by the Auction algorithm
Comment	MANDATORY
Example	0
Unit	N/A

status

Title	status
Type	string
Description	Was the order accepted or rejected [EXECUTED,REJECTED,EXCLUDED]
Comment	MANDATORY
Example	Executed
Unit	N/A

executedQuantity

Title	executedQuantity
Type	number
Description	The volume of response that was accepted as at the clearing price
Comment	MANDATORY
Example	5
Unit	MW

clearingPrice

Title	clearingPrice
Type	number
Description	The cleared price per MW per hour (£/MW/h)
Comment	MANDATORY
Example	100
Unit	£/MW/h

reasonRejected

Title	reasonRejected
Type	string
Description	Reason Codes
Comment	OPTIONAL
Example	N/A
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

EAC ESO Buy Orders 2023-2024

CKAN Data API

Data Explorer

Data Explorer

Table Information

auctionID

orderID

serviceType

auctionProduct

deliveryStart

deliveryEnd

quantity

price

substitutabilityFamily

paradoxicallyAcceptanceAllowed

orderEntryTime

acceptanceRatio

status

executedQuantity

clearingPrice

reasonRejected