Data is provided in comma delimited flat file format to enable access to a range of market data. Recent files are stored in a directory for current reports, and older files are moved into the archive reports directory.
Prices quoted in these files are exclusive of GST.
File names include date and time stamps and a unique identifier to differentiate the files:
eg. PUBLIC_DISPATCHIS_200511081245_0000000068650088.ZIP
Dispatch - filename: public_dispatchis_*.csv (approx. size 10Kb)
This file contains public 5 minute dispatch data by region. Data covers interconnector flows, constraints, regional reference price, demand, dispatchable generation, dispatchable load, and ancillary services data. This file format will be updated in line with NEM market developments. (Please see note)
Actual generation and load data - filename: public_dispatchSCADA_*.csv (approx. size 16Kb)
This file contains actual generation data for each scheduled generation unit, semi-scheduled generation unit, and non-scheduled generating units or non-scheduled generating systems (a non-scheduled generating system comprising non-scheduled generating units). This file also contains actual load for each scheduled load. The actual generation and load data in the file is reported under a column headed 'SCADAVALUE'. (Please see note)
Trading - filename: public_tradingis_*.csv (approx. size 5Kb)
This file contains public 30 minute dispatch data by region. Data covers interconnector flows, regional reference price, demand, dispatchable generation, dispatchable load, and ancillary services data. This file format will be updated in line with NEM market developments. (Please see note)
Predispatch - filename: public_predispatchis_*.csv (approx. size 4Mb)
This file contains 30 minute predispatch (forecast) data by region to the end of the next market day, and is updated half hourly. Data covers forecast interconnector flows, constraints, regional reference price, demand, dispatchable generation, dispatchable load, and ancillary services data. This file format will be updated in line with NEM market developments. (Please see note)
5 Minute Predispatch - filename: public_p5min_*.csv (approx. size 1Mb)
This file contains 5 minute predispatch (forecast) data by region, showing short term price and demand forecasts looking out one hour ahead. The information is updated every 5 minutes. (Please see note)
Daily Aggregated Dispatch - filename: public_daily_*.csv (approx. size 35Mb)
This file is generated daily, shortly after 0400. It contains previous day data for all dispatch and trading intervals. Data provided by generating unit includes initial MW, dispatch targets and ramp rates. By region data includes regional reference prices, demand, dispatchable load, and net interchange. (Please see note)
Next Day Dispatch - filename: public_next_day_dispatch_*.csv (approx. size 50Mb)
This file is generated daily, shortly after 0400. The file contains, for each dispatch interval of the previous trading day, all unit dispatch and constraint solutions from each 5-minute dispatch run, and the date-time version of each unit energy and FCAS offer used in each dispatch run. The file does not contain details of each unit energy and FCAS offers but these can be found at Yesterday's Bids
Non-Scheduled Generation Data - filename: public_next_day_actual_gen_*.csv (approx. size 600Kb)
The metered power outputs from most large non-scheduled generating units and generating systems are provided to AEMO in real time to assist in maintaining the security of the power system. Under Clause 3.13.4(r) of the National Electricity Rules AEMO is also required to publish such data to Registered Participants, in a daily file covering all intervals of the previous trading day.
The output values in these files are sampled from SCADA at 5-minute intervals and reported under the column headed 'MWH_READING'. Note that these figures should be read as instantaneous power in MW rather than MWh. They may be used to estimate energy production, but are not the same as the half-hourly energy metering results used to determine market settlements. (Please see note)
Historical Demand - filename: public_histdemand_*.csv (approx. size 2Mb)
This file contains historical demand information (4 second SCADA de mand average over half hour interval), by region for each trading interval for that trading day.
Short Term PASA - filename: public_stpasa_*.csv (approx. size 2Mb)
This report is published every 2 hours and provides detailed disclosure of short-term power-system supply/demand balance prospects for six days following the next trading day. The information is provided for each half-hour within the report period. (Please see note)
Medium Term PASA- filename: public_mtpasa_*.csv (approx. size 6Mb)
This file is produced weekly (on Tuesdays) and lists the medium-term supply/demand prospects for the period two years in advance. The information is provided for each day within the report period.
Each week participants must submit forecasts of availability to AEMO for the next 24 months, commencing eight days after the publication date of the Medium-Term PASA report. These forecasts form the basis of the Medium-Term PASA report that will be produced the following week. (Please see note)
Daily Prices - filename: public_prices_*.csv (approx. size 1Mb)
This file is generated daily, shortly after 0400. Data is by region and includes regional reference prices, demand, dispatchable load, net interchange and excess generation. Please note that any price adjustments are not included in this data set (please refer to Adjusted Prices). (Please see note)
Yesterday's Bids - filename: public_yestbid_*.csv (approx. size 50Mb)
This file is generated daily, shortly after 0400. It contains the previous day's bidding data by generating unit. It is important to note that these files are very large (files are in excess of 100,000 lines) and may not be viewable using standard desktop spreadsheet applications. (Please see note)
Settlement Residue Auction - filename: aucunits_* (approx. size 2Kb)
This file provides data from Settlements Residue Auctions. Files are produced twice weekly in conjunction with the preliminary and final settlements statements (see Rules Clauses 3.15.14 and 3.15.15). Preliminary files are overwritten by finals. Data covers:
total auction units, total surplus, distributed surplus, auction fees, net payment, net payment per unit, accumulated net payment, and accumulated net payment by unit.
- Current files - 2 month rolling window
- Archive files - currently no archive available
Market Network Service Provider Bids - filename: public_yestbidMNSP_*.csv (approx. size 20Kb)
This file is generated daily, shortly after 0400. It contains the previous day's bidding for price and availability for the Directlink interconnector.
Market Suspension Default Pricing Schedules - filename:
PUBLIC_MKTSUSP_PRICES_<#CASE_DATE>_<#REPORT_DATETIME>_<#EVENT_QUEUE_ID>.csv (approx. size 40Kb)
#CASE_DATE = Market Date (YYYYMMDD) when the previous report was created - usually the Sunday before last
#REPORT_DATETIME = Market Date & time (YYYYMMDDhhmiss) when this report was created - usually last Sunday around 03:00hrs
#EVENT_QUEUE_ID = Unique Job ID for creating this report
This file is generated each week at around 0300hrs on Sundays and otherwise on an ad hoc basis if any manual price adjustments occur. Where there are multiple files created for the same week due to price adjustments, the file with the latest #REPORT_DATETIME takes precedence.
The data fields "EFFECTIVEDATEFROM" and "EFFECTIVEDATETO" inside each file refer to respectively the start and end date of the week that the pricing schedules within the file apply to.
- Current files - 3 week rolling window
- Archive files - currently no archive available
Adjusted Prices - filename: public_price_revision_dispatch_*.csv (approx. size 5Kb)
This report is published when there has been a price adjustment due to an overconstrained dispatch within the NEM. The file will detail the old and new RRP for each affected dispatch and trading interval for the specified region.
Volume Weighted FCAS Prices - filename: vwa_fcas_prices_*.csv (approx. size 30Kb)
In response to a request from the Australian Financial Markets Association (AFMA), on behalf of Market Participants, AEMO has agreed to calculate and publish a system volume weighted average (VWA) half-hour price for each Frequency Control Ancillary Service (FCAS) to assist participants in managing their risks. The Volume-Weighted Average half-hour prices will be determined on a system wide basis to correlate with the exposure of participants (recovery of FCAS payments is on NEM wide basis) and published once per day for each of the half hour periods in the previous trading day.
For example, for the Regulation Lower FCAS service, the system volume weighted average price for a half hour period would be equal to the NEM wide procurement costs for Regulation Lower FCAS for a half hour period divided by the total enabled volume for the corresponding half hour period.
- Current files - 2 month rolling window
- Archive files - currently no archive available
Legacy Dispatch - filename: public_dispatch_*_legacy.csv (approx. size 45Kb)
This file contains public 5 minute dispatch data by region. Data covers interconnector flows, constraints, regional reference price, demand, dispatchable generation, dispatchable load, and ancillary services data. Note this is a legacy file format that has been replaced by the new dispatch format. The legacy format will not be extended to include market developments and it is AEMO's intention to discontinue the production of this file format at sometime in the future. (Please see note)
Legacy Predispatch - filename: public_predispatch_*_legacy.csv (approx. size 5Mb)
This file contains 30 minute predispatch (forecast) data by region to the end of the next market day, and is updated half hourly. Data covers forecast interconnector flows, constraints, regional reference price, demand, dispatchable generation, dispatchable load, and ancillary services data. Note this is a legacy file format that has been replaced by the new predispatch format. The legacy format will not be extended to include market developments and it is AEMO's intention to discontinue the production of this file format at sometime in the future. (Please see note)
Pre-administered Dispatch Prices
This file is generated for each dispatch interval. It contains dispatch prices before applying Administered Price Cap (APC)/Administered Floor Price (AFP). The data in this file is not supported by the MMS Data Model.
Cumulative Pre-administered Prices
This file is generated for each trading interval. It contains sum of trading prices before applying Administered Price Cap (APC)/Administered Floor Price (AFP) in the previous 336 trading intervals (ie. 7 days). The data in this file is not supported by the MMS Data Model.
Medium Term PASA Region Availability – filename: public_mtpasaregionavailability_*.csv (approx. size 0.4Mb)
This report file contains, for each region and each day over the current MT PASA run timeframe (next 104 weeks, starting Sunday):
- the region-aggregate offered MT PASA Availability for all scheduled generating units registered on that day; and
- the latest date time an MT PASA offer was submitted for any scheduled generating unit for that region and day
The aggregated data is derived solely from the MT PASA offers provided by Scheduled Generators under clause 3.7.2 (d)(1) of the National Electricity Rules. If no MT PASA offer exists for a particular week, the aggregation calculation uses the latest MT PASA offer from the previous week.
The report is updated at 0900, 1200, 1500 and 1800 hrs EST each day (excluding Sundays), and published around 18 minutes later.
The report will assist Scheduled Generators in meeting their obligations under the insider trading provisions of the Commonwealth Corporations Act 1989, by allowing them to provide timely disclosure of the implications of their generation outage plans prior to seeking financial cover through securities dealings.
Note:
The National Electricity Market registration classifications of Anglesea Power Station Unit 1 (dispatchable unit ID: APS) and Yarwun Power Station Unit1 (dispatchable unit ID: YARWUN_1) are market non-scheduled generating units. However, it is a condition of the registration of these units that the Registered Participants comply with some of the obligations of a Scheduled Generator. Both units are dispatched as scheduled generating units with respect to their dispatch offers, targets and generation outputs. Accordingly, information about APS and YARWUN_1 is reported as scheduled generating units information.
The Tumut 3 Pumps (dispatchable unit ID: SNOWYP) are not classified as scheduled load in the National Electricity Market. However, they are required to comply with some of the obligations of a Market Customer in respect of a scheduled load. The Tumut 3 Pumps are dispatched as if they were scheduled loads with respect to their dispatch bids, targets and consumption. Accordingly, information about SNOWYP is reported as market scheduled load information.
Disclaimer
This data is provided for information only and is not intended for commercial use. AEMO does not guarantee the accuracy of the data or its availability at all times.
