I looked at the excellent Hildebrand solution however it requires skills I do not have. I would be prepared to contribute toward a HE solution if others wanted to explore this.
Watching this thread. I’m also with Octopus in UK. I’m sure some would probably like to see usage over time (perhaps that would need Influx/Grafana). I’d probably be happy just to get a tile showing current electricity and gas usage so I can watch my bank balance drop.
You can't get "current usage" from their api as it is using the data uploaded to the (government) smart metre cloud platform. This is sent in thirty minute chunks and I think you can only see the previous calendar day.
The only way of getting current usage is from a CAD device and the only one I've found is this
The next problem is that it's MQTT which means it's going to be tricky to setup with HE and probably can't be done without something else running as a MQTT broker on your network (rpie etc)