Tag Archives: Data Center

New Consumption model in Germany

On Friday 23 January, we aim to update our historic data and implement a new consumption model in Germany.

Background

Power load in Germany is an elusive variable . Not because one lacks sources but because of poor updates and internally inconsistent sources. This could be e.g. hourly numbers not summing up to aggregates over months or years, or summing up individual TSOs to national numbers. Another known issue is that they do not meet simple econometrical criteria one would expect from such data, e.g. sign of derivatives etc.

Continue reading New Consumption model in Germany

Price and Flow in same file

MKonline supports data files from its InstantSpot model with forecasts of both power price and  power flow to all adjoining markets each 15 minute. See here for details.

The naming, updating and rolling over of alternative forecast may seem complicated. If you are only interested in the latest forecast you find this positioned to the far left in file.

Updating of the files

The InstantSpot model is simulated more or less each 15 minutes as input arrives over the day. At the same time both the web and the files in the DataCenter are updated too. The following figure illustrates the connection between arrival and updating of the weather and fundamentals forecasts, (W2F), the IS model, and the rotation of the files in the DataCenter.

W2F and IS update_1

Format of the files

We supports 6 alternative forecasts for each individual price area. The latest two alternative forecasts are always positioned to  the left. The naming of the alternatives follows the naming convention used on the the ECMWF weather forecast, Eg. EC00Det, EC00Ens, etc. In addition to this we have a separate forecast, issued after the arrival of the actual spot. We have coined this PostFix, and amend PF in the naming to indicate this.

Note that for each forecast alternative, there are several columns depending on how many borders a country exchanges power with.

Rotating time and names of the alternative price-flow forecasts

Rotating Latest forecasts Second last forecasts Third last forecasts
00:00 – 06:40 EC12Det Y’d EC12Ens Y’d EC00Det PF Y’d EC00Ens PF Y’d EC00Det Y’d EC00Ens PF Y’d
6:41 – 15:00 EC00Det 6:41 EC00Ens 8:40 EC12Det Y’d EC12Ens Y’d EC00Det PF Y’d EC00Ens PF Y’d
15:00 – 18:40 EC00Det PF 15:00 EC00Ens PF 15:00 EC00Det ≈12:00 EC00Ens ≈12:00 EC12Det Y’d EC12Ens Y’d
18:40 – 00:00 EC12Det 18:40 EC12Ens 20:40 EC00DetPF ≈18:40 EC00EnsPF ≈18:40 EC00Det ≈12:00 EC00Ens ≈12:00

Y’d indicates files generated yesterday. Time stamps, in column 2 and 3, e.g. 8:41 CET, indicates when we start to update the file in question. Time stamp in the 4 last columns e.g. 12:00 CET indicates last update time for the file in question. PF is an abbreviation for the PostFix update. PostFix indicates the forecast alternative we offer after spot has arrived.

Step by step procedure

06:40 CET            The EC00 deterministic W2F forecast start to come in. IS EC00Det starts running and is rotated together with EC00Ens to the left in the Data Center Files. EC00Ens columns are empty.

08:00 CET             The EC00Det W2F forecast is complete. The IS EC00Det continues to update as more information about exchange etc. are updated.

08:40 CET             The EC00Ens W2F forecast start to come in. IS EC00Ens starts running and the EC00Ens columns in the Data Center fill up.

10:00 CET             The EC00Ens W2F forecast is complete. IS EC00Det and IS EC00Ens continue running.

12:00 CE(S)T       Deadline for spot nominations. IS EC00Det and IS EC00Ens stop running and the final time stamp is just before noon.

12-15 CET(S)       Break for the Instant Spot. Our analysts update some of the input to the model.

15:00 CET(S)T     IS EC00Det and Ens Postfix start running. Both forecasts are rotated to the left in the Data Center files.

18:40 CET             The EC12 deterministic weather forecast start to come in. IS EC12Det start running and is rotated together with EC12Ens to the left in the Data Center Files. EC12Ens columns are empty.

20:00 CET             The EC12Det weather forecast is complete. The IS EC12Det continues to update as more information about exchange etc. are updated.

20:40 CET             The EC12Ens W2F forecast start to come in. IS EC12Ens starts running and the EC12Ens columns in the Data Center fill up.

22:00 CET             The EC12Ens W2F forecast is complete. IS EC12Det and IS EC12Ens continue running.

00:00 CET(S)T     The Data Center files are republished with the same data as before, but we amend Y to the names to indicate that the forecasts are issued “Yesterday”.