Netherlands: Vrijopnaam

[GeoffreyFrogeye]

Template for the dynamic rates contract for Vrijopnaam.
VAT is handled by the template, set the plugin VAT option to 0.

You can subscribe to notifications as I'll announce if the template needs to be adjusted for upcoming changes in rates.
I periodically check myself, but feel free to comment too if you notice I'm late.
Last I checked (and bothered to update this message), the template is valid until at least: June 2023.

{% set inkoopvergoeding = 0.0165 %}
{% set energiebelasting = 0.12599 %}
{% set btw = 0.21 %}
{{ (current_price + inkoopvergoeding + energiebelasting) * (1 + btw) }}

(I don't follow the s dictionnary convention so it's easier to have templates that can adapt to scheduled rate changes.)

[cyborghound]

Does this still match with you sheets? I implemented your template but Entsoe show a much bigger price then what I see in Vrijopnaam.app.

[GeoffreyFrogeye]

Actually you made me realize that something is wrong at Vrijopnaam. The value for Inkoopvergoeding shown in the rate sheets I have is also 0.0165 €/kWh, but the calculations on the app are made with 0.026 €/kWh! The former value is what is shown on the rate sheets from February and before. I suppose I didn't notice earlier because when I wanted to update the script in March I saw the calculation made by this plugin still matched the calculation in the app so I only changed the "this should work 'til X" in the header, and today I only checked that the Inkoopvergoeding value was the same since March. I double-checked all that and sent a mail to their customer service explaining the discrepancy, let's see what they have to say about it!

[cyborghound]

Just found out that the prices are correct now since the rotation, thanks! I'm still curious if Vrijopnaam does the wrong calculation or if there is some hidden fee, because 0,026 is not 0,0165. But for now I have the correct prices.

[GeoffreyFrogeye]

Following my email to them, Vrijopnaam informed me today that the Inkoopvergoeding value they used in the app had indeed not been updated, and it has now been fixed. So while my template showed the prices that were displayed in the app, it didn't have the correct prices either! I now updated the template too (also simplified it).

And now I have to live with the knowledge that my Energy dashboard shows slightly incorrect energy prices for the last few months 😞

[cyborghound]

Thanks for the update! That's why my values were not correct this week. I corrected the values yesterday and they seem to be good now. Thanks for the help! And for the energy dashboard, can't you correct that in some way?

[GeoffreyFrogeye]

I probably can, but then I have to spend some time to fix it. Neither situation is ideal 😅