Jinja template to extract highest forecast price

[micarex]

Before I try figuring it out myself, has anyone created a Jinja template to extract the highest price from the forecast values?

[micarex]

Figured it out. Posting in case useful to others

{%- set ns = namespace(highval={}) %}
{%- for intervals in states.sensor.amber_35_general_forecast.attributes["forecasts"] %}
{%- if loop.index0==0 %}
{%- set ns.highval=intervals["per_kwh"] | float %}
{%- endif %}
{%- if intervals['per_kwh'] | float > ns.highval | float %}
{%- set ns.highval=intervals["per_kwh"] | float %}
{%- endif %}
{%- endfor %}
{{ ns.highval }}

Sample data*
forecasts:

• duration: 30
  nem_date: '2021-08-14T22:30:00+10:00'
  per_kwh: 22
  spot_per_kwh: 8
  start_time: '2021-08-14T12:00:01+00:00'
  end_time: '2021-08-14T12:30:00+00:00'
  renewables: 21
  spike_status: none
  range_min: 4.68735
  range_max: 31.12405
• duration: 30
  nem_date: '2021-08-14T23:00:00+10:00'
  per_kwh: 22
  spot_per_kwh: 8
  start_time: '2021-08-14T12:30:01+00:00'
  end_time: '2021-08-14T13:00:00+00:00'
  renewables: 22
  spike_status: none
  range_min: 0.918
  range_max: 24
• duration: 30
  nem_date: '2021-08-14T23:30:00+10:00'
  per_kwh: 20
  spot_per_kwh: 7
  start_time: '2021-08-14T13:00:01+00:00'
  end_time: '2021-08-14T13:30:00+00:00'
  renewables: 23
  spike_status: none
  range_min: 0.91801
  range_max: 24
• duration: 30
  nem_date: '2021-08-15T00:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 2
  start_time: '2021-08-14T13:30:01+00:00'
  end_time: '2021-08-14T14:00:00+00:00'
  renewables: 24
  spike_status: none
  range_min: 0.904
  range_max: 12.3
• duration: 30
  nem_date: '2021-08-15T00:30:00+10:00'
  per_kwh: 19
  spot_per_kwh: 6
  start_time: '2021-08-14T14:00:01+00:00'
  end_time: '2021-08-14T14:30:00+00:00'
  renewables: 25
  spike_status: none
  range_min: 0.904
  range_max: 11.33322
• duration: 30
  nem_date: '2021-08-15T01:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T14:30:01+00:00'
  end_time: '2021-08-14T15:00:00+00:00'
  renewables: 27
  spike_status: none
  range_min: 0.895
  range_max: 7.36717
• duration: 30
  nem_date: '2021-08-15T01:30:00+10:00'
  per_kwh: 17
  spot_per_kwh: 4
  start_time: '2021-08-14T15:00:01+00:00'
  end_time: '2021-08-14T15:30:00+00:00'
  renewables: 28
  spike_status: none
  range_min: 0.895
  range_max: 5.73273
• duration: 30
  nem_date: '2021-08-15T02:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T15:30:01+00:00'
  end_time: '2021-08-14T16:00:00+00:00'
  renewables: 30
  spike_status: none
  range_min: 0.895
  range_max: 5.51308
• duration: 30
  nem_date: '2021-08-15T02:30:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T16:00:01+00:00'
  end_time: '2021-08-14T16:30:00+00:00'
  renewables: 32
  spike_status: none
  range_min: 0.894
  range_max: 5.54056
• duration: 30
  nem_date: '2021-08-15T03:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T16:30:01+00:00'
  end_time: '2021-08-14T17:00:00+00:00'
  renewables: 33
  spike_status: none
  range_min: -0.08317
  range_max: 5.33892
• duration: 30
  nem_date: '2021-08-15T03:30:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T17:00:01+00:00'
  end_time: '2021-08-14T17:30:00+00:00'
  renewables: 34
  spike_status: none
  range_min: -0.08106
  range_max: 4.74513
• duration: 30
  nem_date: '2021-08-15T04:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T17:30:01+00:00'
  end_time: '2021-08-14T18:00:00+00:00'
  renewables: 35
  spike_status: none
  range_min: -0.09158
  range_max: 3.99736
• duration: 30
  nem_date: '2021-08-15T04:30:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T18:00:01+00:00'
  end_time: '2021-08-14T18:30:00+00:00'
  renewables: 36
  spike_status: none
  range_min: -3.1
  range_max: 3.91963
• duration: 30
  nem_date: '2021-08-15T05:00:00+10:00'
  per_kwh: 13
  spot_per_kwh: 0
  start_time: '2021-08-14T18:30:01+00:00'
  end_time: '2021-08-14T19:00:00+00:00'
  renewables: 37
  spike_status: none
  range_min: -3.65841
  range_max: 3.80712
• duration: 30
  nem_date: '2021-08-15T05:30:00+10:00'
  per_kwh: 13
  spot_per_kwh: 0
  start_time: '2021-08-14T19:00:01+00:00'
  end_time: '2021-08-14T19:30:00+00:00'
  renewables: 37
  spike_status: none
  range_min: -3.65841
  range_max: 3.84306
• duration: 30
  nem_date: '2021-08-15T06:00:00+10:00'
  per_kwh: 12
  spot_per_kwh: 0
  start_time: '2021-08-14T19:30:01+00:00'
  end_time: '2021-08-14T20:00:00+00:00'
  renewables: 37
  spike_status: none
  range_min: -3.6762
  range_max: 3.13735
• duration: 30
  nem_date: '2021-08-15T06:30:00+10:00'
  per_kwh: 13
  spot_per_kwh: 0
  start_time: '2021-08-14T20:00:01+00:00'
  end_time: '2021-08-14T20:30:00+00:00'
  renewables: 37
  spike_status: none
  range_min: -3.68804
  range_max: 3.73847
• duration: 30
  nem_date: '2021-08-15T07:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T20:30:01+00:00'
  end_time: '2021-08-14T21:00:00+00:00'
  renewables: 36
  spike_status: none
  range_min: -3.1
  range_max: 4.33318
• duration: 30
  nem_date: '2021-08-15T07:30:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T21:00:01+00:00'
  end_time: '2021-08-14T21:30:00+00:00'
  renewables: 34
  spike_status: none
  range_min: -0.05662
  range_max: 5.04173
• duration: 30
  nem_date: '2021-08-15T08:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T21:30:01+00:00'
  end_time: '2021-08-14T22:00:00+00:00'
  renewables: 36
  spike_status: none
  range_min: 0.0304
  range_max: 5.14209
• duration: 30
  nem_date: '2021-08-15T08:30:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T22:00:01+00:00'
  end_time: '2021-08-14T22:30:00+00:00'
  renewables: 40
  spike_status: none
  range_min: 0.374
  range_max: 4.0763
• duration: 30
  nem_date: '2021-08-15T09:00:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T22:30:01+00:00'
  end_time: '2021-08-14T23:00:00+00:00'
  renewables: 45
  spike_status: none
  range_min: -0.07874
  range_max: 3.23408
• duration: 30
  nem_date: '2021-08-15T09:30:00+10:00'
  per_kwh: 14
  spot_per_kwh: 1
  start_time: '2021-08-14T23:00:01+00:00'
  end_time: '2021-08-14T23:30:00+00:00'
  renewables: 50
  spike_status: none
  range_min: -3.1
  range_max: 3.24417