New API release – Wholesale real-time and forecast prices

  • 680 Views
  • Last post 15 March 2021
Phil Bishop posted this 10 November 2020

We have published a new API product called wholesale market prices. Subscribing to this product will enable users to receive a key to use one of four new APIs:

  • Forecast NRSS prices
  • Forecast PRSS prices
  • Real-time prices
  • Real-time dispatch

Each of these APIs provides a GET action that can be tested or accessed from our APIs page. A list of the returned fields and a brief description of each API is also provided on the APIs page, as are examples of the various ways the GET calls can be filtered.   

Please note that the Real-time prices and Real-time dispatch APIs are new APIs and should not be considered revised versions of the existing EMI | Real-time prices and EMI | Real-time dispatch APIs, respectively. The EMI | Real-time prices and EMI | Real-time dispatch APIs will be decommissioned on 21 December 2020.

We understand that WITS will create APIs to disseminate price and other data at some future date. We have published these APIs now because the WITS APIs are still some time away and these four new wholesale price APIs will make the data available much sooner after it has been generated than is the case with the existing APIs. In addition to the reduced data latency, we also expect much improved reliability from the new APIs.

The database underlying these new APIs holds data for the most recent 30 days. If historical data is required, users can download it from our Forecast prices and Real-time prices EMI datasets.

Access to forecast prices and real-time or indicative prices via APIs will assist in enabling better informed decisions to be made. Users of real-time prices should be aware that these prices are not the final prices on which the market is settled. See the discussion here and the links therein for more information about wholesale prices.

  • Liked by
  • geoff_ey
  • msouness
Order by: Standard | Newest | Votes
adam.m.fuller posted this 08 March 2021

Hi Phil, I recently signed up to the new real-time prices API.  The results I get from real-time dispatch for 

  • SPDLoadMegawatt
  • SPDGenerationMegawatt

are all zero for several spot checks I did.  Should I be seeing numbers close to actual MW?

Phil Bishop posted this 08 March 2021

It all looks fine to me when I checked just now. I see some nodes with just a price and no load or generation. Some nodes have generation but no load and others have load and no generation.

Specifically what nodes and at what time are you observing something that doesn't look right?

Cheers

Phil

 

adam.m.fuller posted this 08 March 2021

Request:

https://emi.azure-api.net/real-time-dispatch/?$filter=FiveMinuteIntervalDatetime eq datetime'2021-03-08T00:00' and PointOfConnectionCode eq 'BEN2201'

 

Response:

Pragma: no-cache
Arr-Disable-Session-Affinity: True
X-Content-Type-Options: nosniff
X-Frame-Options: deny
Strict-Transport-Security: max-age=31536000; includeSubDomains; preload
X-XSS-Protection: 1; mode=block
Content-Security-Policy: script-src 'self'
Cache-Control: no-store
Date: Mon, 08 Mar 2021 22:21:45 GMT
Content-Length: 87028
Content-Type: application/json
Expires: -1

[{
    "PointOfConnectionCode": "BEN2201",
    "FiveMinuteIntervalDatetime": "2021-03-08T00:00:00",
    "FiveMinuteIntervalNumber": 1,
    "RunDateTime": "2021-03-07T10:59:02",
    "SPDLoadMegawatt": 0.000,
    "SPDGenerationMegawatt": 0.000,
    "DollarsPerMegawattHour": 122.77
  },
  {
    "PointOfConnectionCode": "BEN2201",
    "FiveMinuteIntervalDatetime": "2021-03-08T00:05:00",
    "FiveMinuteIntervalNumber": 2,
    "RunDateTime": "2021-03-07T11:04:02",
    "SPDLoadMegawatt": 0.000,
    "SPDGenerationMegawatt": 0.000,
    "DollarsPerMegawattHour": 142.59
  },
  {
    "PointOfConnectionCode": "BEN2201",
    "FiveMinuteIntervalDatetime": "2021-03-08T00:10:00",
    "FiveMinuteIntervalNumber": 3,
    "RunDateTime": "2021-03-07T11:09:02",
    "SPDLoadMegawatt": 0.000,
    "SPDGenerationMegawatt": 0.000,
    "DollarsPerMegawattHour": 142.09
  },
  {
    "PointOfConnectionCode": "BEN2201",
    "FiveMinuteIntervalDatetime": "2021-03-08T00:15:00",
    "FiveMinuteIntervalNumber": 4,
    "RunDateTime": "2021-03-07T11:14:03",
    "SPDLoadMegawatt": 0.000,
    "SPDGenerationMegawatt": 0.000,
    "DollarsPerMegawattHour": 142.00
  },
  {
    "PointOfConnectionCode": "BEN2201",
    "FiveMinuteIntervalDatetime": "2021-03-08T00:20:00",
    "FiveMinuteIntervalNumber": 5,
    "RunDateTime": "2021-03-07T11:19:03",
    "SPDLoadMegawatt": 0.000,
    "SPDGenerationMegawatt": 0.000,
    "DollarsPerMegawattHour": 141.77
  },
  {
    "PointOfConnectionCode": "BEN2201",
    "FiveMinuteIntervalDatetime": "2021-03-08T00:25:00",
    "FiveMinuteIntervalNumber": 6,
    "RunDateTime": "2021-03-07T11:24:01",
    "SPDLoadMegawatt": 0.000,
    "SPDGenerationMegawatt": 0.000,

 

 

Phil Bishop posted this 15 March 2021

Thanks Adam. The problem you highlighted with the RTD API has now been fixed. Can't even blame the devs - they did exactly what I asked them to! At some point in the future when we get a little time, we'll enable more filtering options with all of the wholesale price APIs but hopefully they're adequate for now.

Cheers

Phil 

Close