get diskrete values @ specific time (range)

[m-claudius]

Ideally I need (a mean) price in a given time range.
Application:
I have to decide whether it is useful to charge the battery in cheap times before the expensive time starts,
If meanPrice( timeA, timeB) / meanPrice ( timeC, timeD) > efficiencyOfBattery then load battery.
(efficiencyOfBattery: the efficiency of charge/ discharge is typically 20%)
Could be also:
If meanPrice( timeA, durationA) / meanPrice ( timeC, durationB) > efficiencyOfBattery then load battery.
Typically: Load the battery between 3:00 and 6:00 and discharge between 6:00 and 8:00.
(Different topic: How much to charge? => depends on outside temperature: heatPumpPower= f(temp) )
Maybe a template getMeanPrice in HA using the existing calls would work?