Texas Electricity Grid Monitor

Awesome! Works great. Thanks very much!

Here’s a sensor for the current wholesale price per kilowatt. I needed something that would alert me so that I would know to dump the Powerwalls to the grid. Normally the wholesale price is around $0.02. Yesterday it hit nearly $5.00. It is one of my first sensors and some of my first Jija, so feedback and tips welcome. It basically loops through the JSON response and delivers the wholesale average that corresponds to the highest timestamp in the record.

- platform: rest
    scan_interval: 900
    unit_of_measurement: "$"
    unique_id: ercot_realtime_system_wide_prices
    icon: mdi:transmission-tower
    name: "ERCOT Realtime Wholesale per kWh"
    resource: "https://www.ercot.com/api/1/services/read/dashboards/systemWidePrices.json"
    value_template: >-
      {% set nsmi = namespace(max_interval = 0) %}
      {% set nshba = namespace(hbBusAvg = 0) %}
      {% for data in value_json.rtSppData %}
        {% if data['interval'] > nsmi.max_interval %}
          {% set nsmi.max_interval = data['interval'] %}
          {% set nshba.hbBusAvg = data['hbBusAvg'] %}
        {% endif %}
      {% endfor %}

I’m currently getting “Entity not available: sensor.grid_operating_reserves” Does yours still work? Do you mind providing your sensor configuration?

This post from above should be the needed config.

Thank you so much for this info. I was struggling with the github config. I was able to get it to collect data but the Current Reading sensor didn’t work in the Energy Dashboard. Your changes work great!

I did have to remove the smartmetertexas: value at the top of the smt package and also added a sensor for the hourly energy reading.


      - state_topic: "smt/reading"
        unit_of_measurement: "kWh"
        name: Smart Meter Texas Current Reading
        unique_id: smart_meter_texas_current_reading
        device_class: energy

    - platform: template

          friendly_name: Hourly Energy
          unit_of_measurement: 'kWh'
          value_template: "{{ state_attr('sensor.hourly_energy','last_period') }}"
          icon_template: mdi:counter

      source: sensor.smart_meter_texas_current_reading
      name: Hourly Energy
      cycle: hourly
      source: sensor.smart_meter_texas_current_reading
      name: Daily Energy
      cycle: daily
      source: sensor.smart_meter_texas_current_reading
      name: Monthly Energy
      cycle: monthly

      icon: mdi:currency-usd
      name: Electricity Cost
      mode: box
      min: 0
      max: 2.50
      step: .001
      unit_of_measurement: "$/kWh"

This post might be redundant but hopefully this helps another following mnewm4’s great templates.

I did some tinkering and reading through this thread and had to make changes to get this working for me as of 8 September 2023. I am running:

  • Home Assistant 2023.9.0
  • Supervisor 2023.08.3
  • Operating System 10.5
  • Frontend 20230906.1 - latest

I added this into my configuration.yaml to add the sensors ‘sensor.ercot_status’ (for the text conditions in the later Markdown card) and ‘sensor.ercot_reserves’ (for the needle gauge card) into the “sensor:” section of the file.


# there may be tons of other sensors in here already
  - platform: rest
    scan_interval: 300
    unique_id: ercot_status
    icon: mdi:transmission-tower
    name: Ercot Status
    resource: "https://www.ercot.com/api/1/services/read/dashboards/daily-prc.json"
    value_template: "{{value_json.current_condition.state}}"
    json_attributes_path: "$.current_condition"
      - energy_level_value
      - title
      - condition_note
      - eea_level
      - prc_value
      - datetime
  - platform: template
        unique_id: ercot_grid_operating_reserves
        friendly_name: "Ercot Operating Reserves"
        unit_of_measurement: MW
        icon_template: mdi:transmission-tower
        value_template: >-
          {{states.sensor.ercot_status.attributes.prc_value.replace(",", "") }}

I then added these into a default Lovelace card of “Vertical Stack” with the following yaml code:

type: vertical-stack
  - type: gauge
    entity: sensor.ercot_reserves
    needle: true
    min: 1
    max: 7000
      - from: 1
        color: '#000000'
      - from: 1000
        color: '#FF0000'
      - from: 1750
        color: '#FFA500'
      - from: 2300
        color: '#FFFF00'
      - from: 2900
        color: '#008000'
    name: Electricity Grid Operating Reserves
    unit: MW
  - type: markdown
    content: >-
      <table width="100%">
      <td><h2> {{ state_attr('sensor.ercot_status','title') }} </h2> </td>
      <td align='right'><font color='#44739e'> <ha-icon icon="{{ state_attr( 'sensor.ercot_status', 'icon' ) }}"></font></ha-icon></td>
      <td colspan="2"> {{ state_attr( 'sensor.ercot_status', 'condition_note' )
      }} </td>

And that results in this Vertical Stack card:

If the Markdown card doesn’t work on a copy and paste, then double check that the copy paste operation from your browser over to your card yaml input didn’t insert and create extra line breaks. For example, the “<td align… </ha-icon></td>” should be on one line and “<td colspan… </td>” should be on one line inside the card’s yaml.

Best of luck!


Just validating, @selfjc’s post above worked “out of the box” for me in January 2024. Thanks for the research and effort all!

Thank you @selfjc I just added the Ercot Grid Monitor :smiley: and confirming it is still properly working in June of 2024!