Octopus Agile

[Deleted User]

So unlikely to apply to Agile in three near future unless it also falls victim to a deal site bandwagon.

The reason that Agile went 'mass market' was because the capped price at the time (last year) was below the Ofgem Cap. People could switch to Agile and do nothing about load shifting in the knowledge that they would pay less than the Cap. That particular scenario no longer applies. 

QrizB

Bendo said:

Does anyone have a spreadsheet that can be used to put in historical smart meter usage data and Agile region pricing to work out what the cost would have been if on Agile?

I'm not sure that you need a template. Your spreadsheet will only need four columns:

A - the date and time.

B - your historical 30-minute smart meter data.

C - the historical Agile data for your region, from eg. energy-stats

D - B multiplied by C

Then add up column D for th period of interest.

Pat38493

QrizB said:

Bendo said:

Does anyone have a spreadsheet that can be used to put in historical smart meter usage data and Agile region pricing to work out what the cost would have been if on Agile?

I'm not sure that you need a template. Your spreadsheet will only need four columns:

A - the date and time.

B - your historical 30-minute smart meter data.

C - the historical Agile data for your region, from eg. energy-stats

D - B multiplied by C

Then add up column D for th period of interest.

Was the poster already on Octopus?  If they are already on Octopus they can download the data from the API.  If not, they can download it from other sources but then they have to pay attention to the date and time fields - some of the apps export the times in UTC so you have to then figure out how to get it to the UK time for each row.  I think that the Octopus API gives out the correct UK time.

QrizB

Pat38493 said:

Was the poster already on Octopus?

Unknown (to me, at least).

Yes, if already on Octopus then there are simpler options.

Unfortunately Octocomaprison - which did it all for you - is now offline.

https://octocomparison.co.uk/

Bendo

No. Not currently on Octopus, 2 year fix ends in November so will switch then.  Have the usage data for the past 3 years and the Octopus pricing for my region so will marry them up at some point soon.

Bizarrely Octopus API gives the price data in CET. I'm sure they have some reason for this,  although I can't think of any reason whatever to present it in anything other than UTC...

mmmmikey

Bendo said:

No. Not currently on Octopus, 2 year fix ends in November so will switch then.  Have the usage data for the past 3 years and the Octopus pricing for my region so will marry them up at some point soon.

Bizarrely Octopus API gives the price data in CET. I'm sure they have some reason for this,  although I can't think of any reason whatever to present it in anything other than UTC...

Hi - coincidentally I've been playing with the API this afternoon. The Agile price data I'm retrieving from the API is in UTC - maybe we're accessing it differently? The timeslots in my data runs from 22:00 UTC to 21:59 UTC for the next day's data which is 00:00 CET to 23:59 CET, the reason for that being the index the Agile prices are derived from works in CET. But the data is definitely presented in UTC in my download. How are you getting the data?

My frustration is the lack of consistency - when I download the consumption data for my meter it is presented in BST. Not a big issue as easy enough to convert.

edit: corrected typo in above post & here is a sample of the data I'm getting:

    {
        "value_exc_vat": 18.29,
        "value_inc_vat": 19.2045,
        "valid_from": "2023-09-09T21:30:00Z",
        "valid_to": "2023-09-09T22:00:00Z",
        "payment_method": null
    },
    {
        "value_exc_vat": 22.34,
        "value_inc_vat": 23.457,
        "valid_from": "2023-09-09T21:00:00Z",
        "valid_to": "2023-09-09T21:30:00Z",
        "payment_method": null
    },

Bendo

I was just downloading it from https://energy-stats.uk/download-historical-pricing-data/ to avoid faffing with API.

Not has a chance to do anything with it as yet will either throw it in excel or into MySQL .

Pat38493

There is an option directly on the Octopus web site to download your consumption and if I remember it right, that option give you a CSV file with the time as correct UK times.

la531983

Peak pricing tomorrow likely to be a significant jump up for Agile customers if the Nordpool day ahead hourly pricing (used to calculate Tracker pricing) is anything to go by, so just a heads up.

Still a significant lack of wind power in the system.

Pat38493

la531983 said:

Peak pricing tomorrow likely to be a significant jump up for Agile customers if the Nordpool day ahead hourly pricing (used to calculate Tracker pricing) is anything to go by, so just a heads up.

Still a significant lack of wind power in the system.

Is that the main cause or is there also some more politics going on or strikes in Australia threatened or whatever?