Chart with future energyprices

[ubfssF]

I am a happy user of Dashticz and want to display in a chart the energyprices for the coming 24 hours. This makes it easier to decide to what time the timer of the dishwasher and other systems should be set to. I am working on a Python script and have the prices already in a list. The question is how to get it displayed in Dashticz in a chart form.
I have read elsewhere that only a text device in Domoticz can handle this kind of data. Can this be used in Dashticz? Or is there a way to display a graph by bypassing Domoticz?

[jake]

Search for entsoe on the forum and find a working script for pulling in the future prices in Europe

[willemd]

Search for entsoe on the forum and find a working script for pulling in the future prices in Europe

Yes, I wrote that script to load the prices (onto historic variables) and use them for energy cost calculation, but I also found there is not a good device in domoticz to load the prices onto and then display a graph of those future prices (since the only device that allows such loading does not handle negative values. The test result is in the same thread). Currently the script only loads the price onto a custom device and displays the graph after the facts, also in dashticz.

I have now developed a python program to load the prices and create a planning to optimise battery charging/discharging. I will publish that in a separate thread soon (or on github, need to set up an account). I will also integrate that program into domoticz so it also takes into account any surplus solar electricity production as well as actual electricity usage and then re-plans the charging/discharging for the rest of the known period.

[ubfssF]

Search for entsoe on the forum and find a working script for pulling in the future prices in Europe

Yes, I wrote that script to load the prices (onto historic variables) and use them for energy cost calculation, but I also found there is not a good device in domoticz to load the prices onto and then display a graph of those future prices (since the only device that allows such loading does not handle negative values. The test result is in the same thread). Currently the script only loads the price onto a custom device and displays the graph after the facts, also in dashticz.

I have now developed a python program to load the prices and create a planning to optimise battery charging/discharging. I will publish that in a separate thread soon (or on github, need to set up an account). I will also integrate that program into domoticz so it also takes into account any surplus solar electricity production as well as actual electricity usage and then re-plans the charging/discharging for the rest of the known period.

Someone has made a python script already for charging a Tesla vehicle on the cheapest hours: https://github.com/smokkelaar/CarCharge ... rrentRates. It is based on Energyzero and Entsoe as a backup provider. I have used that code partly.
@willemd, I just found your code elsewhere on this forum, thanks!

[Lokonli]

I am a happy user of Dashticz and want to display in a chart the energyprices for the coming 24 hours. This makes it easier to decide to what time the timer of the dishwasher and other systems should be set to. I am working on a Python script and have the prices already in a list. The question is how to get it displayed in Dashticz in a chart form.
I have read elsewhere that only a text device in Domoticz can handle this kind of data. Can this be used in Dashticz? Or is there a way to display a graph by bypassing Domoticz?

I'm thinking of making something like that.

I can make a custom component that will display a graph based on data it obtains via a Domoticz text device or Domoticz variable (in JSON format).

I can also make something without using Domoticz by implementing it directly within Dashticz, but if you want to automate some things, probably it's better to use Domoticz as 'single source of truth'

[willemd]

I am a happy user of Dashticz and want to display in a chart the energyprices for the coming 24 hours. This makes it easier to decide to what time the timer of the dishwasher and other systems should be set to. I am working on a Python script and have the prices already in a list. The question is how to get it displayed in Dashticz in a chart form.
I have read elsewhere that only a text device in Domoticz can handle this kind of data. Can this be used in Dashticz? Or is there a way to display a graph by bypassing Domoticz?

I'm thinking of making something like that.

I can make a custom component that will display a graph based on data it obtains via a Domoticz text device or Domoticz variable (in JSON format).

I can also make something without using Domoticz by implementing it directly within Dashticz, but if you want to automate some things, probably it's better to use Domoticz as 'single source of truth'

That would be great. I am nearly finished with integration of price loading and battery planning into the Domoticz environment, for simulation purposes, and will update my github environment soon. I am now using a text device to display the created planning but could easily also use a text device for loading the prices onto, in separate log lines. Each line could for example contain date, time/hour, price.

I am using JSON commands to interact with the domoticz devices and database. This has its limitations, especially for negative values but it does make it database structure independent. Direct SQL commands in the program would be more powerful but I think it is better to follow the logic of Domoticz itself and therefore use JSON. This then rules out the use of counters or other devices, since it is impossible to load those negative prices.

[ressof]

I have used a counter to update with prices ahead of time from nordpool and I think this works good enough. I dont care about negative prices.
But when I display this counter on dashticz with filter 48 hours I get 48 hours from now and dashticz adds the data ahead of time. So when the time is 14:30 I get 48 + 9 values shown in the chart.
Is there any way to fix this?

[Lokonli]

So in fact you want to see the data of today and tomorrow I guess?
I can add a custom filter for that.

[ressof]

So in fact you want to see the data of today and tomorrow I guess?
I can add a custom filter for that.

That would be awesome.

[nfuse]

i wrote a little python script with selectable charge hours for 24h dynamic prices for tibber my idea was to charge my 16 kw battery for a given set of "cheapest" hours (selectable from 1 to 9 hours) the script then communicates with the http api for domoticz

more info and script here: https://github.com/me-processware/tibberchargescript





the price info and reallive data of the first 3 dials is from https://github.com/flopp999/Tibber-Domoticz

[heggink]

What battery do you have?

[nfuse]

i build my own with these parts: costs around 4500 euro's with the solar panels

Easun Revo II 5.5kw off-grid converter (victron is better but expensive)
16 x 3,2v 320Ah Catl Lifepo4 cells
1 x JK bms B2A24S20P
1 x Victron smart Shunt 500Ah
1 x 125Ah 48v fuse (autorecovery
2 x sonoff pow elite 20A flashed with tasmota
12 x 395w Trina solar panel

[Lokonli]

So in fact you want to see the data of today and tomorrow I guess?
I can add a custom filter for that.

That would be awesome.

To the latest beta I've added a custom filter value 'todaytomorrow'.

In your custom data block for a graph add:

Code: Select all

   filter:'todaytomorrow'

This will filter out the graph data of today and tomorrow.

Can you test?
(update Dashticz with 'git pull', while using the beta branch)

[ressof]

To the latest beta I've added a custom filter value 'todaytomorrow'.

In your custom data block for a graph add:

Code: Select all

   filter:'todaytomorrow'

This will filter out the graph data of today and tomorrow.

Can you test?
(update Dashticz with 'git pull', while using the beta branch)

Sorry for late answer, been on a small vacation

I have tested it now and it works. But it would be nice to have an option to show the 48 recent values all the time.
Because the new prices comes around 14:00 and between 00:00 and 14:00 the chart only shows 24 values with the todaytomorrow filter. If we can show latest 48 values the chart will be the same size all the time. Could this be done?

[heggink]

i build my own with these parts: costs around 4500 euro's with the solar panels

Easun Revo II 5.5kw off-grid converter (victron is better but expensive)
16 x 3,2v 320Ah Catl Lifepo4 cells
1 x JK bms B2A24S20P
1 x Victron smart Shunt 500Ah
1 x 125Ah 48v fuse (autorecovery
2 x sonoff pow elite 20A flashed with tasmota
12 x 395w Trina solar panel

WOW, nice! Could I ask how much you spent on that? Interested to understand the price differential compared to a commercial model.