[Feature Request] Monthly Aggregate Sensor for Previous/Current Month

[Fettkeewl]

Is your feature request related to a problem? Please describe.
I'm currently on a variable tariff which is fixed for one month based upon the average hourly price for the entire previous month
with addition of my power companys various added costs. These added costs are somewhat fixed and don't change to frequently, however as it is now I must monitor my tariff the first every month and manually insert the new tariff.
This is bothersome to do if I want my data to be precise, i.e. set alarm for 00:00 the first every month to check new tariff and adjust my input_number representing it.

Describe the solution you'd like
I would like a sensor that can fetch the previous months average hourly price and the current months average aswell.
The data from the table in the link below
https://data.nordpoolgroup.com/auction/day-ahead/prices?deliveryDate=2024-11-01&currency=SEK&aggregation=MonthlyAggregate&deliveryAreas=AT,BE,FR,GER,NL,PL,SE3

Describe alternatives you've considered
The current options I've considered are

• Web scraping my power companys page for the relevant price, this failed due to dynamic website (javascript driven)
  also browserless chrome could not bypass the cloudflare captcha
• Web scraping the above mentioned link, but it aswell is probably javascript generated which seems not so futureproof
• Extending my recorder history to 30 days, increasing my overall database history by 3x only to try and calculate the average myself which is a solution equivalent to using a shotgun to kill a mosquito

Additional context
Example image of the data I need

[Repsionu]

Maybe use this: https://github.com/martinarva/dynamic_energy_cost ?

[Fettkeewl]

From what I read in that integration it won't get me what I need.
I've been reading up on the source code in this integration and from my understanding
the backbone is already there but I shall study it some more, still learning python

[KNZZZZZZZ]

I have the exact same problem and am also looking for a solution.
The daily average is already in the integration but unfortunately not monthly.

[Hellowlol]

I think the easiest would be to create a pr for a service call. The service call could do a call for nordpool api to get the last months average price. You could store the result insomekindd of helper and use the helper in your additional costs template.

If this was possible you could automate the entire thing :)

[Fettkeewl]

Yes I like that idea 💡
Unfortunately for me my python skills are bad, hopefully someone can step in here 🙏😅

[KNZZZZZZZ]

for me my python skills are bad, hopefully someone can step in here 🙏😅

Unfortunately the same for me

[Fettkeewl]

Closing as fixed in #462 (comment)
With a minor ongoing bug for monthly aggregate as seen in #467 (comment)