We would like to announce some changes in the data centre data structure in the gas section. The columns of “gas flow interconnection point daily actual”, key: “GAS_FLW_INTRCON_D_A” will be changed in the next days. Continue reading Gas Analysis: Changes in Data Center
MKonline, in cooperation with Metanopoly, has updated the files in the data center in the section gas. Continue reading Gas consumption updated in data center
On Friday 23 January, we aim to update our historic data and implement a new consumption model in Germany.
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.
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.
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”.