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

@Gruijter

And again the prices for The Netherlands are not correct.

Now my flows wiil start an hour too late.

Yesterday it was correct. I am lost. :fearful:

Yesterday and today (while working on my EPM flow), I also see a rate difference between what PBTH and Zonneplan calculate. Restarting PBTH seems to resolve the problem.

PBTH v8.8.2
Homey 13.1.2

New version 8.9.0 is ready for testing: https://homey.app/a/com.gruijter.powerhour/test/

  • Option for personal ENTSO-E API key
  • Fix Nordpool prices
  • Improved price charts
  • Improved Solar Forecaster accuracy
  • Improved Battery ROI strategies
  • General stability fixes
  • Homey-api 3.18.3

This will make price behavior more stable. There is a bug in Norpool data that can cause 15m prices to be used in stead of 60m prices. I have implemented a workaround in PbtH. Secondly it is now possible to enter your own ENTSO-E API key in the DAP settings. This completely removes the rate limits when using the built-in PbtH key, thereby greatly improving stability of price fetching.

See ENTSOE INSTRUCTIONS how to apply for your own API key.

@Gruijter

“Today the prices are correct again. Is that because of yesterday’s update, or because there are no negative prices today? I have the impression that’s where it goes wrong. I have Zonneplan, and with feed-in I also get the trading costs (markup) refunded.”

Could be

For me negative prices already worked good

The strange thing is that it always works correctly when taxes are included, but not when energy tax is excluded and only the compensation rate is used.

So how does that work? In which situation does the compensation rate apply, and how is your tariff calculated?

If you are not familiar with how energy companies calculate your energy bill, make sure to dive into the foundations of bistromathics. It is very clear that bistromathics is used by all known energy companies, although they will not admit that they do. https://hitchhikers.fandom.com/wiki/Bistromathics

The compensation rate is always 2 cent including tax.

See example yesterday:

This rate is exl tax

Compensation for what exactly?

At Zonneplan, you pay 2 cent purchase costs (including VAT) for every kWh.
If you feed electricity back into the grid, they pay you back those 2 cents.

So also in cases of overproduction. It is not part of net metering.

Seems like a very bad deal while we stil have saldering. But I think this is the export price setting you need.

Thats what I have.

And it is not a bad deal. They pay me the two cent back. (Tibbber and Frank Energie do not.)

FE : price is - 2 cent I don’t have to pay for net injection because with the 2 cent return it is zero.

Price -4, I pay two cent for net injection

And I think that goes wrong some were in the calculation of PbtH.

I think there is a difference in export tariff in case of saldering and in case of overproduction (more production than own usage thus above saldering). In case of saldering the export price is exactly the same as the import price (@zonneplan). In case of overproduction, the export price is the kWh price + 2 cents.

No, for Zonneplan import and export price is the same.

It is Epex* BTW + 2 cent.

In case of salderen you are right. In case of overproduction, you’re not

Wat krijg je dan wel voor je zonnestroom?

De rest van je vergoeding blijft gewoon bestaan. In tegenstelling tot veel andere leveranciers krijg je bij Zonneplan Energie – ook na 2027 – gewoon een eerlijke prijs uitbetaald:

  • Je ontvangt nog steeds de marktprijs van dat uur.

  • Je ontvangt nog steeds de inkoopvergoeding (€ 0,02).

  • Je ontvangt nog steeds de Zonnebonus (10% extra).

Kortom: hoewel het belastingvoordeel verdwijnt, zorgen wij dat je eerlijk betaald blijft krijgen voor je stroom, zonder boetes of vaste terugleverkosten.

dus die twee cent blijft. (Sorry voor het Nederlands).

This is different from what I understood before. So the 2 cents is ON TOP of the market price. What about BTW and energy tax? And what is that about 10% bonus?

Like I said before, you need to understand bistromathics to understand what you actually get paid when exporting to the grid…

10% is a bonus that is not in this rate. It is paid extra afterwards on your end bill

The two cents is incl tax, (21%), you can see the numbers are correct for the today prices the way I filled it in.

I noticed the diffrence with negative prices occurs after you also implemented export prices.

last year there were also negative prices and I had no problems.

Tomorrow negative prices again, and then the deviation again. 14:00 hour

Highest price 0,2315 is correct

Maybe this helps understanding the total picture. I made 3 devices which represent the correct prices:

  1. Normal purchase price

  1. Price whenever a kWh is exported as long as it’s part of the saldering

  1. Price for a kWh which is exported but can’t be part of saldering (because there is more production than own usage

This gives me 3 devices which represent a price which is exactly what Zonneplan-app is showing.