Back to Blog

If you only had one excel sheet

Archived blog post. This blog post has been transferred from our previous blogging platform. Links and images may not work as intended.

Starting as a power analyst almost 20 years ago, I dreamt of a source that would present all the data I ever wanted, in a standardised format, in the desired resolution and wanted lead time, and for all individual price areas in Europe.

Little did I know that I would have to build this myself.

EQ Excel Integrator (early version)
The first version of EQ Excel Integrator.

Introducing the EQ Excel Integrator

So, together with my colleagues at Energy Quantified, I have put together such a tool. The EQ Excel Integrator allows you to access our complete database. It is perfect for data mining, model building, prototyping and daily analysis.

That said, the world has moved on since 1999. I would probably not advise professionals to build their business based on Excel spreadsheets. It is perhaps more efficient to hook up to the EQ database via the well-documented API.

However, before you do that, I suggest you explore our database using the Excel tool. It is quick and convenient.

Numbers count

Imagine you want to make an update on, say Serbia (although it could be any price area or individual variable). A search for “Serbia” in the Excel Integrator returns all available variables we currently produce for Serbia.

You may of course choose whatever resolution you prefer, from our intra-hour model resolution to hourly, daily or even weekly.

A simply click on “Get Data”, and a clean, neat data matrix is presented. Now you can investigate historic data as well as forecasts, weather and fundamentals for Serbia (price forecasts will come soon).

And it is quick to implement. It should not take more than a few minutes to get the numbers you need.

Get the EQ Excel Integrator today

Head over to www.energyquantified.com, grab your early access account, and you will be able download the Excel file from our platform.

And feel free to drop me an email at hugo@energyquantified.com if you have any questions.

Share on social media: 

More from the Blog

Improve your ML with EQ

Hugo Birkelund

Machine learning (ML) and artificial intelligence (AI) present some fascinating modeling approaches. However, even with ML and hyper-fast computing, the old saying "garbage in, garbage out" or simply GIGO holds true.

Read Story

What's the price effect of Cobra?

Hugo Birkelund

The 700 MW Cobra cable, connecting the Netherlands and DK1 (Jylland) is scheduled to start commercial operation on Monday. In this short blog, we investigate the effects it will have on the price formation.

Read Story

Happy birthday 2019

Hugo Birkelund

This week we celebrate our 2nd anniversary as Energy Quantified or simply “EQ” – a Montel company. Two years on, we provide “all you need to be in power” for all price areas in Europe.

Read Story

SEE hydrology and an exciting August?

Eylert Ellefsen

August can become an exciting month for traders in the SEE region. Recent precipitation forecasts have remained very dry. If these continue, there will be a further reduction in hydropower production and an additional upward pressure on spot-prices in the SEE-region. This is the conclusion gleaned from EQ’s new Pan European hydro model, which will be launched soon.

Read Story

Large differences in Alpine hydro balances

Eylert Ellefsen

EQ's new hydrology models indicate that we enter August with large differences in hydrological balance across the Alpine area. Switzerland and Austria now have reservoir fillings of, respectively, 12% and 8% above their seasonal normal, whereas France and Italy are on their seasonal normal. High snow reservoirs and delayed melting during the spring, was followed by a heatwave end of June and start of July. This sparked melting, which in turn led to high inflow levels and ultimately rapidly increasing hydro reservoir levels in Switzerland and Austria.

Read Story

River temperatures, we can have you covered

Hugo Birkelund

As rising river temperatures may affect the output at thermal power plants due to cooling water restrictions, we invite you to suggest a river location for which we can provide forecasts and historical data.

Read Story

Can it rain from the ground up?

Eylert Ellefsen

Of course not! However, during the last seven days of June 3,5 TWh worth of hydropower resources simply vanished in thin air in the CWE area. That is what our new model for energy precipitation in Germany, France, Austria, Switzerland and Italy, tells us.

Read Story

Precipitation energy SEE area

Eylert Ellefsen

As part of our ongoing hydrology project, EQ now provides energy precipitation forecasts, seasonal norms and historical data for countries in South-East Europe, covering around 50 TWh of annual hydropower production – or nearly 30% of total power supply in the region.

Read Story

REMIT untangled

Hugo Birkelund

How do REMIT messages stack up? Energy Quantified (EQ) now provides quantified REMIT and UMM messages for all your areas. A notoriously complicated, but important data feed is boiled down to easy-to-handle numeric time series.

Read Story

Mr Hydrology joins EQ

Hugo Birkelund

We are pleased to announce that Eylert Ellefsen joins Energy Quantified (EQ) as a senior analyst. Many will recognise Eylert as the person who pioneered the development of hydro models in Europe.

Read Story

Never miss a minute.

Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa.
We will never share your email address with third parties.