Australia Merchant Electricity Prices

This page contains databases for the Australia Merchant Markets. The Australia merchant prices are shown in the files below.  There are separate Australia merchant electricity price files for the different regions of Australia. The set of Australia merchant power files have techniques to put the data together from separate files listed on the Australia merchant price websites. The summary databases that can be supplemented on a month by month basis.

Queensland Hourly Database.xlsx
Read Source Data.xlsm
New South Wales Hourly Database.xlsx
Australia Internet Links.xlsx
Read All Australia.xlsm

How you can Update the Australia Merchant Price Databases by Yourself

There are two websites for the Australia market that are listed below. Both the websites are transparent and provide a lot of data. You can even get hourly prices along with the demand levels for five regions of Australia — New South Wales, Southern Australia, Queensland and Victoria. It is painful to download the separate monthly files with history, but the good news is that once you have done this, you don’t have to do it again.

I have used a macro that allows you to put all files in a directory together in a single file. Then you can use the INDIRECT function to get all of the prices into a comprehensive database. The different files below demonstrate how to put the data together and evaluate the price spikes.

Lessons from Studying the History of Australia Market Prices

The Australia market is interesting as it has no capacity prices and allows price spikes. You can therefore use the markets in Australia to evaluate allowing price caps relative to attempting to make a separate capacity market (that requires some regulations) along with price caps on energy prices.