Chart with future energyprices

Dashticz, alternative dashboard based on HTML, CSS, jQuery

Moderators: leecollings, htilburgs, robgeerts

Post Reply
ubfssF
Posts: 59
Joined: Monday 02 November 2015 14:12
Target OS: Linux
Domoticz version: 2.2364
Location: Netherlands
Contact:

Chart with future energyprices

Post by 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
Posts: 742
Joined: Saturday 30 May 2015 22:40
Target OS: Raspberry Pi / ODroid
Domoticz version: beta
Contact:

Re: Chart with future energyprices

Post by jake »

Search for entsoe on the forum and find a working script for pulling in the future prices in Europe
willemd
Posts: 621
Joined: Saturday 21 September 2019 17:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2024.1
Location: The Netherlands
Contact:

Re: Chart with future energyprices

Post by willemd »

jake wrote: Sunday 08 January 2023 9:28 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
Posts: 59
Joined: Monday 02 November 2015 14:12
Target OS: Linux
Domoticz version: 2.2364
Location: Netherlands
Contact:

Re: Chart with future energyprices

Post by ubfssF »

willemd wrote: Sunday 08 January 2023 9:54
jake wrote: Sunday 08 January 2023 9:28 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
Posts: 2260
Joined: Monday 29 August 2016 22:40
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Chart with future energyprices

Post by Lokonli »

ubfssF wrote: Saturday 07 January 2023 23:06 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
Posts: 621
Joined: Saturday 21 September 2019 17:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2024.1
Location: The Netherlands
Contact:

Re: Chart with future energyprices

Post by willemd »

Lokonli wrote: Saturday 14 January 2023 16:22
ubfssF wrote: Saturday 07 January 2023 23:06 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
Posts: 60
Joined: Thursday 20 April 2017 7:20
Target OS: Linux
Domoticz version: Latest
Contact:

Re: Chart with future energyprices

Post by 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
Posts: 2260
Joined: Monday 29 August 2016 22:40
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Chart with future energyprices

Post by 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
Posts: 60
Joined: Thursday 20 April 2017 7:20
Target OS: Linux
Domoticz version: Latest
Contact:

Re: Chart with future energyprices

Post by ressof »

Lokonli wrote: Tuesday 31 January 2023 18:34 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
Posts: 32
Joined: Thursday 26 March 2020 11:37
Target OS: -
Domoticz version:
Contact:

Re: Chart with future energyprices

Post by 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

Image
Image
Image

the price info and reallive data of the first 3 dials is from https://github.com/flopp999/Tibber-Domoticz
docker with sonos http api / mosquitto / zigbee2mqtt assistant / portainer / dashticz / nodeJS on windows with Zigbee2Mqtt, and some flask builds of my own
User avatar
heggink
Posts: 972
Joined: Tuesday 08 September 2015 21:44
Target OS: Raspberry Pi / ODroid
Domoticz version: 12451
Location: NL
Contact:

Re: Chart with future energyprices

Post by heggink »

What battery do you have?
Docker in Truenas scale, close to latest beta
DASHTICZ 🙃
RFXCOM, zwavejs2mqtt, zigbee2mqtt,
P1 meter & solar panel
Google home, Wifi Cams motion detection
Geofence iCloud, Bluetooth & Wifi ping
Harmony hub, Nest, lots more :-)
nfuse
Posts: 32
Joined: Thursday 26 March 2020 11:37
Target OS: -
Domoticz version:
Contact:

Re: Chart with future energyprices

Post by 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

Image
docker with sonos http api / mosquitto / zigbee2mqtt assistant / portainer / dashticz / nodeJS on windows with Zigbee2Mqtt, and some flask builds of my own
Lokonli
Posts: 2260
Joined: Monday 29 August 2016 22:40
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Chart with future energyprices

Post by Lokonli »

ressof wrote: Tuesday 31 January 2023 19:45
Lokonli wrote: Tuesday 31 January 2023 18:34 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
Posts: 60
Joined: Thursday 20 April 2017 7:20
Target OS: Linux
Domoticz version: Latest
Contact:

Re: Chart with future energyprices

Post by ressof »

Lokonli wrote: Saturday 04 February 2023 13:56 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?
User avatar
heggink
Posts: 972
Joined: Tuesday 08 September 2015 21:44
Target OS: Raspberry Pi / ODroid
Domoticz version: 12451
Location: NL
Contact:

Re: Chart with future energyprices

Post by heggink »

nfuse wrote: Wednesday 01 February 2023 10:37 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

Image
WOW, nice! Could I ask how much you spent on that? Interested to understand the price differential compared to a commercial model.
Docker in Truenas scale, close to latest beta
DASHTICZ 🙃
RFXCOM, zwavejs2mqtt, zigbee2mqtt,
P1 meter & solar panel
Google home, Wifi Cams motion detection
Geofence iCloud, Bluetooth & Wifi ping
Harmony hub, Nest, lots more :-)
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest