- Category: AMS
Even if "Forskrift om kraftomsetning og nettjenester" §4-2f says AMS should "kunne sende og motta informasjon om kraftpriser og tariffer", AFAIC none of the Norwegian power companies sends spotprices to customers AMS. Tibber has an API its paying customers can use, and Nordpool has Norwegian day-ahead prices available for the ridiculous price of €900/year. ENTSO-E provides day-ahead prices free of charge for registered users. To help home-automation, I have made a few utilities that fetches spotprices from ENTSO-E and publishes these as SVG and as MQTT topics.
SVG
For SVG graphs, you can find today spotprices in Euro and Norwegian Kroner, and tomorrow spotprices (updated around 1400UTC) in Euro and Norwegian Kroner
Grafana
There are also quite a few Grafana dashboards available. The most useful are probably current spotprice in Euro and Norwegian Kroner, but you can also see what are cheap and what are expensive hours for Oslo, Kristiansand, Trondheim, Tromsø and Bergen, and exchange rate Euro vs Norwegian Kroner is also available.
MQTT
For home automation, there are also quite a lot of MQTT topics you can subscribe to.
The code behind this is available at github. Server is running in Amazon EC2, and there is a Munin status page.
- Category: AMS
Public, read-only MQTT server is available at gillhub.org port 8883 (TLS) or port 1883 (plaintext), and have these topics:
| MQTT Topic | Description |
| nordpool/today/exchangerate | Exchangerate used for EUR-NOK. Set to NOK for 1EUR |
| nordpool/today/<sone>/nok | Current price in NOK. Set to NOK/KWh |
| nordpool/today/<sone>/eur | Current price in EUR. Set to EUR/KWh |
| nordpool/today/<sone>/order | Current order, from most expensive (0) to least expensive (23). Set to 0-23 |
| nordpool/today/<sone>/nok<[00]-[23]> | Price in NOK for a given hour. Set to NOK/KWh |
| nordpool/today/<sone>/eur<[00]-[23]> | Price in EUR for a given hour. Set to EUR/KWh |
| nordpool/today/<sone>/order[00]-[23]> | Order for a given hour, from most expensive (0) to least expensive (23). Set to 0-23 |
| nordpool/today/<sone>/sorted<[0]-[23]> | Hour reference from the most expensive (0) to least expensive (23). Set to 00-23 |
| nordpool/tomorrow/exchangerate | Exchangerate used for EUR-NOK. Set to NOK for 1EUR |
| nordpool/tomorrow/<sone>/nok<[00]-[23]> | Price in NOK for a given hour. Set to NOK/KWh |
| nordpool/tomorrow/<sone>/eur<[00]-[23]> | Price in EUR for a given hour. Set to EUR/KWh |
| nordpool/tomorrow/<sone>/order[00]-[23]> | Order for a given hour, from most expensive (0) to least expensive (23). Set to 0-23 |
| nordpool/tomorrow/<sone>/sorted<[0]-[23]> | Hour reference from the most expensive (0) to least expensive (23). Set to 00-23 |
(<sone> is "NO-1" for Oslo, "NO-2" for Kristiansand, "NO-3" for Trondheim, "NO-4" for Tromsø or "NO-5" for Bergen)
The prices for tomorrow is available from around 1400UTC today.
Examples:
To get current price for Oslo in Norwegian Kroner, subscribe to nordpool/today/NO-1/nok
To follow the price for the hour 0700-0759 Europe/Oslo timezone for Kristiansand in Euro, subscribe to nordpool/today/NO-2/eur07
To find the two most expensive hours in Trondheim, subscribe to nordpool/today/NO-3/sorted0 and nordpool/today/NO-3/sorted1
Connecting to current Oslo price i Euro using mosquitto_sub (from mosquitto-clients): "mosquitto_sub -h gillhub.org -p 8883 --capath /etc/ssl/certs -t nordpool/today/NO-1/eur"
- Category: AMS
- Category: AMS
- Category: AMS
- Category: AMS