I am a customer of Octopus Energy, who are an innovative electricity supplier in the UK. I find them a great company, not least because of:
- their dynamic time-of-use tariff, Agile, which allows customers to save money by adjusting when they consume
- Their API, that allows customers to access their consumption and price data, and developers to build useful apps and tools (I have written an extensive user guide to this).
- Their user forum, which attracts a lot of end users and developers who are able to share ideas and solve problems
If you are interested in moving to Octopus (they have ordinary tariffs as well as Agile), I'd highly recommend them, and if you sign up with this link then we both get £50 credited to our account.
This page contains a number of tools I've built on the Octopus API, some blog posts I've written about Octopus, and some links to other Octopus related sites.
The first tool I built gives you historical half-hourly Agile prices for a region, between two dates. This tool doesn't require your security key. The url is: https://www.guylipman.com/octopus/prices.html?region=C&startdate=2020-03-28&enddate=2020-03-29 . If you aren't sure which region you are, there is a listing on wikipedia. Note that this page can be a bit slow if you're trying to retrieve more than a month of data at a time.
The next tool gives your historical electricity consumption. The url is https://www.guylipman.com/octopus/consumption.html?startdate=2020-03-01&enddate=2020-12-31&key=AAA&mpan=BBB&meter=CCC where you replace AAA, BBB and CCC with your account details (see above). This page will identify any gaps in your data. It also works for gas consumption if you replace mpan=AAA with mprn=AAA.
The next tool provides some analysis of your consumption data for a single month, telling you how much money and emissions you saved by consuming at the cheapest times. The url is https://guylipman.com/octopus/consumption_analysis.html?month=2020-04&key=AAA&mpan=BBB&meter=CCC. There are optional parameters mode=perkwh or mode=perday, and you can also specify the fixed price to compare to using, for example, fixedprice=15 (otherwise it uses Octopus's standard variable tariff for your region). Note that this webpage requires you to have consumption data for the whole month in order to work.
The next tool compares what you paid (or would have paid) on Agile for a single month, with a range of other Octopus tariffs, both for your consumption profile as well as if your consumption was shaped according to the standard profile. The url is https://guylipman.com/octopus/price_comparison.html?month=2020-04&key=AAA&mpan=BBB&meter=CCC. Note that this webpage requires you to have consumption data for the whole month in order to work.
The next tool calculates your Agile bill between two dates, in the same way that Octopus does when billing. The url is https://www.guylipman.com/octopus/bill_agile.html?startdate=2020-03-23&enddate=2020-03-31&key=XXX&mpan=YYY&meter=ZZZ. If you have a smart meter on Octopus but are not on the Agile tariff, it will tell you what your bill would have been. There is also a version for calculating your export income: https://www.guylipman.com/octopus/income_agile_export.html?startdate=2020-03-23&enddate=2020-03-31&key=XXX&mpan=YYY&meter=ZZZ.
Next is a generic API tool which provides a way to make requests to the Octopus API. You can enter a URL, your security key (if required), and there's an option to display the output as raw json, pretty json, or a table.
Next is a tool that checks all your meters for missing consumption data - the url is https://www.guylipman.com/octopus/missing_data_check.html?account=A-XXXXXXXX&key=XXXX.
I have a full list of energy-related blog posts on my main energy page, but the following posts may be particularly relevent to Octopus customers:
|2 July 2020||Getting the data to forecast electricity prices/A>|
|25 June 2020||Letting people access their electricity data|
|31 May 2020||Measuring electricity demand flexing|
|1 September 2019||Analysis of Octopus Agile electricity prices|
|21 August 2019||Optimising a Mixergy boiler|
|2 Apr 2019||Power price vs Carbon Intensity|
|28 Feb 2019||Analysing UK electricity prices (part 2)|
|20 Feb 2019||Analysing UK electricity prices (part 1)|
|04 Feb 2019||Exploring time of use tariffs|