How to display historic Time-of-Use-Tariff prices in OpenEMS or InfluxDB?

We are using the ENTSO-E Time-of-Use-Tariff component which provides the current price in the channel _sum/GridBuyPrice. For debugging reasons I’d now like to display the historic prices. As I couldn’t find a possibility inside OpenEMS, I was trying to get it from the influxDB. But there I did not find th right field:

Can someone help me how to get/display the historical values?

Have you checked that the channel really holds a value? What is your persistentPriority configuration in the influxdb component?

If the persistence priority is set to low the values are written into the InfluxDB.

Here are my historic prices from the channel _sum/GridBuyPrice:

very low

I assume that very low includes low, doesn’t it?
Can you post the query you used in influxdb? With above posted approach I did not find it.

Try a much higher value for the cycles. maybe 1 is too short for very low priority, since there are many values that are written to the InfluxDB.

Stupid me, human error. I was looking at the test-system (and not productive system). There I had disabled the component earlier. Thus no data… :expressionless: Looking at the productive installation, I can see data (with cycle of 1).

No I got a follow-up question. :smiley: Where do I see the future prices? The upcoming prices of the next 1 - 3 days are known, but the table seems to only show the historic prices until now.

OpenEMS takes a snapshot of all channel values and stores them in influxdb. The future prices are not stored in a channel, so they are not written to influxdb. Currently they are only available in memory.

You can theoreticly fetch them via a jsonrpc request and store them somewhere yourself.

Maybe I misunderstand it. To me it seems to make sense to store them in a channel as well, to e.g. display them on the dashboard and to use them for controller.