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

I understand. But they do charge a purchase fee (inkoopvergoeding). According to my calculations, based on your screenshots, the purchase fee is 0.7 cents per kWh (excl BTW). Do they not mention this purchase fee somewhere in the contract? Or can they just change this fee whenever they like?

Now that I dive deeper into this dynamic pricing I find it is only transparent if you have a PhD in economics :crazy_face: . But here is my attempt to make it as transparent as possible for your provider FrankEnergy in the Netherlands:

Based on what I gathered so far the actual price per kWh is (example for price @21.00 23.2.2022)

  • net purchase price, changing every hour (0,165)
  • FrankEnergy purchase fee (0,007)
  • BTW/VAT (21% over net price and purchase fee = 0,036)

Giving a total of 0,208 euro per kWh.

BUT!!! This does not yet include:

  • NL Govt Energy tax (0,04452 per kWh)
  • NL Govt ODE/energy storage fee (0,0369 per kWh)

So the actual total price @21.00 23.2.2022 per kWh is 0,289 euro per kWh

And then you have additional fixed costs/discounts:

  • FrankEnergy service cost (5 euro/month).
  • NL Govt energy tax ‘discount’ (- 824,77 euro/year)

It does not make sense to add the fixed costs per month/year to the PBTH pricing, since PBTH works with kWh. But I personally would want to use the 0,289 as tariff, and not 0,208.

By the way: compared to my fixed tariff contract that I closed in July 2021, my current total price is around 0,25 euro per kWh. The total average price of FrankEnergy yesterday was 0,288 euro per kWh. So I’m happy I am not using flexible prices at the moment :money_mouth_face:

Good to know you have a phD in economics :grinning:

I know nothing about the purchase fee, it was not in my contract. So I guess they can change it.

Thanks for sorting this out. Although not stated in the summary I assumed that energy tax and storage fee was included in the price. The invoice is not specified, it’s just the price for gas/electricity with and without BTW.

Since I have a contract on daily prices, I am much more aware of my consumption and act accordingly. But at the moment the prices are quite high and with hindsight it was financial better to have fixed prices. Won’t get any better given the situation in east Europe.

But it is not included. And secondly they state they do not make a profit, but forget to mention that they do have a purchase fee, and apparently are not clear on how high this fee is. That is exactly why I feel they are not being transparent at all. And I wonder how they handle feeding back to the grid when you have solar panels like I do. Is the purchase fee then substracted? Is there anything in the contract about that?

They are not the only ones not being fully transparent though. ANWB publishes the same pricing (with a slightly different purchase fee).

My luck is that I closed a fixed contract in July, when the prices were still o.k. But my contract ends in July this year. Maybe dynamic pricing will be the best option for me then. Especially now that I understand how it works I can Have Homey / PBTH control my car charging per hour (combined with my own Homey Kia app), start the dish-washer at the perfect moment, and even put fridges ‘on pause’ for an hour if that is cost effective. I already have all the infrastructure in house to do this. I just need to create the right flows.

That’s right, but for now it’s nice to determine a trend (and automate upon) and have at least some dynamic pricing for insights.

There’s nothing about solar panels, that I’ve seen. But it’s not yet relevant for me. According to Frank:

First of all, we use the national offsetting agreements, so we offset generation and consumption against each other when it comes to taxes. We also reimburse the dynamic price (excl. purchase fee) for each kWh generated.

I’m finalizing the Day-ahead pricing driver. It now works for just about all EU countries and energy providers that have hourly spot prices (including Tibber). The pricing information is fetched from ENTSO-E, the European Network of Transmission System Operators for Electricity: Data view

Version 4.1.0 ready for testing: Power by the Hour App for Homey | Homey

2 Likes

Absolutely awesome, thanks!

I not sure if fixed markup per kWh is added before btw is applied or after. So do you pay for btw on energy tax? If that is the case, it would be strange to pay tax upon tax. I read the tooltip, but was still not sure about it. (typo on bvelasting by-the-way)

You can consider to make the default value 0.00 instead of 0 to make it clear you need a dot instead of comma.

As we discussed, you can’t add monthly service costs to the price, since you can’t add it as fixed markup per kWh. You can also not substract ‘vermindering energiebelasting’ to the kWh price.

What I don’t get in the reporting is that ‘Geld dit uur’ is constantly 0.06 while ‘Geld vorig uur’ is changing every hour. ‘Geld vorig uur’ is one hour off in the reporting -not surprisingly- but the ‘Geld dit uur’ reporting isn’t correct. Am I missing something?

I have not updated till the latest version,. I will do that this week.
But when I update to the latest version, am I losing all the counters from this Month and Year or is that still there.
With the old version (3.0.1) I saw today that resetting the day and hour was an hour to late.
Time on Homey is correct.
Thank you for the app.

The fixed markup per kWh is added after the %markup. So for the purchase fee you need to enter the amount including BTW. See the settings picture I posted. I used FrankEnergy there (including the extra govt taxes per kWH)

I need to check what is going on. Is it correctly displayed in the device tile?

The 3.0.1 version you are using is 13 versions behind the current one. Many bugs have been fixed since then, including the timezone offset you mention. I cannot guarantee your history is preserved though because I only can handle migrations to a limited number of versions back.

Thank you. I know I am a bit behind but this version worked OK for me.
Even the reset at 0:00.
I will update this week and see what stays good and what not.
I think I make screenshots from the data so I can edit if it is wrong.

Alright thanks.

It’s not displayed in the device tile. See attached image

that is weird. What does it say at ‘active tariff’ in the device tile? That should display the tariff of the current hour. @Muesli

I have already updated the app. All values are still there and they are still correct.
I only had a small problem to change the display in the icon from “kWh this year” to “kWh this day” that it takes about 2 minutes before the correct value is displayed.
For all other devices, it was instantly changed.

1 Like

The default value, 0.25. I wasn’t sure if this value should actually change or that is was omitted.

If the tariff is still at the default value it means you are not automatically updating from the hourly prices. To do that you need to:

  • switch on ’ Tariff via flow’ in your PBTH Smile device (default is on),
  • switch on ’ Send tariff’ in the PBTH FrankEnergy device (default is off).
  • Check that you do not also have a flow that changes the tariff, since that might clash.

But even with the default tariff of 0.25 the ’ money this hour’ should update everytime the Smile is reporting a new kWh value. I cannot reproduce this / it is working fine for me. Make sure that in the PBTH Smile device:

  • ‘Use Watt as source’ is off (default)
  • ‘Has daily reset’ is off (default)
  • ‘Update interval’ is 0 (default)

I checked it.

‘send tariff’ is on
‘tariff via flow’ is on
I don’t have any related flows active.

I made sure that the other settings were off.

I removed the PBTH power device and added smile
power device

ok, when it still doesnt update the tariff, send me a diagnostics report 1 or 2 minutes after a whole hour.

Thank you for this great app!
I use Tibber in Germany. Price update via Flow works perfect for me in the past.

With the last update you introduced a new tile day ahead prices.

Which provider in the list i have to set for Tibber in Germany?

That is a bit of a puzzle. You could ask Tibber. Or you could check this site and select Germany (DE): Data view

But it is probably DE_Germany_DE_LU since that is the only one in Germany with updated pricing. Note that the source pricing is without tax and without the purchase fee from Tibber. But if you do some manual calculations you should be able to find out what markups you need to enter in PBTH.

Don’t forget to let us know what you need to use for Tibber in Germany :wink:

Edit: It is indeed DE_Germany_DE_LU. In this link you will find a lot of answers: Wie setzt sich der Verbrauchspreis fĂŒr Strom bei Tibber zusammen? | Tibber Support Center

Perfect thank you. It works. Till now I don’t know what values I have to set for the exact price. There are a lot of variables cause of different fees :exploding_head:

1 Like