SPD case files

  • Last post 06 September 2020
Phil Bishop posted this 07 June 2016

SPD stands for Scheduling, Pricing and Dispatch and is the name of the model used to run the New Zealand wholesale electricity market. See also Part 13 of the Code for the rules describing how scheduling, pricing, and dispatch actually works.

The Authority receives all published SPD case files. An SPD case file contains all of the inputs required for that case and all of the outputs generated by SPD for that case. Final pricing case files are published on EMI Datasets.

The remainder of this discussion explains the naming convention used with SPD case files. A case file is a zipped collection of text files.

Naming convention for SPD case files

The naming format for an SPD case file is MSS_DDCCCYYYYMMHHHHNNN_0X.ZIP where:

  • DD denotes the Coordinated Universal Time (UTC) day number for the trading day. This is not zero padded so for the first nine days of the month this is a single digit.
  • CCC denotes the case type where:
    • 120 denotes the WDS – weekly dispatch schedule
    • 131 denotes the PRSL – long price-responsive schedule
    • 130 denotes the PRSS – short price-responsive schedule
    • 133 denotes the NRSL – long non-response schedule
    • 132 denotes the NRSS – short non-response schedule
    • 101 denotes the RTD – real-time dispatch schedule
    • 110 denotes the RTP – real-time pricing schedule
    • 111 denotes the FP – final pricing schedule
  • YYYY denotes the UTC year
  • MM denotes the UTC month. This is zero padded so is always two digits
  • HHHH denotes the UTC 24-hour time for the first trading period that the case is solved for
  • NNN denotes three random digits and can be used to distinguish multiple instances of a particular case.

As an example, consider the final pricing cases that were generated in relation to 26 March 2011, the day an undesirable trading situation was declared. There were three final pricing cases published for that day:

  • MSS_251112011031100351_0X.ZIP published at about 8:00am on 27 March 2011
  • MSS_251112011031100213_0X.ZIP published at about 11:00am on 28 March 2011
  • MSS_251112011031100322_0X.ZIP published at about 11:40am on 22 February 2013.

Whereas final prices are usually determined within two business days following the trading day, final prices for the periods subject to the UTS on 26 March 2011 were not determined until 22 February 2013. Final pricing cases are assessed by the pricing manager and, in accordance with the rules set out in Part 13 of the Code, are determined to be provisional, interim or final. A final price must be deemed final by the pricing manager before it is able to be used for the purpose of market settlement. There is nothing in the name of the SPD final pricing case files to indicate its provisional, interim or final status.

Finally, see also our discussion on GDX files for use with vSPD. 

  • Liked by
  • Sam Harvey
Order by: Standard | Newest | Votes
mokhtar posted this 05 September 2020

Hi Phil,

I am running a database on Power Bi and I need to access to the daily spot price for Tauranga node. Any advice on how I can receive it automatically every day? cheers

Phil Bishop posted this 06 September 2020

Final prices are determined ex post and are two days old by the time they're available. We make final prices available in the following reports/datasets:

Alternatively you could obtain final prices from the WITS website.

If it's 5-minute prices you're after, you could use our RTP API to get prices about 20 minutes after real time. To be clear, the market settles on final prices; not the 5-minute indicative prices.

We are currently working on revamping our price APIs to offer more price types, more filtering options, and, in the case of real-time prices, less time between real time and the prices being available. An announcement will be made on EMI soon when these new APIs are ready.


mokhtar posted this 06 September 2020

 Thanks Phil for fast response. Well, to access your API data I must have subscribed. I did and still, no one went through my request. Do you know how long does it take? is it free to access the data? Thanks

Matthew Keir posted this 06 September 2020

I've activated your account for you. You should be good to go now. Cheers, Matthew