Electricity stock prices
AnyViz offers several external data sources. In addition to weather data and user-defined APIs, spot prices on the electricity market can be retrieved and used in the AnyViz. The data can be configured for display and recording or transferred to a PLC controller.
The electricity prices are available in Euro/MWh as hourly values for the current and the following day. For more details see Description of the data.
When adding the data source, only the corresponding zone must be selected:
Description of the data
The electricity prices are available in groupings. Each grouping contains the prices in Euro/MWh,
the respective average price PriceAVG, as well as the minimum and maximum price PriceMIN and PriceMAX.
fromNow
In fromNow the electricity prices are mapped starting from the current hour. The array Prices contains
up to 34 values, where fromNow.Prices[0] contains the price of the current hour and fromNow.Prices[33] contains
the price in 33 hours (if available). Prices are updated at each change of hour.
todayCET
The grouping todayCET contains the prices of the current day from 00:00 to 24:00 Central European Time.
The array Prices always contains 24 values. For example, to get the price from 14:00, the value
todayCET.Prices[14] must be read.
tomorrowCET
As soon as the spot prices of the following day are available, they are provided under tomorrowCET.
As with todayCET, the prices are displayed in the CET time zone. Usually, the prices for the following day are available from 14:00 CET.
Daylight saving time
On the day of the changeover to daylight saving time, the 02:00 value is not present. Instead, the value NaN is written.
At the changeover to winter time, the mean value of both 02:00 o'clock values is calculated and written in Prices[2].
The grouping fromNow is not affected by this problem.
NaN values
In some constellations, not all prices are available. For example, if the spot prices for the following day are not yet available. To indicate to the PLC and the user that the price information is currently not available, the floating-point value NaN is written. This imaginary number serves as a placeholder until the respective price information is available.
Caution: Every mathematical operation with NaN leads to the result NaN. Therefore, a check for a valid number should always be performed during further processing of the price information.