With all the statistical hourly data of energy usage, solar production, battery charge and discharge and grid im- and export of over a year, wouldn’t it be possible to run a backtest to see how fixed price energy tariff compares to a dynamic tariff?
The data required should be all at hand. Has something like this been done before?
I’m also interested to see what gets said on this thread. I would like import and export of prices, forecasts and smart meter kW histories to and from a file format which Python can recognise and plot if you’ve got matplotlib. Possibly preferably a .csv file format with headings above one or more columns and every row starts with a timestamp. Please say what I need to look at to get at it.
In case interested, I created a little python script with the help of Claude.
This script allows to analyze one year of home assistant energy consumption data to compare the price point of a traditional fixed price energy tariff with a dynamic tariff such as dynamicOctopus. In my case the data indicated to the dynamic tariff to be 1.5% more expensive, not considering any kind of optimizations, such as load shifting, or charging the home battery from the grid, when energy is cheap and it is not expected to be charged from photovoltaik (e.g. during winter).
Please feel free to use the script for your own purpose, or to add additional features.