Using Amber Electric Home Assistant import and export rates and forecast #2822

RangeyRover · 2025-10-25T05:08:00Z

RangeyRover
Oct 25, 2025

I have the following entities available in Home assistant from Amber Electric, how can these be integrated into predbat? I's really like to be using the forecast, for example. Even if I can patch them so that they appear like the already working Octopus integration maybe?
Demand Window
Feed In Forecast
Feed In Price
Feed In Price Descriptor
General Forecast
General Price
General Price Descriptor
Price Spike
Renewables

RangeyRover · 2025-10-25T06:07:59Z

RangeyRover
Oct 25, 2025
Author

Ok, ive tried using override automation to go from my existing sensor into predbat

alias: Predbat – Export rate override (every 5 minutes, 60-minute window)
description: "Send current export price from sensor.rosella_general_price to Predbat"
mode: single

trigger:
  - platform: time_pattern
    minutes: "/5"

action:
  - variables:
      d: "{{ now().timestamp() | timestamp_custom('%Y-%m-%d') }}"
      s: "{{ now().timestamp() | timestamp_custom('%H:%M:%S') }}"
      e: "{{ (now() + timedelta(hours=1)).timestamp() | timestamp_custom('%H:%M:%S') }}"
      # Convert sensor is in $/kWh and Predbat expects cents, multiply by 100
      rate_val: "{{ (states('sensor.rosella_general_price') | float * 100) | round(2) }}"
  - action: select.select_option
    target:
      entity_id: select.predbat_manual_api
    data:
      option: >-
        rates_export_override
        ?date={{ d }}&start={{ s }}&end={{ e }}&rate={{ rate_val }}

This is seen in the Manual API Controls
+rates_export_override ?date=2025-10-25&start=16:35:00&end=17:35:00&rate=29.0

But I don't see any change in the Plan window still all 0.00

5 replies

gcoan Oct 25, 2025
Collaborator

Can you explain more about how your energy supplier prices work. Is it a base price that then varies in particular events, or is it a price that continually varies.

You can use rate override but predbat really expects to get a base price to work from, this can be varying, doesn't have to be fixed across the day.

There are several ways to define the base price https://springfall2008.github.io/batpred/energy-rates/

If yours is a varying price across the day then you probably need a template sensor and configure metric_octopus_import (or _export) to point to that sensor https://springfall2008.github.io/batpred/energy-rates/#other-energy-spot-rate-sensor-integrations

Predbat does all of its planning based on 30 minute time segments so your rate_export_override (and your base rate sensor) should be aligned to start/end at :00 and :30 minutes past each hour. As yours are :35 minutes that's probably why they are being ignored

gcoan Oct 25, 2025
Collaborator

when you get a working setup please do share it so we can add it to the documentation for others

RangeyRover Oct 25, 2025
Author

when you get a working setup please do share it so we can add it to the documentation for others

I will, do you have an example form/style for the input metric_octopus_import, i'm sure I can make a sensor that will mimic the input style.

gcoan Oct 25, 2025
Collaborator

when you get a working setup please do share it so we can add it to the documentation for others

I will, do you have an example form/style for the input metric_octopus_import, i'm sure I can make a sensor that will mimic the input style.

Looks like this

RangeyRover Oct 25, 2025
Author

Awesome! Thanks, working on it.

RangeyRover · 2025-10-25T11:43:13Z

RangeyRover
Oct 25, 2025
Author

@gcoan essentially my supplier Amber Electric gives a forecast similar in style to Octopus, I think based on a 5min window.
its a JSON, I think.
I was trying to get any export or import value into predbat via the manual API as a proof of concept. I'd love to be able to use this sensor directly in predbat as its part of Amber Electric home assistant automation information.
Here is the sensor output for feedin forecast

date: '2025-10-25'
nem_date: '2025-10-25T21:45:00+10:00'
per_kwh: 0.1
spot_per_kwh: 0.1
start_time: '2025-10-25T11:40:01+00:00'
end_time: '2025-10-25T11:45:00+00:00'
renewables: 126
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T21:50:00+10:00'
per_kwh: 0.09
spot_per_kwh: 0.09
start_time: '2025-10-25T11:45:01+00:00'
end_time: '2025-10-25T11:50:00+00:00'
renewables: 123
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T21:55:00+10:00'
per_kwh: 0.12
spot_per_kwh: 0.12
start_time: '2025-10-25T11:50:01+00:00'
end_time: '2025-10-25T11:55:00+00:00'
renewables: 129
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T22:00:00+10:00'
per_kwh: 0.11
spot_per_kwh: 0.12
start_time: '2025-10-25T11:55:01+00:00'
end_time: '2025-10-25T12:00:00+00:00'
renewables: 133
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T22:05:00+10:00'
per_kwh: 0.12
spot_per_kwh: 0.12
start_time: '2025-10-25T12:00:01+00:00'
end_time: '2025-10-25T12:05:00+00:00'
renewables: 134
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T22:10:00+10:00'
per_kwh: 0.09
spot_per_kwh: 0.09
start_time: '2025-10-25T12:05:01+00:00'
end_time: '2025-10-25T12:10:00+00:00'
renewables: 133
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T22:15:00+10:00'
per_kwh: 0.11
spot_per_kwh: 0.11
start_time: '2025-10-25T12:10:01+00:00'
end_time: '2025-10-25T12:15:00+00:00'
renewables: 137
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T22:20:00+10:00'
per_kwh: 0.13
spot_per_kwh: 0.14
start_time: '2025-10-25T12:15:01+00:00'
end_time: '2025-10-25T12:20:00+00:00'
renewables: 138
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T22:25:00+10:00'
per_kwh: 0.12
spot_per_kwh: 0.12
start_time: '2025-10-25T12:20:01+00:00'
end_time: '2025-10-25T12:25:00+00:00'
renewables: 139
spike_status: none
descriptor: high
- duration: 5
date: '2025-10-25'
nem_date: '2025-10-25T22:30:00+10:00'
per_kwh: 0.04
spot_per_kwh: 0.04
start_time: '2025-10-25T12:25:01+00:00'
end_time: '2025-10-25T12:30:00+00:00'
renewables: 138
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-25'
nem_date: '2025-10-25T23:00:00+10:00'
per_kwh: 0.1
spot_per_kwh: 0.1
start_time: '2025-10-25T12:30:01+00:00'
end_time: '2025-10-25T13:00:00+00:00'
renewables: 129
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-25'
nem_date: '2025-10-25T23:30:00+10:00'
per_kwh: 0.1
spot_per_kwh: 0.1
start_time: '2025-10-25T13:00:01+00:00'
end_time: '2025-10-25T13:30:00+00:00'
renewables: 134
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-25'
nem_date: '2025-10-26T00:00:00+10:00'
per_kwh: 0.08
spot_per_kwh: 0.08
start_time: '2025-10-25T13:30:01+00:00'
end_time: '2025-10-25T14:00:00+00:00'
renewables: 135
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T00:30:00+10:00'
per_kwh: 0.08
spot_per_kwh: 0.08
start_time: '2025-10-25T14:00:01+00:00'
end_time: '2025-10-25T14:30:00+00:00'
renewables: 137
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T01:00:00+10:00'
per_kwh: 0.07
spot_per_kwh: 0.07
start_time: '2025-10-25T14:30:01+00:00'
end_time: '2025-10-25T15:00:00+00:00'
renewables: 136
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T01:30:00+10:00'
per_kwh: 0.06
spot_per_kwh: 0.06
start_time: '2025-10-25T15:00:01+00:00'
end_time: '2025-10-25T15:30:00+00:00'
renewables: 137
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T02:00:00+10:00'
per_kwh: 0.04
spot_per_kwh: 0.04
start_time: '2025-10-25T15:30:01+00:00'
end_time: '2025-10-25T16:00:00+00:00'
renewables: 140
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T02:30:00+10:00'
per_kwh: 0.04
spot_per_kwh: 0.04
start_time: '2025-10-25T16:00:01+00:00'
end_time: '2025-10-25T16:30:00+00:00'
renewables: 142
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T03:00:00+10:00'
per_kwh: 0.04
spot_per_kwh: 0.04
start_time: '2025-10-25T16:30:01+00:00'
end_time: '2025-10-25T17:00:00+00:00'
renewables: 144
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T03:30:00+10:00'
per_kwh: 0.03
spot_per_kwh: 0.03
start_time: '2025-10-25T17:00:01+00:00'
end_time: '2025-10-25T17:30:00+00:00'
renewables: 142
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T04:00:00+10:00'
per_kwh: 0.03
spot_per_kwh: 0.03
start_time: '2025-10-25T17:30:01+00:00'
end_time: '2025-10-25T18:00:00+00:00'
renewables: 139
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T04:30:00+10:00'
per_kwh: 0.03
spot_per_kwh: 0.03
start_time: '2025-10-25T18:00:01+00:00'
end_time: '2025-10-25T18:30:00+00:00'
renewables: 136
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T05:00:00+10:00'
per_kwh: 0.03
spot_per_kwh: 0.03
start_time: '2025-10-25T18:30:01+00:00'
end_time: '2025-10-25T19:00:00+00:00'
renewables: 130
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T05:30:00+10:00'
per_kwh: 0.05
spot_per_kwh: 0.05
start_time: '2025-10-25T19:00:01+00:00'
end_time: '2025-10-25T19:30:00+00:00'
renewables: 125
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T06:00:00+10:00'
per_kwh: 0.06
spot_per_kwh: 0.06
start_time: '2025-10-25T19:30:01+00:00'
end_time: '2025-10-25T20:00:00+00:00'
renewables: 119
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T06:30:00+10:00'
per_kwh: 0.05
spot_per_kwh: 0.05
start_time: '2025-10-25T20:00:01+00:00'
end_time: '2025-10-25T20:30:00+00:00'
renewables: 116
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T07:00:00+10:00'
per_kwh: 0.01
spot_per_kwh: 0.01
start_time: '2025-10-25T20:30:01+00:00'
end_time: '2025-10-25T21:00:00+00:00'
renewables: 120
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T07:30:00+10:00'
per_kwh: 0.01
spot_per_kwh: 0.01
start_time: '2025-10-25T21:00:01+00:00'
end_time: '2025-10-25T21:30:00+00:00'
renewables: 142
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T08:00:00+10:00'
per_kwh: -0.01
spot_per_kwh: -0.01
start_time: '2025-10-25T21:30:01+00:00'
end_time: '2025-10-25T22:00:00+00:00'
renewables: 159
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T08:30:00+10:00'
per_kwh: -0.01
spot_per_kwh: -0.01
start_time: '2025-10-25T22:00:01+00:00'
end_time: '2025-10-25T22:30:00+00:00'
renewables: 156
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T09:00:00+10:00'
per_kwh: -0.01
spot_per_kwh: -0.01
start_time: '2025-10-25T22:30:01+00:00'
end_time: '2025-10-25T23:00:00+00:00'
renewables: 154
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T09:30:00+10:00'
per_kwh: -0.02
spot_per_kwh: -0.02
start_time: '2025-10-25T23:00:01+00:00'
end_time: '2025-10-25T23:30:00+00:00'
renewables: 149
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T10:00:00+10:00'
per_kwh: -0.04
spot_per_kwh: -0.03
start_time: '2025-10-25T23:30:01+00:00'
end_time: '2025-10-26T00:00:00+00:00'
renewables: 147
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T10:30:00+10:00'
per_kwh: -0.04
spot_per_kwh: -0.04
start_time: '2025-10-26T00:00:01+00:00'
end_time: '2025-10-26T00:30:00+00:00'
renewables: 149
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T11:00:00+10:00'
per_kwh: -0.11
spot_per_kwh: -0.1
start_time: '2025-10-26T00:30:01+00:00'
end_time: '2025-10-26T01:00:00+00:00'
renewables: 144
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T11:30:00+10:00'
per_kwh: -0.04
spot_per_kwh: -0.04
start_time: '2025-10-26T01:00:01+00:00'
end_time: '2025-10-26T01:30:00+00:00'
renewables: 152
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T12:00:00+10:00'
per_kwh: -0.08
spot_per_kwh: -0.07
start_time: '2025-10-26T01:30:01+00:00'
end_time: '2025-10-26T02:00:00+00:00'
renewables: 155
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T12:30:00+10:00'
per_kwh: -0.17
spot_per_kwh: -0.16
start_time: '2025-10-26T02:00:01+00:00'
end_time: '2025-10-26T02:30:00+00:00'
renewables: 141
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T13:00:00+10:00'
per_kwh: -0.18
spot_per_kwh: -0.18
start_time: '2025-10-26T02:30:01+00:00'
end_time: '2025-10-26T03:00:00+00:00'
renewables: 143
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T13:30:00+10:00'
per_kwh: -0.18
spot_per_kwh: -0.18
start_time: '2025-10-26T03:00:01+00:00'
end_time: '2025-10-26T03:30:00+00:00'
renewables: 144
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T14:00:00+10:00'
per_kwh: -0.22
spot_per_kwh: -0.21
start_time: '2025-10-26T03:30:01+00:00'
end_time: '2025-10-26T04:00:00+00:00'
renewables: 141
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T14:30:00+10:00'
per_kwh: -0.23
spot_per_kwh: -0.22
start_time: '2025-10-26T04:00:01+00:00'
end_time: '2025-10-26T04:30:00+00:00'
renewables: 129
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T15:00:00+10:00'
per_kwh: -0.23
spot_per_kwh: -0.22
start_time: '2025-10-26T04:30:01+00:00'
end_time: '2025-10-26T05:00:00+00:00'
renewables: 130
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T15:30:00+10:00'
per_kwh: -0.17
spot_per_kwh: -0.16
start_time: '2025-10-26T05:00:01+00:00'
end_time: '2025-10-26T05:30:00+00:00'
renewables: 129
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T16:00:00+10:00'
per_kwh: -0.1
spot_per_kwh: -0.1
start_time: '2025-10-26T05:30:01+00:00'
end_time: '2025-10-26T06:00:00+00:00'
renewables: 132
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T16:30:00+10:00'
per_kwh: -0.07
spot_per_kwh: -0.07
start_time: '2025-10-26T06:00:01+00:00'
end_time: '2025-10-26T06:30:00+00:00'
renewables: 131
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T17:00:00+10:00'
per_kwh: -0.07
spot_per_kwh: -0.07
start_time: '2025-10-26T06:30:01+00:00'
end_time: '2025-10-26T07:00:00+00:00'
renewables: 125
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T17:30:00+10:00'
per_kwh: -0.03
spot_per_kwh: -0.03
start_time: '2025-10-26T07:00:01+00:00'
end_time: '2025-10-26T07:30:00+00:00'
renewables: 129
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T18:00:00+10:00'
per_kwh: -0.02
spot_per_kwh: -0.02
start_time: '2025-10-26T07:30:01+00:00'
end_time: '2025-10-26T08:00:00+00:00'
renewables: 133
spike_status: none
descriptor: extremely_low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T18:30:00+10:00'
per_kwh: -0.0
spot_per_kwh: -0.0
start_time: '2025-10-26T08:00:01+00:00'
end_time: '2025-10-26T08:30:00+00:00'
renewables: 140
spike_status: none
descriptor: low
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T19:00:00+10:00'
per_kwh: 0.07
spot_per_kwh: 0.07
start_time: '2025-10-26T08:30:01+00:00'
end_time: '2025-10-26T09:00:00+00:00'
renewables: 112
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T19:30:00+10:00'
per_kwh: 0.07
spot_per_kwh: 0.08
start_time: '2025-10-26T09:00:01+00:00'
end_time: '2025-10-26T09:30:00+00:00'
renewables: 106
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T20:00:00+10:00'
per_kwh: 0.07
spot_per_kwh: 0.07
start_time: '2025-10-26T09:30:01+00:00'
end_time: '2025-10-26T10:00:00+00:00'
renewables: 109
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T20:30:00+10:00'
per_kwh: 0.07
spot_per_kwh: 0.07
start_time: '2025-10-26T10:00:01+00:00'
end_time: '2025-10-26T10:30:00+00:00'
renewables: 105
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T21:00:00+10:00'
per_kwh: 0.06
spot_per_kwh: 0.06
start_time: '2025-10-26T10:30:01+00:00'
end_time: '2025-10-26T11:00:00+00:00'
renewables: 128
spike_status: none
descriptor: high
- duration: 30
date: '2025-10-26'
nem_date: '2025-10-26T21:30:00+10:00'
per_kwh: 0.06
spot_per_kwh: 0.06
start_time: '2025-10-26T11:00:01+00:00'
end_time: '2025-10-26T11:30:00+00:00'
renewables: 133
spike_status: none
descriptor: high```

1 reply

gcoan Oct 25, 2025
Collaborator

Ok that's good.

It's unlikely predbat would be enhanced to take in your specific sensor as that would be a never ending development job. Instead you'll have to write the template code to transform it to one of the formats already supported.

And as I said predbat currently only accepts rates at 30 minute granularity so you'll have to average the 5 minute spot prices.

As a proof of concept if you write a template sensor to create static data in the right format then that would be the first step to then writing something that reads your integration rates output

RangeyRover · 2025-10-26T05:46:43Z

RangeyRover
Oct 26, 2025
Author

Well, I think I've resolved an automation using MQTT broker to fake an octopus account
For anyone else daft enough to go on this journey.
Health warning, this is not yet perfected and I'm pretty sure my events are not firing properly.
I'd appreciate an octopus event sensor summary, and sensor summary from anyone using them @gcoan the pic was very useful, a txt file would be perfect.
octopus has:
event:import
Sensor:import
event:export
Sensor:export
if you have Amber Electric Home assistant Integration installed you can use an Automation to adapt the amber forecast to Octopus format to use in predbat.

description: ""
triggers:
  - trigger: homeassistant
    event: start
  - trigger: time_pattern
    minutes: /30
actions:
  - action: mqtt.publish
    data:
      topic: "{{ sensor_current_cfg_topic }}"
      retain: true
      payload: |-
        {
          "name": "Octopus import current rate",
          "unique_id": "{{ sensor_current_uid }}",
          "object_id": "{{ sensor_current_object_id }}",
          "state_topic": "{{ sensor_current_state_topic }}",
          "json_attributes_topic": "{{ sensor_current_attr_topic }}",
          "unit_of_measurement": "p/kWh",
          "device_class": "monetary",
          "icon": "mdi:lightning-bolt",
          "force_update": true
        }
  - action: mqtt.publish
    data:
      topic: "{{ sensor_current_attr_topic }}"
      retain: true
      payload: |-
        {
          "tariff_code": "custom_import",
          "serial_number": "{{ serial }}",
          "mpan": "{{ mpan }}",
          "rates": {{ rates_json }}
        }
  - action: mqtt.publish
    data:
      topic: "{{ sensor_current_state_topic }}"
      retain: true
      payload: "{{ current_rate_ppkwh }}"
  - action: mqtt.publish
    data:
      topic: "{{ event_day_cfg_topic }}"
      retain: true
      payload: |-
        {
          "name": "Octopus import current day rates",
          "unique_id": "{{ event_day_uid }}",
          "object_id": "{{ event_day_object_id }}",
          "state_topic": "{{ event_day_state_topic }}",
          "json_attributes_topic": "{{ event_day_attr_topic }}",
          "event_types": ["rates"]
        }
  - action: mqtt.publish
    data:
      topic: "{{ event_day_attr_topic }}"
      retain: true
      payload: |-
        {
          "tariff_code": "custom_import",
          "serial_number": "{{ serial }}",
          "mpan": "{{ mpan }}",
          "rates": {{ rates_json }},
          "all_rates": {{ rates_json }},
          "raw_today": {{ rates_json }},
          "prices": {{ rates_json }}
        }
  - action: mqtt.publish
    data:
      topic: "{{ event_day_state_topic }}"
      retain: true
      payload: "{{ last_update }}"
  - action: mqtt.publish
    data:
      topic: "{{ sensor_prev_cfg_topic }}"
      retain: true
      payload: |-
        {
          "name": "Octopus import previous rate",
          "unique_id": "{{ sensor_prev_uid }}",
          "object_id": "{{ sensor_prev_object_id }}",
          "state_topic": "{{ sensor_prev_state_topic }}",
          "json_attributes_topic": "{{ sensor_prev_attr_topic }}",
          "unit_of_measurement": "p/kWh",
          "device_class": "monetary",
          "icon": "mdi:lightning-bolt-outline",
          "force_update": true
        }
  - action: mqtt.publish
    data:
      topic: "{{ sensor_prev_attr_topic }}"
      retain: true
      payload: "{ \"all_rates\": {{ rates_json }} }"
  - action: mqtt.publish
    data:
      topic: "{{ sensor_prev_state_topic }}"
      retain: true
      payload: "{{ previous_rate_ppkwh }}"
mode: single
variables:
  serial: ELECTRIC1234567
  mpan: "1234567890123"
  sensor_current_object_id: octopus_energy_electricity_{{ serial|lower }}_{{ mpan|lower }}_current_rate
  event_day_object_id: >-
    octopus_energy_electricity_{{ serial|lower }}_{{ mpan|lower
    }}_current_day_rates
  sensor_prev_object_id: octopus_energy_electricity_{{ serial|lower }}_{{ mpan|lower }}_previous_rate
  sensor_current_uid: octo_import_current_rate_{{ serial }}_{{ mpan }}
  event_day_uid: octo_import_day_rates_{{ serial }}_{{ mpan }}
  sensor_prev_uid: octo_import_previous_rate_{{ serial }}_{{ mpan }}
  sensor_current_cfg_topic: homeassistant/sensor/{{ sensor_current_uid }}/config
  sensor_current_state_topic: home/octopus/{{ serial }}/{{ mpan }}/import_current_rate/state
  sensor_current_attr_topic: home/octopus/{{ serial }}/{{ mpan }}/import_current_rate/attributes
  event_day_cfg_topic: homeassistant/event/{{ event_day_uid }}/config
  event_day_state_topic: home/octopus/{{ serial }}/{{ mpan }}/import_current_day_rates/state
  event_day_attr_topic: home/octopus/{{ serial }}/{{ mpan }}/import_current_day_rates/attributes
  sensor_prev_cfg_topic: homeassistant/sensor/{{ sensor_prev_uid }}/config
  sensor_prev_state_topic: home/octopus/{{ serial }}/{{ mpan }}/import_previous_rate/state
  sensor_prev_attr_topic: home/octopus/{{ serial }}/{{ mpan }}/import_previous_rate/attributes
  rosella_forecasts: >-
    {{ state_attr('sensor.rosella_general_forecast', 'forecasts') | default([],
    true) }}
  current_slot: >-
    {%- set ts_now = now().timestamp() -%} {%- set ts0 = now().replace(hour=0,
    minute=0, second=0, microsecond=0).timestamp() -%} {{ ((ts_now - ts0) /
    1800) | int }}
  current_rate_ppkwh: >-
    {%- set ts_now = now().timestamp() -%} {%- set ts0 = now().replace(hour=0,
    minute=0, second=0, microsecond=0).timestamp() -%} {%- set s = ts0 +
    ((((ts_now - ts0) / 1800) | int ) * 1800) -%} {%- set e = s + 1800 -%} {%-
    set acc = namespace(sum=0.0, dur=0) -%} {%- for p in rosella_forecasts -%}
      {%- set ps = as_timestamp(p.start_time) -%}
      {%- set pe = as_timestamp(p.end_time) -%}
      {%- set os = [ps, s] | max -%}
      {%- set oe = [pe, e] | min -%}
      {%- if oe > os -%}
        {%- set d = oe - os -%}
        {%- set acc.sum = acc.sum + (p.per_kwh | float(0)) * d -%}
        {%- set acc.dur = acc.dur + d -%}
      {%- endif -%}
    {%- endfor -%} {{ ((acc.sum / acc.dur) if acc.dur > 0 else 0) * 100 |
    round(2) }}
  previous_rate_ppkwh: >-
    {%- set ts_now = now().timestamp() -%} {%- set ts0 = now().replace(hour=0,
    minute=0, second=0, microsecond=0).timestamp() -%} {%- set e = ts0 +
    ((((ts_now - ts0) / 1800) | int ) * 1800) -%} {%- set s = e - 1800 -%} {%-
    set acc = namespace(sum=0.0, dur=0) -%} {%- for p in rosella_forecasts -%}
      {%- set ps = as_timestamp(p.start_time) -%}
      {%- set pe = as_timestamp(p.end_time) -%}
      {%- set os = [ps, s] | max -%}
      {%- set oe = [pe, e] | min -%}
      {%- if oe > os -%}
        {%- set d = oe - os -%}
        {%- set acc.sum = acc.sum + (p.per_kwh | float(0)) * d -%}
        {%- set acc.dur = acc.dur + d -%}
      {%- endif -%}
    {%- endfor -%} {{ ((acc.sum / acc.dur) if acc.dur > 0 else 0) * 100 |
    round(2) }}
  rates_json: |-
    [ {%- set rosella = rosella_forecasts -%}
      {%- set ts0 = (now().replace(hour=0, minute=0, second=0, microsecond=0)) | as_timestamp -%}
      {%- for i in range(0,48) -%}
        {%- set s = ts0 + (i*1800) -%}
        {%- set e = ts0 + ((i+1)*1800) -%}
        {%- set acc = namespace(sum=0.0, dur=0) -%}
        {%- for p in rosella -%}
          {%- set ps = as_timestamp(p.start_time) -%}
          {%- set pe = as_timestamp(p.end_time) -%}
          {%- set os = [ps, s] | max -%}
          {%- set oe = [pe, e] | min -%}
          {%- if oe > os -%}
            {%- set d = oe - os -%}
            {%- set acc.sum = acc.sum + (p.per_kwh | float(0)) * d -%}
            {%- set acc.dur = acc.dur + d -%}
          {%- endif -%}
        {%- endfor -%}
        {%- set avg = (acc.sum / acc.dur) if acc.dur > 0 else 0 -%}
        {"start":"{{ s | timestamp_custom('%Y-%m-%dT%H:%M:%S+00:00', false) }}",
         "end":"{{ e | timestamp_custom('%Y-%m-%dT%H:%M:%S+00:00', false) }}",
         "value_inc_vat":{{ (avg) | round(2) }},
         "is_capped":false,
         "is_intelligent_adjusted":false}{{ "," if i < 47 else "" }}
      {%- endfor -%} ]
  last_update: "{{ now().isoformat() }}"

Export:

description: ""
triggers:
  - event: start
    trigger: homeassistant
  - minutes: /30
    trigger: time_pattern
actions:
  - data:
      topic: "{{ sensor_current_cfg_topic }}"
      retain: true
      payload: |-
        {
          "name": "Octopus export current rate",
          "unique_id": "{{ sensor_current_uid }}",
          "object_id": "{{ sensor_current_object_id }}",
          "state_topic": "{{ sensor_current_state_topic }}",
          "json_attributes_topic": "{{ sensor_current_attr_topic }}",
          "unit_of_measurement": "p/kWh",
          "device_class": "monetary",
          "icon": "mdi:lightning-bolt",
          "force_update": true
        }
    action: mqtt.publish
  - data:
      topic: "{{ sensor_current_attr_topic }}"
      retain: true
      payload: |-
        {
          "tariff_code": "custom_export",
          "serial_number": "{{ serial }}",
          "mpan": "{{ mpan }}",
          "rates": {{ rates_json }}
        }
    action: mqtt.publish
  - data:
      topic: "{{ sensor_current_state_topic }}"
      retain: true
      payload: "{{ current_rate_ppkwh }}"
    action: mqtt.publish
  - data:
      topic: "{{ event_day_cfg_topic }}"
      retain: true
      payload: |-
        {
          "name": "Octopus export current day rates",
          "unique_id": "{{ event_day_uid }}",
          "object_id": "{{ event_day_object_id }}",
          "state_topic": "{{ event_day_state_topic }}",
          "json_attributes_topic": "{{ event_day_attr_topic }}",
          "event_types": ["rates"]
        }
    action: mqtt.publish
  - data:
      topic: "{{ event_day_attr_topic }}"
      retain: true
      payload: |-
        {
          "tariff_code": "custom_export",
          "serial_number": "{{ serial }}",
          "mpan": "{{ mpan }}",
          "rates": {{ rates_json }},
          "all_rates": {{ rates_json }},
          "raw_today": {{ rates_json }},
          "prices": {{ rates_json }}
        }
    action: mqtt.publish
  - data:
      topic: "{{ event_day_state_topic }}"
      retain: true
      payload: "{{ last_update }}"
    action: mqtt.publish
  - data:
      topic: "{{ sensor_prev_cfg_topic }}"
      retain: true
      payload: |-
        {
          "name": "Octopus export previous rate",
          "unique_id": "{{ sensor_prev_uid }}",
          "object_id": "{{ sensor_prev_object_id }}",
          "state_topic": "{{ sensor_prev_state_topic }}",
          "json_attributes_topic": "{{ sensor_prev_attr_topic }}",
          "unit_of_measurement": "p/kWh",
          "device_class": "monetary",
          "icon": "mdi:lightning-bolt-outline",
          "force_update": true
        }
    action: mqtt.publish
  - data:
      topic: "{{ sensor_prev_attr_topic }}"
      retain: true
      payload: "{ \"all_rates\": {{ rates_json }} }"
    action: mqtt.publish
  - data:
      topic: "{{ sensor_prev_state_topic }}"
      retain: true
      payload: "{{ previous_rate_ppkwh }}"
    action: mqtt.publish
mode: single
variables:
  serial: ELECTRIC1234567
  mpan: "1234567890123"
  sensor_current_object_id: >-
    octopus_energy_electricity_{{ serial|lower }}_{{ mpan|lower
    }}_export_current_rate
  event_day_object_id: >-
    octopus_energy_electricity_{{ serial|lower }}_{{ mpan|lower
    }}_export_current_day_rates
  sensor_prev_object_id: >-
    octopus_energy_electricity_{{ serial|lower }}_{{ mpan|lower
    }}_export_previous_rate
  rosella_forecasts: >-
    {{ state_attr('sensor.rosella_feed_in_forecast', 'forecasts') | default([],
    true) }}
  sensor_current_uid: octo_export_current_rate_{{ serial }}_{{ mpan }}
  event_day_uid: octo_export_day_rates_{{ serial }}_{{ mpan }}
  sensor_prev_uid: octo_export_previous_rate_{{ serial }}_{{ mpan }}
  sensor_current_cfg_topic: homeassistant/sensor/{{ sensor_current_uid }}/config
  sensor_current_state_topic: home/octopus/{{ serial }}/{{ mpan }}/export_current_rate/state
  sensor_current_attr_topic: home/octopus/{{ serial }}/{{ mpan }}/export_current_rate/attributes
  event_day_cfg_topic: homeassistant/event/{{ event_day_uid }}/config
  event_day_state_topic: home/octopus/{{ serial }}/{{ mpan }}/export_current_day_rates/state
  event_day_attr_topic: home/octopus/{{ serial }}/{{ mpan }}/export_current_day_rates/attributes
  sensor_prev_cfg_topic: homeassistant/sensor/{{ sensor_prev_uid }}/config
  sensor_prev_state_topic: home/octopus/{{ serial }}/{{ mpan }}/export_previous_rate/state
  sensor_prev_attr_topic: home/octopus/{{ serial }}/{{ mpan }}/export_previous_rate/attributes
  current_slot: >-
    {%- set ts_now = now().timestamp() -%} {%- set ts0 = now().replace(hour=0,
    minute=0, second=0, microsecond=0).timestamp() -%} {{ ((ts_now - ts0) /
    1800) | int }}
  current_rate_ppkwh: "{{ current_slot | int + 1 }}"
  previous_rate_ppkwh: "{{ current_slot | int }}"
  rates_json: >-
    [ {%- set rosella =
    state_attr('sensor.rosella_feed_in_forecast','forecasts') | default([]) -%}
      {%- set ts0 = (now().replace(hour=0, minute=0, second=0, microsecond=0)) | as_timestamp -%}
      {%- for i in range(0,48) -%}
        {%- set s = ts0 + (i*1800) -%}
        {%- set e = ts0 + ((i+1)*1800) -%}
        {%- set acc = namespace(sum=0.0, dur=0) -%}
        {%- for p in rosella -%}
          {%- set ps = as_timestamp(p.start_time) -%}
          {%- set pe = as_timestamp(p.end_time) -%}
          {%- set os = [ps, s] | max -%}
          {%- set oe = [pe, e] | min -%}
          {%- if oe > os -%}
            {%- set d = oe - os -%}
            {%- set acc.sum = acc.sum + (p.per_kwh | float(0)) * d -%}
            {%- set acc.dur = acc.dur + d -%}
          {%- endif -%}
        {%- endfor -%}
        {%- set avg = (acc.sum / acc.dur) if acc.dur > 0 else 0 -%}
        {"start":"{{ s | timestamp_custom('%Y-%m-%dT%H:%M:%S+00:00', false) }}",
         "end":"{{ e | timestamp_custom('%Y-%m-%dT%H:%M:%S+00:00', false) }}",
         "value_inc_vat":{{ (avg) | round(2) }},
         "is_capped":false,
         "is_intelligent_adjusted":false}{{ "," if i < 47 else "" }}
      {%- endfor -%} ]
  last_update: "{{ now().isoformat() }}"

3 replies

gcoan Oct 26, 2025
Collaborator

this is impressive @RangeyRover I wasn't expecting you to fake up an entire Octopus event structure using MQTT, its a bit complicated because of the way the Octopus integration works and predbat reads from the sensor name in apps.yaml to find the current and previous events.

I was expecting you would just create a single template sensor with the raw_today and raw_tomorrow attributes and configure apps.yaml to point to that sensor

https://springfall2008.github.io/batpred/energy-rates/#other-energy-spot-rate-sensor-integrations

See the CZ example https://gist.github.com/ziat007/ae29e26ae257f069520b65f0168c3a6b

I'd appreciate an octopus event sensor summary, and sensor summary from anyone using them @gcoan the pic was very useful, a txt file would be perfect.

Am not sure what you are asking for me to share with you?

RangeyRover Oct 26, 2025
Author

I thought that was what was needed.
I missed this snippet in the energy rates section
metric_octopus_import: 'sensor.current_buy_electricity_price_raw' metric_octopus_export: `'sensor.current_sell_electricity_price_raw'
I also did not know the schema for raw data input, and octopus had a published schema
From the example you gave it seems the schema is:
{ "entity_id": "sensor.current_buy_electricity_price_raw", "state": "5.23456", "attributes": { "raw_today": [ { "start": "2025-10-27T00:00:00+00:00", "end": "2025-10-27T01:00:00+00:00", "value": 5.12345 }, { "start": "2025-10-27T01:00:00+00:00", "end": "2025-10-27T02:00:00+00:00", "value": 4.98765 } // ... continues for all available hours today ], "raw_tomorrow": [ { "start": "2025-10-28T00:00:00+00:00", "end": "2025-10-28T01:00:00+00:00", "value": 5.67890 }, { "start": "2025-10-28T01:00:00+00:00", "end": "2025-10-28T02:00:00+00:00", "value": 5.34567 } // ... continues for all available hours tomorrow ], "unit_of_measurement": "Kč/kWh", "icon": "mdi:cash-multiple", "friendly_name": "Current Buy Electricity Price Raw", "state_class": "measurement" }, "last_changed": "2025-10-27T10:30:00.123456+00:00", "last_updated": "2025-10-27T10:30:00.123456+00:00" }

Those are the bits I was missing from the docs. One is on me for sure I missed it.
The schema for input for the raw sensor would have been useful in the docs.
The bits I was looking for were related to schema of octopus sensor and events, but it seems its working, so no worries.
I doubt I will change it now, its functional.
"Nothing is as permanent as a temporary fix"

gcoan Oct 27, 2025
Collaborator

The schema for input for the raw sensor would have been useful in the docs.
The bits I was looking for were related to schema of octopus sensor and events, but it seems its working, so no worries.

Yes I agree, this part of the documentation could do with being expanded a bit further, we've not had many people write their own rate configurations so it's not been touched much.

You can get the schema from reading the CZ example, but agree, it should be more explicitly documented.

Are you happy enough with your example for it to be added to the docs?

RangeyRover · 2025-10-27T05:59:17Z

RangeyRover
Oct 27, 2025
Author

@gcoan
Happy for it be added, here is the latest.
It can be done completely from the UI, as thats a goal I set myself.
Amber Electric- Octopus Import
Octopus Import Today.yaml
It needs Mosquitto Broker installed to address the Octopus events and sensor.
It needs Amber Electric Home assistant to be installed, it's using their forecast sensors.
It needs metric_octopus_import: activating in apps.yaml

0 replies

WyndStryke · 2025-10-27T16:59:43Z

WyndStryke
Oct 27, 2025

Interestingly Amber's VPP is coming to the UK in the form of E-on Next's Solar Max (pilot) tariff. It looks somewhat like a hybrid of Intelligent Flux and Agile. It would normally control the inverter, but you can override it whenever you like (so either run predbat in read-only mode, or perhaps let predbat take control at times). Perhaps could also be another source of wholesale prices even if you are not on the tariff. So I wonder if we'll get a somewhat similar data source to work from. I'd guess half hourly rather than every 5 minutes, and from what I understand from the Solar Max Ts&Cs, the prices can continually evolve through the day, until the actual start of the half-hour slot. https://www.eonnext.com/tariffs/next-solar-max

0 replies

Uh oh!

Using Amber Electric Home Assistant import and export rates and forecast #2822

Uh oh!

RangeyRover Oct 25, 2025

Replies: 5 comments · 9 replies

Uh oh!

RangeyRover Oct 25, 2025 Author

Uh oh!

gcoan Oct 25, 2025 Collaborator

Uh oh!

gcoan Oct 25, 2025 Collaborator

Uh oh!

RangeyRover Oct 25, 2025 Author

Uh oh!

gcoan Oct 25, 2025 Collaborator

Uh oh!

RangeyRover Oct 25, 2025 Author

Uh oh!

Uh oh!

RangeyRover Oct 25, 2025 Author

Uh oh!

gcoan Oct 25, 2025 Collaborator

Uh oh!

Uh oh!

RangeyRover Oct 26, 2025 Author

Uh oh!

gcoan Oct 26, 2025 Collaborator

Uh oh!

Uh oh!

RangeyRover Oct 26, 2025 Author

Uh oh!

gcoan Oct 27, 2025 Collaborator

Uh oh!

RangeyRover Oct 27, 2025 Author

Uh oh!

Uh oh!

WyndStryke Oct 27, 2025

RangeyRover
Oct 25, 2025

Replies: 5 comments 9 replies

RangeyRover
Oct 25, 2025
Author

gcoan Oct 25, 2025
Collaborator

gcoan Oct 25, 2025
Collaborator

RangeyRover Oct 25, 2025
Author

gcoan Oct 25, 2025
Collaborator

RangeyRover Oct 25, 2025
Author

RangeyRover
Oct 25, 2025
Author

gcoan Oct 25, 2025
Collaborator

RangeyRover
Oct 26, 2025
Author

gcoan Oct 26, 2025
Collaborator

RangeyRover Oct 26, 2025
Author

gcoan Oct 27, 2025
Collaborator

RangeyRover
Oct 27, 2025
Author

WyndStryke
Oct 27, 2025