Hexagon / spotweb

Dockerized Deno application that gets and caches electricity prices (spot price) from ENTSO-e.
https://spot.56k.guru
MIT License
5 stars 1 forks source link

Other way of calculation of the prices #11

Closed liviooo closed 1 year ago

liviooo commented 1 year ago

Our Belgian energy company ECOPOWER uses a different way of calculating the prices: 1,02 * (EPEX DA) + 4 euro/MWh + 6% VAT + (5 euro's fee per month)

Thus the calculation should be: ((EPEX DA) x 1,02) + 0,004) x 1,06

The current way of price calculation (ex vat) is as follows: ((EPEX DA) + 0,004) x 1,02

Any chance we can have extra fields for extra costs and a different way of calculating totals?

Hexagon commented 1 year ago

Interesting! Will have a look at that

Hexagon commented 1 year ago

@liviooo Now multiplier is added, and have started writing more about calculation on https://spot.56k.guru/help

Also added your dutch translation (will be used if your computer is set to dutch). Help is only available in english so far.

Would be great if you can verify that it works as expected 👀

liviooo commented 1 year ago

I did a quick calculation, but the figures don't match yet.

Manual calculation: ((0,11571,02)+0,004)1,06= 0,1293 €/kWh inc. VAT

The URL: https://spot.56k.guru/api/v2/hass?currency=EUR&area=BE&multiplier=1.2&extra=0.004&factor=1.06&decimals=4 gives me 0,1514 €/kWh inc. VAT

Screenshot 2023-08-30 at 18 47 10 Screenshot 2023-08-30 at 18 46 46
Hexagon commented 1 year ago

@liviooo

Did a quick check, and it seems like you accidentaly entered &multiplier=1.2 instead of &multiplier=1.02. After fixing that everything seems good :)

liviooo commented 1 year ago

Damn, my bad!