Phase 2: FFR Auction Linear Orders 26.11.2021

Phase 2 FFR Auction Linear Orders 26.11.2021

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=5cce4cb6-c270-488f-96c7-9f5cd7476898&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "5cce4cb6-c270-488f-96c7-9f5cd7476898" LIMIT 5`

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

var data = {
  resource_id: '5cce4cb6-c270-488f-96c7-9f5cd7476898', // 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=5cce4cb6-c270-488f-96c7-9f5cd7476898&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

MarketName

Title	Market Name
Type	string
Description	The market for which the bid is in relation to. The two choices are DLH (Dynamic Low High) and LFS (Low Frequency Static).
Comment
Example	DLH
Unit

BiddingLevelName

Title	Bidding Level Name
Type	string
Description	The market for which the bid is in relation to. The two choices are DLH (Dynamic Low High) and LFS (Low Frequency Static)
Comment
Example	DLH
Unit

MemberName

Title	Member Name
Type	string
Description	The member of the trial who submitted the bid
Comment
Example	NATIONAL GRID ESO
Unit

OrderID

Title	Order ID
Type	integer
Description	The ID for the submitted bid in the auction
Comment
Example	100000000013002
Unit

Portfolio

Title	Portfolio
Type	string
Description	The portfolio associated with the FFR provider
Comment
Example	NGESO-T001
Unit

OrderEntryTime

Title	Order Entry Time
Type	datetime
Description	The time at which the bid was submitted
Comment
Example	12/3/2020 13:23
Unit

OrderEntryUser

Title	Order Entry User
Type	string
Description	The user who submitted the entry
Comment
Example	NGESO-A
Unit

SettlementCurrency

Title	Settlement Currency
Type	string
Description	The currency in which the bid was submitted
Comment
Example	GBP
Unit

OrderPeriodID

Title	Order Period ID
Type	integer
Description	The ID submitted with this bid
Comment
Example	100000000017382
Unit

TradeID

Title	Trade ID
Type	integer
Description	Identical to the previous column
Comment
Example	100000000017382
Unit

EFA

Title	Electricity Forward Agreement (EFA) block number
Type	integer
Description	The week is split into 42 blocks, with 6 four-hour blocks each day
Comment
Example	1
Unit

DeliveryStart

Title	Delivery Start
Type	datetime
Description	The time from which delivery of FFR will commence
Comment
Example	13/03/2020 23:00:00
Unit

DeliveryEnd

Title	Delivery End
Type	datetime
Description	The time from which delivery of FFR will end
Comment
Example	13/03/2020 22:00:00
Unit

ExecutedVolume

Title	Executed Volume
Type	integer
Description	The volume of the order which is executed
Comment
Example	100
Unit	MW

1P

Title	1P
Type	number
Description	The price of point 1 on the bid curve.
Comment
Example	0
Unit	£/MW

1V

Title	1V
Type	integer
Description	The volume of point 1 on the bid curve.
Comment
Example	100
Unit	MW

2P

Title	2P
Type	number
Description	The price of point 2 on the bid curve.
Comment
Example	6.34
Unit	£/MW

2V

Title	2V
Type	integer
Description	The volume of point 2 on the bid curve.
Comment
Example	100
Unit	MW

3P

Title	3P
Type	number
Description	The price of point 3 on the bid curve.
Comment
Example	6.34
Unit	£/MW

3V

Title	3V
Type	integer
Description	The volume of point 3 on the bid curve.
Comment
Example	0
Unit	MW

4P

Title	4P
Type	number
Description	The price of point 4 on the bid curve.
Comment
Example	999.99
Unit	£/MW

4V

Title	4V
Type	integer
Description	The volume of point 4 on the bid curve.
Comment
Example	0
Unit	MW

For any queries or feedback please contact [email protected]

You are now signed in

Phase 2: FFR Auction Linear Orders 26.11.2021

CKAN Data API

Data Explorer

Data Explorer

Table Information

MarketName

BiddingLevelName

MemberName

OrderID

Portfolio

OrderEntryTime

OrderEntryUser

SettlementCurrency

OrderPeriodID

TradeID

EFA

DeliveryStart

DeliveryEnd

ExecutedVolume

1P

1V

2P

2V

3P

3V

4P

4V