Nord Pool Market Data API

Step 1. Select APIs you have been subscribed to

The day-ahead market data can be retrieved via Market Data - DayAhead, Market Data - UK, and Market Data - Prices APIs. Depending on what subscription you have purchased, you will have access to corresponding APIs.

The N2EX/NO2 auction results with NSL capacity can be received via Market Data - UK APIs . Please notice in order to get prices and volumes for both NO2 and GB1 areas via UK APIs you have to be subscribed to both UK and NO countries. However, in order to get flows and capacities for both NO2 and UK it is enough to be subscribed to one UK or NO.

If you are interested only in recent auction prices, it will be enough to use Market Data - Prices APIs which allow getting a maximum of 8 days' history.

The Market Data - DayAhead APIs provide prices, volumes, capacities, flows data for delivery areas you are subscribed to (except the UK - it has its own endpoints) as well as the history dating back to 2016.

Step 2. Get Authorization token

[username]- Username you got from SMS

[password]- Password from SMS

Password needs to be URL-encoded if there are special characters. For example, this "4Amf33xYLp8%5D" would become this - "4Amf33xYLp8%255D".

Use the following request template:

      
        curl --request POST \
          --url https://sts.nordpoolgroup.com/connect/token \
          --header 'Authorization: Basic Y2xpZW50X21hcmtldGRhdGFfYXBpOmNsaWVudF9tYXJrZXRkYXRhX2FwaQ==' \
          --header 'Content-Type: application/x-www-form-urlencoded' \
          --data 'grant_type=password&scope=marketdata_api&username=[username]&password=[password]'
      
    

Response example:

      
        {
          "access_token": "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ik5CdWg4VFhkY0gzOHN0TzNaTjV3MmQtdU8zOCIsImtpZCI6Ik5CdWg4VFhkY0gzOHN0TzNaTjV3MmQtdU8zOCJ9.eyJpc3MiOiJodHRwczovL3Nzby5ub3JkcG9vbGdyb3VwLmNvbSIsImF1ZCI6Imh0dHBzOi8vc3NvLm5vcmRwb29sZ3JvdXAuY29tL3Jlc291cmNlcyIsImV4cCI6MTYzNjExOTE4NywibmJmIjoxNjM2MTE1NTg3LCJjbGllbnRfaWQiOiJjbGllbnRfbWFya2V0ZGF0YV9hcGkiLCJzY29wZSI6Im1hcmtldGRhdGFfYXBpIiwic3ViIjoiYTcxZmEwODgtZTI3MS00YTM3LWE1YjYtOTQ5MzVjNjQ2Y2M1IiwiYXV0aF90aW1lIjoxNjM2MTE1NTg3LCJpZHAiOiJpZHNydiIsInByZWZlcnJlZF91c2VybmFtZSI6IkFQSV9EQVRBX0FOVE9OIiwiYXBwbGljYXRpb25fc3Vic2NyaXB0aW9uIjoibWFya2V0ZGF0YV9hcGlfbm9yZGljYmFsdGljIiwiYW1yIjpbInBhc3N3b3JkIl19.wn3D8vkWs9DhwPm3JuDrE591uv2bYERA19Y0sRkbNbJU5MwBDlLApTkEULSCr-4jGS-3tiCB9ikkMmLrvS_58dWCQ5OH4RSiTxqfHiVhMbcd3nlqRCVpjOd_O37uv4X0m4TKRNxUSKyekADzL0bvTbZCDtkH-4Tp_nuQLocUT1gSSbv1AEar__6agPxQUgoaOhBXf7nNhH4xGG7b6QTQXqb3eyD-Z6Y1hBDlVstafvHhccLLJHwojhm562NihGnQkTEZTCHdCquMiG0HO3wwSinT3-dHEo9Ntw21Qo6R9R9tj0-7JWVMQWk5vHT_AHjrBGrQMJYxCo--yAPP-DBemhgYHVOlM0lL6ZoE0prr9jQO6VesPN80vN3Bv18qTyWI5GcOVwNQUnNOBPCygvutz88GMhJsR3PduFh6ilf1RU5D_4NCq__CoSrv7RwJ_kstPvsNo6qhyigkMgMkiNQVZbcAp8qAPoz_o1qnLJwX84bxm3xQZc-5mx-gpJhS7amHm36TTqllujNuvAIrxznrPX8k7iVm1u_i05WKpwx84kXSbXzOoPWfjNeApy-W36KuQh8-aa9qK4xFs46UfPX2JcrJmch7NFuS7hLY3GE8BKRpU30VTAcaWwdxMhrSdhGjWlHIgERTD4k1UQ6OJoa_vlwyzRiChbtYYtsZfS72hEo",
          "expires_in": 3600,
          "token_type": "Bearer"
        }
      
    

Step 3. Use the API

Full request example using authorization header from Step 2:

      
        curl --request GET \
          --url 'https://marketdata-api.nordpoolgroup.com/dayahead/prices/areaBlock?startTime=2021-10-27T00%3A00%3A00Z&endTime=2021-10-29T00%3A00%3A00Z&deliveryarea=FI' \
          --header 'Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ik5CdWg4VFhkY0gzOHN0TzNaTjV3MmQtdU8zOCIsImtpZCI6Ik5CdWg4VFhkY0gzOHN0TzNaTjV3MmQtdU8zOCJ9
      
    

Originally Market Data APIs provided only one "deliveryarea" parameter that is used to filter data by delivery areas. In some cases, the APIs return more data than necessary. When asking FlowsAtAreaPrice for example DK1-NL connection and providing deliveryarea="DK1,NL" the endpoint returns data for DK1-NL, DE-DK1, NO2-DK1, DK1-SE3, DK1-NO2, and so on. For such cases, the client has to filter data on their side and add logic to remove data that is not asked for. To simplify the case of asking for the specific data we introduced two new properties: "deliveryareafrom" and "deliveryareato" to define the exact direction. The similar reasons were for introducing "currencyfrom" and "currencyto" parameters.

List of affected endpoints:

Market Data DayAhead - Capacities, CapacitiesPrognosis, ExchangeRates ("currencyfrom" and "currencyto" parameters), ExternalExportConstraints, ExternalImportConstraints, FlowsAtAreaPrice, FlowsAtSystemPrice, LongTermAllocation, PhysicalCapacities, ReductionReasons

Market Data UK - UkCapacities, UkExchangeRates ("currencyfrom" and "currencyto" parameters), UkFlowsAtAreaPrice

Market Data Operating Data - AreaExchange, Flow, InitialCapacity, TotalScheduledFlow

These new properties (deliveryareafrom and deliveryareato) are optional parameters in the request. As well only one of them can be provided in the request. Let's consider what API will return for the following query parameters:

1. if deliveryareafrom="AREA1" and deliveryareato="AREA2" are both valid areas and the customer is subscribed to them, then API returns timeseries with attributes
"attributes": [{
  "role": "from",
  "name": "deliveryArea",
  "value": "AREA1"
}, {
  "role": "to",
  "name": "deliveryArea",
  "value": "AREA2"
}]
Please note that the customer should be subscribed to at least one of the requested areas (deliveryareafrom or deliveryareafrom).

2. if deliveryareafrom="AREA3" and deliveryareato="AREA4" and deliveryarea="AREA5" are both valid areas and the customer is subscribed to them, then delivery area "AREA5" will be ignored and API returns timeseries with attributes
"attributes": [{
  "role": "from",
  "name": "deliveryArea",
  "value": "AREA3"
}, {
  "role": "to",
  "name": "deliveryArea",
  "value": "AREA4"
}]

This is a non-breaking change. Should you wish to continue using the "deliveryarea" parameter without specifying from and to, it will continue to work as it did in the old version.

Most of Market Data APIs require string parameter "deliveryarea". Here all available delivery areas are presented. If there are no data for given delivery area, then response “No Content” (status code 204) is returned. Delivery areas are divided based on the country. In order to get data for several areas, it is needed to list them separated by commas without spaces, for example, SE1,FI,NO1.

If no deliveryarea is entered, APIs return data for the countries the customers are subscribed to.

TimeSeries Data Object

All APIs (exept UkBlockOrders, UkPriceCurves, UserQuery) return an array of Time Series Objects filtered by request parameters such as delivery area, dates, currency, etc. A time series object is a sequence taken at successive equally spaced points in time. Definition of points depends on the category, type, subtype which are returned as part of the response object.

UkBlockOrders Data Object

UkBlockOrders returns CSV file back. Each row of the file represents a block order. Its data is listed in columns: the first 15 columns describe block order details such as Area, Type, ID, Block, Dur., familyID, parentBlockID, MinAccep.%, Currency, Avg price, VWAP, Order price, Quant, Accep. %, Status, and second 24 columns represent volumes for every hour.

DayAhead AreaBlockPrices, AreaPrices, LocationPrices, PriceCurves, SystemPrices, TurnoverAtSystemPrice, AreaPurchaseVolumes and AreaSaleVolumes datas are updated daily, after day-ahead price setting.
DayAhead prognosis for transmission capacity is updated every Friday.
DayAhead capacities and capacity reduction reasons are published before 10:00 CET on the day before delivery.
DayAhead ExchangeRates are updated daily.
DayAhead FlowsAtAreaPrices are updated daily, after day-ahead price setting, usually before 14:00 CET.

Regulation Market data is updated several times during the day. As TSO updates our system the data will be rolling to the Regulation Market service and information will be avilable through the API.

UkAreaBlockPrices, UkAreaPrices, UkAreaPurchaseVolumes, UkAreaSaleVolumes, UkHalfHourAuctionAreaBlockPrices, UkHalfHourAuctionAreaPrices, UkHalfHourAreaPurchaseVolumes and UkHalfHourAreaSaleVolumes datas are updated daily, after UK day-ahead price setting.
UkBlockOrders and UkPriceCurves data are updated daily, at 9:30AM in GMT.
UkCapacities data is published at 09:30 CET.
UkFlowsAtAreaPrice data is published around 11:00 CET.

The Intraday orders API returns an array of objects in JSON format. The fields from the order object are described in the following table.

The Intraday trades API returns an array of objects in JSON format. The fields from the trade object are described in the following table.

The Intraday Hub2Hub capacities API returns an array of objects in JSON format. The fields from the trade object are described in the following table.

In the next table, you can find the mapping between Data Portal and Market Data API.

NORD POOL DAY-AHEAD

NORD POOL INTRADAY

NORD POOL UK

REGULATING POWER

POWER SYSTEM DATA