[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