Skip to main content

Wholesale datasets

Forecast prices

Forecast prices are prepared and published on WITS  by the pricing manager according to the provisions set out in Part 13 of the Code.  Prices from selected schedules  are made available here for analysis and research purposes.

Price files published during any given day are compressed into a zip file, by forecast price type, and uploaded to EMI datasets in a single batch job early in the morning of the following day. The zipped up CSV price files are presented as is where is, ie we do not transform the data or in any other way reformulate it from that which WITS published. We do, however, slightly revise the CSV file naming convention.

The naming convention for the CSV files is <PriceType>YYYYMMDDhhmmdd.csv where:

  • <PriceType> denotes the price type, ie PRSL, NRSL, PRSS and NRSS
  • YYYYMMDD is the date of the first trading period found in the file
  • hhmmdd is the run time of the schedule (see 'Run time' in column description below).

The CSV files contain six columns and have no header row. Taken in order, the columns are:

  • Point of connection, eg HAY2201
  • Trading date - dd/mm/yyyy
  • Trading period - an integer from 1 to 50
  • Price ($/MWh) - number(8,2)
  • Run time - dd/mm/yyyy hh:mm:ss, ie the time at which the SPD model was run to generate the prices
  • Price type - a 1-character label denoting the schedule or price type: A for PRSS, G for PRSL, N for NRSS and L for NRSL.

At this time, all forecast prices except those emanating from the weekly dispatch schedule (WDS) are made available dating back to 20 October 2018.

Name Date modified File size
19 Apr 2024
19 Apr 2024
19 Apr 2024
19 Apr 2024
What are datasets?

Datasets are collections of files that often contain large volumes of data and are available for immediate download. Dataset users are typically analysts familiar with the electricity industry and have a need to obtain a large set of data or specific data on a regular basis.

Trending wholesale datasets
Check a term

Visit the glossary for a list of defined terms used on the website.

Have a question?

Visit the forum to see if the information you are looking for is already available or ask a question to see if some of our informed users or staff can help?

Alternative access to datasets

Alternative methods are supported to connect to EMI datasets. These methods better facilitate downloading many files or automating regular downloads. See here for more information.