MySQL - How do I Calculate an Average Value Over a Period of Time When Only Value Changes are Recorded
KISS

Assuming daily means every day including weekends and holidays.


Insert price for all items everyday
Use AVG() for value
Delete prices over 180 days.