Ontario Canada will be able to pull their data from Green Button

Third party integrations
42

It’s been pretty obvious from additional research, including all the above DATA that this Green Button initiative in Ontario (at least) has been bastardized into a money making opportunity for a select few. It comes as no surprise as this is also how licensed trades contracting is managed in Ontario. You pay to play, everyone else gets shut out, including the consumer. Ontario (and Canada, regardless of ruling party) has been and will continue to be, dedicated to anti-consumer legislation.

Instead of paying to play games, I’ve instead been investing elsewhere.

43

Hourly Ottawa hydro data can be read using an SDR thanks to Clayton Smith.

Water usage also…
https://irrational.net/2019/03/26/tracking-down-a-water-leak/

44

Did you get the Hydro Ottawa electricity meter reading working in home assistant? i’d be curious in seeing that published

45

I’m just getting started with HA, it will be a while before I try it.

46

There’s still a fair bit of work to develop the integration. It was just a proof of concept you found

47

A bit late to the party, but I actually have a certificate of insurance for my IT consulting business, anyone have any resources on how to sign up for HydroOne as a 3rd party service provider? I have recently added full power monitoring to my panels, I’m curious how it lines up with what I’m actually getting billed for. It’s been a bit of a rabbit hole for sure.

48

Looks like this project (not Home Assistant related), is accomplishing what we need. Wonder if anyone could use this as an example?

49

It all relies on a specific service provider/aggregator. If you utility, like mine, is not using this one then you are note necessarily out of the woods.
It is a step in the right direction but the key problem is the utilities are trying to do the minimum…

50

Enova Power Kitchener / Waterloo area supports the green button.I was hoping to be able to import the data.

I ended up ordering a Emporia Energy Vue Home Energy Monitor - Gen 3 from Rona yesterday for $163+tax CAD, free shipping. (if you do, don’t forget the $15 off coupon! it makes it cheaper then ordering from the US), hopefully the install is fairly easily.

https://www.rona.ca/en/product/emporia-energy-vue-home-energy-monitor-gen-3-332049829

51

Thanks for sharing the helpful tip. Could you let us know how you got the $15 coupon?

52

it was just on the main rona page to sign up with an email address.

53

I’ve had a bit of success importing Hydro Ottawa green button data into HA and having it appear on the HA energy dashboard. See this post.

Note that I have to use their website to manually download the ESPI xml - there’s no polling.

54

Hey folks, just wanted to share that I was able to have my Toronto Hydro data automatically imported. It lags behind a day but otherwise works pretty well.

It mostly relies upon some work done by others (web scraping to download the data, and a custom integration to import it), so original credits to them. I forked & edited the web scraping tool because the website had been updated since it was written.

Instructions for home assistant are here

55

Is the xml being parsed ok? I have a report that Toronto Hydro provides uom of 38 (Watts). I haven’t heard back if it also provides uom 72 (Wh).

56

yeah, the data being displayed in homeassistant matches what’s shown in the hourly breakdown on my account (0.89kWh from 7-8pm)

image
image1644×444 18.5 KB

image
image1201×440 16.1 KB

57

would xml files from Enova Power (Kitchener-Waterloo) be in a similar format? or is that something that could be supported?

58

Presumably, yes, if you use their Green Button data. Not sure yet how different utilities make use of the various options within the ESPI definition used for Green Button stuff.

59

Hi everyone, I wanted to share a solution for Ottawa I’ve been using reliably for ~9months.

How does it work?

  • It’s a Google Clound Run Function
  • Home Assistant connects to it every minute to fetch data
  • It uses Caching on Google Cloud to only fetch from Hydro API once an hour
  • It uses a function so a number is continuously going up, so the metering in home assistant works accurately
  • Due to API limitations, it shows you yesterday’s hydro usage at this time

You can find the source code here. It’s a fork of my friend Philip’s solution, but adapted to work in Home Assistant.

Configured like this:

  - platform: rest
    name: "Hydro Ottawa Usage (Hour)"
    resource: https://your-google-cloud-url.run.app/casa
    method: GET
    unique_id: 888f5a9c-d0ff-409d-ae1e-e34d131cc3eb
    scan_interval: 600
    value_template: "{{ value_json.currentUsage.incrementingHourlyCounter }}"
    unit_of_measurement: "kWh"
    device_class: energy
    state_class: total_increasing
  - platform: rest
    name: "Hydro Ottawa Tier Pricing"
    unique_id: 4712bf34-86b9-4555-9392-994be062000f
    resource: https://your-google-cloud-url.run.app/casa
    method: GET
    scan_interval: 600
    value_template: "{{ value_json.currentUsage.tierPricing }}"
    unit_of_measurement: "CAD/kWh"
    device_class: monetary
    state_class: total
    icon: mdi:currency-cad

image
image2232×1344 126 KB

it would be amazing if HASS had a way to import historical energy usage, it currently considers yesterday’s energy usage as today (it always lags behind by a day)

60

Very interested in this but i’m unsure how to implement it.

61

Same here I’d love to use this but I’m with Milton Hydro, not sure anyone has it working yet.