[APP][Pro] Power by the Hour: Insights per hour, day, month and year

Since todays midnight I am not getting any updates on el. CZ spot prices :frowning:


Thanks for taking a look.

I can confirm.

If the data source is down nothing can be done other then wait…
https://transparency.entsoe.eu/transmission-domain/r2/dayAheadPrices/show

But when I check for CZ I do see prices showing up. So is it solved now?

1 Like

Hmm, strange, I still see last update 2 days ago. Tried even restart of the PbH, no change.

I checked the source too but device does not update anyway. Maybe they made some changes in API?

For every measurement you make a device in the pbth app.
I only have solar panels and electric.

I export a file to Sheets:

The flow is:

I use the value “day before”

2 Likes

Yes, it does look like an API change. Will need to dig into this further.

Edit: They changed the API url. I fixed it in the new version PBTH.

new version 5.4.5 was just released as stable.

  • Fixed ENTSOE new API url.
  • homey-api@1.10.18
2 Likes

Nice, thanks for the follow up @Ria_Banis!

Is there a way to get the information to a MQTT server.
I use Nodered for a dashboard

Would you mind sharing your script?

Hello @Steefph , sure that is possible, I’m happy to share. But only if you’re experienced homeyscript user who can understand what’s needed and can make variables and flows to use the script.
If that’s the case i can share by PM
Not for coming day’s, I’m in hospital at this moment, recovering from a serious issue, but going home tomorrow, so will have lots of time later on this week.

3 Likes

Take care of yourself Gert! Hope you have a speedy recovery.

2 Likes

Homey Script is not an issue. But it is always easier to borrow someone’s wheel than reinventing it :slight_smile:

Hope you recover quickly and, no rush!

2 Likes

@Steefph , i’m back.
See PM with instructions and script. Have fun.

@Gruijter It seems like the “device” for my solar panels doesn’t reset at midnight to zero:

After restart it gives the correct values ( for the time being a use a restart flow just after midnight)

The restart does not work anymore. Now also the other device (Electricity) is also not working anymore :cry:

Hi developer and community,

Is there already a clear manual to guide me step by step to setup “Power by the hour” in combination with Plugwise P1 (v3) and ANWB daily prices for gas and electric?

Can’t see the forest trough the trees no more… :blush:

grtz Hans

Would it be possible to allow this value to be negative:

When Power used becomes lower than Power generated due to solar panels, this value drops to zero, but Power is actually negative (generated).

That is already supported.

What is the source device and app you are using?

Hi Ria,
can you post a screenshot of the PBTH device settings (top part),
and insights graphs of past 24 hrs for:

  • PBTH ‘this_hour’
  • the source device (solarEdge) energy (kWh)