Graph for prices?

[sx3]

Hello,

I'm looking for creating a graph that show todays electrical prices.
So the graph will always show 00.00 to 23.59, pretty static.

I have 24 groupadresses, each one contains price for 1 particular hour of the day.
1 adress for MAX
1 adress for MIN
1 adress for avarege

Would be neat if the averege price could get a line, just like the picture. But not a must!


What is the easiest way to achive this in Edomi? Is there a LBS I can use?


graph.png

[jonofe]

You should write the 24 GAs to an EDOMI data archive with corresponding timestamp. If the values are updated according to their validity (i.e. 3pm GA is updated at 3pm), it's quite easy, because you can always use the current timestamp. If you get all 24 GA values at the same time, you have to find a way how to set the correct timestamp in the data archive. Maybe there is a LBS in the DL portal to achieve that.

Also the Average value can be written to a separate data archive with timestamp 00:00:00 and 23:59:59.

If you have these two data archives in place, you can create a diagram which could be very similar to what you show in your post.

[sx3]

Thank jonofe,
I'm fetching all prices at once at 00.01 for the upcoming day so I would need to manipulate the timestamp.
I've looked in the DL section bur have'nt yet found any propriate LBS. Everything is in German, so I might have missed something.

One idea would be using Grafana, but then I would need to setup another server I guess? I don't like having many servers up running at same time because how expensive electricity is nowadays.

[sx3]

Anyone using InFluxDB/Grafana? Would it be possible to manipulate the timestamp? So that I forcast upcoming 24 hours?

[McJameson]

Yes, in InfluxDB you can set the timestamp to anything you want.
I am not sure though, why you need 24 different GA/KOs to display the data of one day in one graph? The easiest way, as Jonofe already mentioned, would be to write the data into an Edomi archive with the respective time stamp to it. What source are you actually pulling the data from?

[jonofe]

I've looked in the DL section bur have'nt yet found any propriate LBS.

You should check the LBS 19000348. It seems, you can insert values via E5/E6 to a given data archive (E1).