Bringing electricity information from eloverblik.dk and energidataservice.dk into Openhab

somy · May 26, 2023, 3:03pm

There is something I don’t get - based on the log file (below) it looks like I already got the prices at 15:00. This is the time when the item HourlyPrice is updated

2023-05-26 15:00:00.449 [INFO ] [.core.model.script.EnergiDataService] - Tomorrow electricity price: 
	00-06: 1.15kr/kWh
	06-12: 0.92kr/kWh
	12-17: 0.43kr/kWh
	17-21: 1.74kr/kWh
	21-00: 1.39kr/kWh

However based on events log, I don’t receive any price until 15:22:

2023-05-26 15:00:00.005 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'HourlyPrices' changed from [{"hourStart":"2023-05-26T00:00:00Z","spotPrice":0.45048999,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T01:00:00Z","spotPrice":0.030469999,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T02:00:00Z","spotPrice":0.012000,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T03:00:00Z","spotPrice":0.164289993,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T04:00:00Z","spotPrice":0.763130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T05:00:00Z","spotPrice":0.767900024,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T06:00:00Z","spotPrice":0.707840027,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T07:00:00Z","spotPrice":0.558080017,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T08:00:00Z","spotPrice":0.287160004,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T09:00:00Z","spotPrice":0.029950001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T10:00:00Z","spotPrice":0.030170,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T11:00:00Z","spotPrice":0.007230,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T12:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T13:00:00Z","spotPrice":0.000520,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T14:00:00Z","spotPrice":0.070180,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T15:00:00Z","spotPrice":0.321250,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T16:00:00Z","spotPrice":0.602710022,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T17:00:00Z","spotPrice":0.620289978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T18:00:00Z","spotPrice":0.84073999,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T19:00:00Z","spotPrice":0.81951001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T20:00:00Z","spotPrice":0.741280029,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T21:00:00Z","spotPrice":0.689130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}] to [{"hourStart":"2023-05-26T01:00:00Z","spotPrice":0.030469999,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T02:00:00Z","spotPrice":0.012000,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T03:00:00Z","spotPrice":0.164289993,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T04:00:00Z","spotPrice":0.763130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T05:00:00Z","spotPrice":0.767900024,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T06:00:00Z","spotPrice":0.707840027,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T07:00:00Z","spotPrice":0.558080017,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T08:00:00Z","spotPrice":0.287160004,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T09:00:00Z","spotPrice":0.029950001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T10:00:00Z","spotPrice":0.030170,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T11:00:00Z","spotPrice":0.007230,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T12:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T13:00:00Z","spotPrice":0.000520,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T14:00:00Z","spotPrice":0.070180,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T15:00:00Z","spotPrice":0.321250,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T16:00:00Z","spotPrice":0.602710022,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T17:00:00Z","spotPrice":0.620289978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T18:00:00Z","spotPrice":0.84073999,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T19:00:00Z","spotPrice":0.81951001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T20:00:00Z","spotPrice":0.741280029,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T21:00:00Z","spotPrice":0.689130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}]
2023-05-26 15:22:27.687 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'HourlyPrices' changed from [{"hourStart":"2023-05-26T01:00:00Z","spotPrice":0.030469999,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T02:00:00Z","spotPrice":0.012000,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T03:00:00Z","spotPrice":0.164289993,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T04:00:00Z","spotPrice":0.763130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T05:00:00Z","spotPrice":0.767900024,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T06:00:00Z","spotPrice":0.707840027,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T07:00:00Z","spotPrice":0.558080017,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T08:00:00Z","spotPrice":0.287160004,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T09:00:00Z","spotPrice":0.029950001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T10:00:00Z","spotPrice":0.030170,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T11:00:00Z","spotPrice":0.007230,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T12:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T13:00:00Z","spotPrice":0.000520,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T14:00:00Z","spotPrice":0.070180,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T15:00:00Z","spotPrice":0.321250,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T16:00:00Z","spotPrice":0.602710022,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T17:00:00Z","spotPrice":0.620289978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T18:00:00Z","spotPrice":0.84073999,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T19:00:00Z","spotPrice":0.81951001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T20:00:00Z","spotPrice":0.741280029,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T21:00:00Z","spotPrice":0.689130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}] to [{"hourStart":"2023-05-26T01:00:00Z","spotPrice":0.030469999,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T02:00:00Z","spotPrice":0.012000,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T03:00:00Z","spotPrice":0.164289993,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T04:00:00Z","spotPrice":0.763130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T05:00:00Z","spotPrice":0.767900024,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T06:00:00Z","spotPrice":0.707840027,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T07:00:00Z","spotPrice":0.558080017,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T08:00:00Z","spotPrice":0.287160004,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T09:00:00Z","spotPrice":0.029950001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T10:00:00Z","spotPrice":0.030170,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T11:00:00Z","spotPrice":0.007230,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T12:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T13:00:00Z","spotPrice":0.000520,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T14:00:00Z","spotPrice":0.070180,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T15:00:00Z","spotPrice":0.321250,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T16:00:00Z","spotPrice":0.602710022,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T17:00:00Z","spotPrice":0.620289978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T18:00:00Z","spotPrice":0.84073999,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T19:00:00Z","spotPrice":0.81951001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T20:00:00Z","spotPrice":0.741280029,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T21:00:00Z","spotPrice":0.689130005,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T22:00:00Z","spotPrice":0.668090027,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-26T23:00:00Z","spotPrice":0.622210022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T00:00:00Z","spotPrice":0.631150024,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T01:00:00Z","spotPrice":0.643059998,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T02:00:00Z","spotPrice":0.679710022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T03:00:00Z","spotPrice":0.670400024,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T04:00:00Z","spotPrice":0.61602002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T05:00:00Z","spotPrice":0.618190002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T06:00:00Z","spotPrice":0.540869995,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T07:00:00Z","spotPrice":0.410140015,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T08:00:00Z","spotPrice":0.121639999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T09:00:00Z","spotPrice":0.011020,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T10:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T11:00:00Z","spotPrice":-0.017209999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T12:00:00Z","spotPrice":-0.014530,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T13:00:00Z","spotPrice":0.002980,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T14:00:00Z","spotPrice":0.016830,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T15:00:00Z","spotPrice":0.410290009,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T16:00:00Z","spotPrice":0.632039978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T17:00:00Z","spotPrice":0.747719971,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T18:00:00Z","spotPrice":0.930590027,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T19:00:00Z","spotPrice":0.842320007,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T20:00:00Z","spotPrice":0.745109985,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T21:00:00Z","spotPrice":0.70548999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}]

The only explanation I have is:

The binding already got the prices for tomorrow some time between 14-15, and it cached them.
At 15:00 the binding updated the HourlyPrices to next hour, but for some reason it didn’t include prices for tomorrow (not sure why).
My rule was triggered when HourlyPrices changed at 15:00 (2). It used the action “var priceMap = actions.getPrices(null)” which got the prices from the cache
At 15:22 the binding updated HourlyPrices for tomorrow

If my above assumption is right: the binding seemed to know prices for tomorrow already at 15:00 (or before), however it didn’t update HourlyPrices until 15:22. Ideally I’d hope the binding update HourlyPrices immediately when it receives new prices for tomorrow.

laursen · May 26, 2023, 6:56pm

The logs you posted are pretty clear: You received spot prices at 15:22.

I checked my logs also, and it’s similar, just 15:52:

2023-05-26 13:00:02.588 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'EnergiDataService_HourlyPrices' changed from [...] to [{"hourStart":"2023-05-25T23:00:00Z",[...]{"hourStart":"2023-05-26T21:00:00Z",[...]
2023-05-26 13:00:49.564 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'EnergiDataService_HourlyPrices' changed from [...] to [{"hourStart":"2023-05-25T23:00:00Z",[...]{"hourStart":"2023-05-26T21:00:00Z",[...]
2023-05-26 14:00:00.044 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'EnergiDataService_HourlyPrices' changed from [...] to [{"hourStart":"2023-05-26T00:00:00Z",[...]{"hourStart":"2023-05-26T21:00:00Z",[...]
2023-05-26 15:00:01.495 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'EnergiDataService_HourlyPrices' changed from [...] to [{"hourStart":"2023-05-26T01:00:00Z",[...]{"hourStart":"2023-05-26T21:00:00Z",[...]
2023-05-26 15:52:03.843 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'EnergiDataService_HourlyPrices' changed from [...] to [{"hourStart":"2023-05-26T01:00:00Z",[...]{"hourStart":"2023-05-27T21:00:00Z",[...]

The only unexpected thing in my logs is that the channel was updated 13:00:49 after failing to receive next day’s spot prices. I checked differences and found new slightly changed spot prices:

{"hourStart":"2023-05-26T14:00:00Z","spotPrice":0.070190002 (from)
{"hourStart":"2023-05-26T14:00:00Z","spotPrice":0.070180 (to)
{"hourStart":"2023-05-26T15:00:00Z","spotPrice":0.321290009 (from)
{"hourStart":"2023-05-26T15:00:00Z","spotPrice":0.321250 (to)
etc.

I checked the payload received 25.05.2023 13:00:

{
	"total": 37,
	"filters": "{\"PriceArea\":\"DK1\"}",
	"dataset": "Elspotprices",
	"records": [
		{
			"HourUTC": "2023-05-26T21:00:00",
			"SpotPriceDKK": 689.219971
		},

and the payload received 26.05.2023 13:00:

{
	"total": 13,
	"filters": "{\"PriceArea\":\"DK1\"}",
	"dataset": "Elspotprices",
	"records": [
		{
			"HourUTC": "2023-05-26T21:00:00",
			"SpotPriceDKK": 689.130005
		},

So prices are apparently not fully settled. This is news to me, and important for the upcoming future persistence update. However, it works as expected.

What might be slightly confusing in your case is that the hourly-prices channel is based on the keys for the spot prices, so when there is no spot price for a specific hour, other prices (like net tariff) will not be included either, even is cached.

However, the action getPrices(null) will merge all cached prices, so since net tariffs were available even when spot prices were not, the calculated sums would be missing the spot price element. I consider this a bug. In case the spot price is included as element, it should be required data for each returned key.

somy · May 26, 2023, 7:20pm

Hi @laursen
Thank you for your reply and sorry to keep chasing on this. Based on my log, it seems to know the spot price (and other fees) already at 15:00:00 despite that the hourly-prices channel was updated at 15:22. I have double check the avg prices in different periods, and all results look right to me. This basically means in my case the binding must know all prices for tomorrow already at 15:00:00 if not earlier.

2023-05-26 15:00:00.449 [INFO ] [.core.model.script.EnergiDataService] - Tomorrow electricity price:
00-06: 1.15kr/kWh
06-12: 0.92kr/kWh
12-17: 0.43kr/kWh
17-21: 1.74kr/kWh
21-00: 1.39kr/kWh

BTW I can confirm I also received 2 HourlyPrices updates at 13:00 today, with around 25 seconds interval.

laursen · May 26, 2023, 7:28pm

No problem at all, one issue was already identified, and I’d rather investigate one thing too much than one thing too little - we need this to be stable and a source of truth.

To pinpoint this issue, we would need the problem to repeat itself, and you would need to provide more detailed logs. You can enable trace logging with the console command log:set trace org.openhab.binding.energidataservice. It should not spam your logs much, it will only add to the log each hour and when actually calling the service, in which case the full response payload will be logged.

laursen · May 26, 2023, 7:29pm

I think this could have something to do with changes in currency exchange rates, since we are receiving data in DKK. So most likely the spot prices are fixed, but the conversion to DKK can change over time.

This is expected. At 13:00:00 the channel will be updated due to expiration of the oldest price, and seconds later there will (usually) be new prices available, which will add new hours, so the channel will once again be updated. The unexpected thing for me today was that it was updated in a situation where the new prices actually were not received. But this is now known to be caused by slight spot price changes.

I double-checked the code, and I was mistaken. The action is also based on the spot price when this is included as element. So no bug here after all.

laursen · May 27, 2023, 11:13am

@somy - now would be a good time to enable trace logging. It was announced that upgrades at Energinet can cause instability and delayed data until tomorrow or Monday. I can also see that prices for tomorrow are not yet available.

Additionally, I have enabled hourly logging of the spot prices payload through the HTTP binding to try to find a pattern when existing prices are updated.

somy · May 27, 2023, 3:54pm

Hi @laursen

Sorry I was not at home today.
I just checked the log, and I can see similar result as yesterday. My rule was triggered at 15:00, and tmr’s prices were already known:

2023-05-27 15:00:00.404 [INFO ] [.core.model.script.EnergiDataService] - Tomorrow electricity price: 
	00-06: 1.09kr/kWh
	06-12: 0.68kr/kWh
	12-17: 0.36kr/kWh
	17-21: 1.33kr/kWh
	21-00: 1.12kr/kWh

From event log I can see HourlyPrices at 15:00 didn’t contain el price for tomorrow, and there was another update at 15:39:

2023-05-27 15:00:00.007 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'HourlyPrices' changed from [{"hourStart":"2023-05-27T00:00:00Z","spotPrice":0.631150024,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T01:00:00Z","spotPrice":0.643059998,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T02:00:00Z","spotPrice":0.679710022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T03:00:00Z","spotPrice":0.670400024,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T04:00:00Z","spotPrice":0.61602002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T05:00:00Z","spotPrice":0.618190002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T06:00:00Z","spotPrice":0.540869995,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T07:00:00Z","spotPrice":0.410140015,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T08:00:00Z","spotPrice":0.121639999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T09:00:00Z","spotPrice":0.011020,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T10:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T11:00:00Z","spotPrice":-0.017209999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T12:00:00Z","spotPrice":-0.014530,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T13:00:00Z","spotPrice":0.002980,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T14:00:00Z","spotPrice":0.016830,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T15:00:00Z","spotPrice":0.410290009,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T16:00:00Z","spotPrice":0.632039978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T17:00:00Z","spotPrice":0.747719971,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T18:00:00Z","spotPrice":0.930590027,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T19:00:00Z","spotPrice":0.842320007,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T20:00:00Z","spotPrice":0.745109985,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T21:00:00Z","spotPrice":0.70548999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}] to [{"hourStart":"2023-05-27T01:00:00Z","spotPrice":0.643059998,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T02:00:00Z","spotPrice":0.679710022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T03:00:00Z","spotPrice":0.670400024,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T04:00:00Z","spotPrice":0.61602002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T05:00:00Z","spotPrice":0.618190002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T06:00:00Z","spotPrice":0.540869995,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T07:00:00Z","spotPrice":0.410140015,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T08:00:00Z","spotPrice":0.121639999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T09:00:00Z","spotPrice":0.011020,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T10:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T11:00:00Z","spotPrice":-0.017209999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T12:00:00Z","spotPrice":-0.014530,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T13:00:00Z","spotPrice":0.002980,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T14:00:00Z","spotPrice":0.016830,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T15:00:00Z","spotPrice":0.410290009,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T16:00:00Z","spotPrice":0.632039978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T17:00:00Z","spotPrice":0.747719971,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T18:00:00Z","spotPrice":0.930590027,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T19:00:00Z","spotPrice":0.842320007,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T20:00:00Z","spotPrice":0.745109985,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T21:00:00Z","spotPrice":0.70548999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}]
2023-05-27 15:39:26.485 [INFO ] [openhab.event.ItemStateChangedEvent ] - Item 'HourlyPrices' changed from [{"hourStart":"2023-05-27T01:00:00Z","spotPrice":0.643059998,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T02:00:00Z","spotPrice":0.679710022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T03:00:00Z","spotPrice":0.670400024,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T04:00:00Z","spotPrice":0.61602002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T05:00:00Z","spotPrice":0.618190002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T06:00:00Z","spotPrice":0.540869995,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T07:00:00Z","spotPrice":0.410140015,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T08:00:00Z","spotPrice":0.121639999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T09:00:00Z","spotPrice":0.011020,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T10:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T11:00:00Z","spotPrice":-0.017209999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T12:00:00Z","spotPrice":-0.014530,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T13:00:00Z","spotPrice":0.002980,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T14:00:00Z","spotPrice":0.016830,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T15:00:00Z","spotPrice":0.410290009,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T16:00:00Z","spotPrice":0.632039978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T17:00:00Z","spotPrice":0.747719971,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T18:00:00Z","spotPrice":0.930590027,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T19:00:00Z","spotPrice":0.842320007,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T20:00:00Z","spotPrice":0.745109985,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T21:00:00Z","spotPrice":0.70548999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}] to [{"hourStart":"2023-05-27T01:00:00Z","spotPrice":0.643059998,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T02:00:00Z","spotPrice":0.679710022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T03:00:00Z","spotPrice":0.670400024,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T04:00:00Z","spotPrice":0.61602002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T05:00:00Z","spotPrice":0.618190002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T06:00:00Z","spotPrice":0.540869995,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T07:00:00Z","spotPrice":0.410140015,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T08:00:00Z","spotPrice":0.121639999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T09:00:00Z","spotPrice":0.011020,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T10:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T11:00:00Z","spotPrice":-0.017209999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T12:00:00Z","spotPrice":-0.014530,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T13:00:00Z","spotPrice":0.002980,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T14:00:00Z","spotPrice":0.016830,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T15:00:00Z","spotPrice":0.410290009,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T16:00:00Z","spotPrice":0.632039978,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T17:00:00Z","spotPrice":0.747719971,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T18:00:00Z","spotPrice":0.930590027,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T19:00:00Z","spotPrice":0.842320007,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T20:00:00Z","spotPrice":0.745109985,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T21:00:00Z","spotPrice":0.70548999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T22:00:00Z","spotPrice":0.648710022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-27T23:00:00Z","spotPrice":0.625700012,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T00:00:00Z","spotPrice":0.610200012,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T01:00:00Z","spotPrice":0.580030029,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T02:00:00Z","spotPrice":0.579960022,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T03:00:00Z","spotPrice":0.569609985,"spotPriceCurrency":"DKK","netTariff":0.150900,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T04:00:00Z","spotPrice":0.536460022,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T05:00:00Z","spotPrice":0.482980011,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T06:00:00Z","spotPrice":0.280820007,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T07:00:00Z","spotPrice":0.000000,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T08:00:00Z","spotPrice":-0.022940001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T09:00:00Z","spotPrice":-0.074930,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T10:00:00Z","spotPrice":-0.074709999,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T11:00:00Z","spotPrice":-0.073820,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T12:00:00Z","spotPrice":-0.074489998,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T13:00:00Z","spotPrice":-0.036570,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T14:00:00Z","spotPrice":-0.037540001,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T15:00:00Z","spotPrice":-0.000450,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T16:00:00Z","spotPrice":0.372440002,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T17:00:00Z","spotPrice":0.461970001,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T18:00:00Z","spotPrice":0.59597998,"spotPriceCurrency":"DKK","netTariff":0.588700,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T19:00:00Z","spotPrice":0.579809998,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T20:00:00Z","spotPrice":0.549719971,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000},{"hourStart":"2023-05-28T21:00:00Z","spotPrice":0.517690002,"spotPriceCurrency":"DKK","netTariff":0.226400,"systemTariff":0.054000,"electricityTax":0.008000,"transmissionNetTariff":0.058000}]

I didn’t have debug enabled so can’t trace more, but it looks to me like the binding somehow knew tomorrow’s el price already at 15:00, but HourlyPrices were only updated at 15:39. It would be interesting to see what triggered the change at 15:39. Do you see similar thing in your log?

laursen · May 28, 2023, 7:34am

I received prices by the HTTP binding 15:05 and by the EDS binding 15:13, but this was after an openHAB system crash/restart. I would need logs for investigation.

anon71759204 · May 28, 2023, 9:08am

AFAIK epexspot prices are fixed (one could sample the official epexspot prices over a period of a day or check the ‘last update’ timestamp on Market Data | EPEX SPOT …).

somy · July 1, 2023, 6:32pm

Sorry to hijack the discussion but I’d like to ask anybody has a solution to poll hourly/daily/monthly usage from eloverblik.dk?

katerica · July 1, 2023, 7:05pm

Hi somi

The example above does not read the meter reading but the API is the same I think : Swagger UI

Everything in there however is 3 days old. There is no real time readings. Check Jacobs blog for how to do it with a Kamstrup reader.

Cheers

somy · July 1, 2023, 7:14pm

Thanks will take a look! I don’t need real-time reading at the moment as I cannot think what I can use it for especially given the extra cost and complication to set it up. I just want to have all numbers at the same place for now

somy · August 12, 2023, 8:02am

Hi @laursen :
I have recently updated to OH 4 and start to see the below errors in my rules:

2023-08-12 09:20:58.151 [ERROR] [internal.handler.ScriptActionHandler] - Script execution of rule with UID 'EnergiDataService-1' failed: 'getPrices' is not a member of 'org.openhab.core.thing.binding.ThingActions'; line 27, column 20, length 23 in EnergiDataService

Would like to check with you if the getPrices action been removed in version 4 (it’s still in the document though)? Many thank in advance!

laursen · August 12, 2023, 8:04am

It’s still there, can you share your script?

somy · August 12, 2023, 8:06am

Edit: sorry I realised this could be related to another issue that I’m fighting with - for some reason after restarting OH 4, it doesn’t load all things configuration and I just saw the energy data service things are not even loaded.

laursen · August 12, 2023, 11:47am

Are you running your installation in Docker? In that case you might want to have a look here:

somy · August 12, 2023, 1:32pm

Indeed, looks like that’s the issue. Cause is unknown but ver deterministic, I have 117 things and restarting shows only 47 of them, I have to change and save each things configuration to make them appear, annoying. Thanks for pointing me to the discussion

somy · August 24, 2023, 3:46pm

Has anybody in Denmark use OpenHab with solar system? I’m scanning the market and try to find a smart solution, but traditional hybrid inverters are not that smart, it basically:

Take all energy from solar panels
Supply the usage
Remaning energy goes to battery
Sell the rest to grid
It would be truly nice to have a solution that is smart to know the weather forecast and el price, for example if knows tomorrow is cloudy and better to buy cheap el to charge the battery during night. Or grid price is high, sell to grid take priority and charge batter in the afternoon when price is low etc.
Any suggestion?

katerica · August 24, 2023, 4:44pm

Hi Somy,

I don’t have one myself but I have a colleague at work with one of those Chinese Grow ones and he is automating it with rs232. You should check if that is an option on yours and perhaps the Modbus or serial bindings would be an option.

Cheers

Also post the solution if you find one

somy · August 26, 2023, 9:35am

Thanks! I’m looking into Huawei inverters and so far looks like there is only way to load data from modbus but not change settings like TOU.
I think something like this for Huawei or other inverters would be great:
https://www.viasol.dk/heartbeat
Unfortunately Sonnen only has very small inverter (3,68kw).
Another project I found is:

This can potentially be implemented as OH rule (there is already EaseeHome binding).