Energy Dashboard with dynamic PV feed-in pricing

In Switzerland some of the energy companies has a special price model for feed-in PV energy. (e.g. BKW, CKW)
They pay you a price regards to a reference of the energy market. It is called “Referenzmarktpreis” which will be published 4 times a year but after the feed-in. This gets more popular with the new energy law which take effect in January 2025.

You feed-in from January to March and you will get a info what you will get per kWh in April.
So, because of this I’m not able to set the price to a sensor (also not via API).

There is a source (csv and xml) which can be used to get the price for the past quarter. But how I could use this in Energy Dashboard to (re)calculate the prices for the most recent quarter?

I assume, there are many others which such a scenario which are also looking for a solution. So may someone has already a idea or approach to get this working?

My best idea so far would be some kind of automation which checks the csv/xml and if the price was published it would correct all price entries of a sensor in the statistics. Afterwards the energy dashboard should be triggered to recalculate the prices for the affected period of time. But absolutely no idea how to achieve this.

Btw: I also think about the same issue for my influxdb & grafana dashboard. Currently the best idea is to delete the sensor value of the “price” sensor for the time period and then re-insert the same sensor with the corrected value. Very uncomfortable. :slight_smile:

1 Like