This page shows how you can get some data on German merchant electricity prices. You can then compare the German merchant prices to European natural gas prices and gain some understanding of the market. German merchant prices are collected on a quarterly rather than an hourly basis and European gas prices are extracted from the World Bank Pink data sheet. I went to the German electricity market called eex.com to download german electricity merchant prices and I discovered that I have to pay for the data!!! Of course I could not do this. I have rambled on about this at the bottom of this page.
Anyway, you can at least download quarterly data on German merchant prices which is ok for the kind of analysis that I often use to discuss merchant prices. The quarterly merchant electricty price analysis shows some interesting trends in spark spreads and in implied heat rates. So, I put the German price together with natural gas prices from the World Bank and with Exchange Rates from the FRED database. Once you do this you can quickly update all of the data by pressing a couple of buttons. A summary of the graph that is produced from the file is shown below (This can be updated as explained below). The graph demonstrates that, like so many other markets, there is a strong correlation between electricity prices and natural gas prices. Further, the graph shows that there was a long period of low electricity prices relative to natural gas prices starting in 2011.
Retrieve German Prices.xls
Updating the German Merchant Price Data by Yourself
You can download the file below and it should all work. The link for the free data (that is sometimes updated) and the general link is shown below:
When you open the file, you should see a page like this. When you press the Read All button, the macro should go to three websites to read data for the electricity prices, gas prices and the exchange rates.