Energy Forecast Binding

Add-on Marketplace Bundles
, ,
22

Entso-e has a problem with its data provider (jao.eu) to share the day-ahead prices through their API again. The Energyforecast API is still able to deliver the market data. Looking forward to receive the 48h data through this binding.

23

For no apparent reason, I have not been receiving any data via the channels since at least yesterday, Friday. Energyforecast has always been NULL. However, the API with the key token via the web API. Since at least yesterday, the day-ahead price has also been NULL. I have recreated the thing several times, changed the values, but nothing has changed.

image
image510Ɨ598 28.7 KB
I have anonymized the token.

image
image763Ɨ173 13.9 KB

Does anyone have any ideas about what might be going wrong? The day-ahead price via ENTSO-E is working.

24

I noticed the same behaviour a couple of days ago.

What i did:
In the OpenHab console:
bundle:list for getting the start ID number
bundle:stop ID-nr
bundle:start ID-nr

Of course this does not address why it stopped working, but at least i got it going again.

Edit: today it stopped working again and i needed to restart the binding.

ENTSO-E Binding: Went offline
25

No, restarting did not solve the issue.I still canā€™t get any values via the channel.

26

Letā€™s make a small reset. In the previous version I added 2 services into one binding which caused too much confusion regarding day-ahead and forecast pricing.

Now binding relies only on https://www.energyforecast.de/. New things are needed.

Donā€™t know whatā€™s happening there, I was more focused to clean things up.

First please switch to this updated binding. It has a new name so please check if cleanup really took place - old completely removed, new one istalled.

Now at each refreshInterval the response is printed to check if updates are coming regular. Enabling TRACE level will also help in further analyzing.
At least for me itā€™s running stable since Thursday.

27

Nein, sorry, ich bekomme keine Werte.

Ich habe die Items und die Verlinkungen gelƶscht. Habe das Add-on entfernt und erneut installiert.

Ich habe die Werte in die neue Maske eingetragen. Auch einen neuen API Key erstellt.

grafik
grafik787Ɨ666 33.6 KB

grafik
grafik787Ɨ306 20.4 KB

grafik
grafik787Ɨ369 26.2 KB

grafik
grafik787Ɨ477 36.2 KB

28

Which persistence is attached to these items?

Rrd4j cannot handle future values. If you donā€™t have any other you can use inmemory

29

Hi Bernd,

thanks for the update, that is great! I remove the old version and Things and created new Things. Now I get what I need :+1:
There is one small issue, the ā€œEnergy Forecast Fix Costā€ now needs to be entered in EUR/kWh, not in ct/kWh as stated in the description.

And one more thing - the format of the Price Origin channel is currently a Number which stays NULL. I guess that shall be a String, no?

30

Thatā€™s true, itā€™s a bug.
Fixed now, should work without creating new things/items.

No, itā€™s a number but with a human readable mapping - see readme.

Regarding NULL - Iā€™m also struggeling with timeseries first time setup every time! Item stays NULL until the next value update. In this case next full hour or 15 minutes. I still donā€™t know why the items doesnā€™t get filled immediately.

A few issue with time series
31

Hi Bernd,

yeah, I saw the readme meanwhile. Is there any particular reason why you go with a Number and not a String to show the origin directly? In the JSON I can see the origin as a String when pulling from the API Webpage.

Regarding NULL - Iā€™m also struggeling with timeseries first time setup every time! Item stays NULL until the next value update. In this case next full hour or 15 minutes. I still donā€™t know why the items doesnā€™t get filled immediately.

I opened a separate topic for the time series issues - here: A few issue with time series. No response yet and not sure whom from the Maintainers to ping..

32

Several small reasons

  • not easy to compare - ignore case sensitive, typos, ā€¦
  • standard rrd4j database cannot store Strings
  • with the state options mappings described in readme a translation is possible
  • you can see it in a chart where day-ahead ends and forecast begins

image
image1367Ɨ1022 132 KB

Hm curious, I never observed that. And Iā€™ve several test things for tibber, entsoe, solar forecast, ā€¦ running, disbaled for weeks and after enabling it works fine. Only this described setup issue is bugging me

33

How can I attach a persistence service to an item? I can only set a default persistence service. When I change the service, all my values are gone. I have RRD4j as default. I can also use In Memory, MapDB and JDBC.

Can I set a specific persistence service for an item? If so, how?

34

See Persistence | openHAB

Create /etc/openhab/persistence/inmemory.persist to persist all items of group memPersist
(I bet it can be done in UI, too)

// persistence strategies have a name and a definition and are referred to in the "Items" section
Strategies {
}

/*
 * Each line in this section defines for which item(s) which strategy(ies) should be applied.
 * You can list single items, use "*" for all items or "groupitem*" for all members of a group
 * item (excl. the group item itself).
 */

Items {
        memPersist* : strategy = everyChange, forecast
}
35

Thank you. Iā€™m fairly new to openHAB, and everything being in English is also exhausting. Sorry if Iā€™m asking strange questions. And even if inMemory is not the default persistence service, are the values still displayed?

I put the items from the binding into a group under Models and set the group in inMemory as described.

36

If you want to chart an item that is part of multiple persistence services and you donā€™t want the default one, you have to specify it as service: inmemory on the chart page.

37

Iā€™m sorry to hear that renewable shares was removed. It was the thing I was most interested inā€¦ :disappointed_face:

38

Hello everyone,

For those who simply want to write the 48-hour forecast in an item, here is a simple automation rule that does this for you without binding:

const { rules, triggers, actions, items, time } = require("openhab");

const PersistenceExtensions = Java.type("org.openhab.core.persistence.extensions.PersistenceExtensions");
const QuantityType = Java.type("org.openhab.core.library.types.QuantityType");
const ZonedDateTime = Java.type("java.time.ZonedDateTime");

const ITEM_NAME = "Strompreis_Forecast"; 
const API_URL = "https://www.energyforecast.de/api/v1/predictions/next_48_hours?token=MY_API_TOKEN";

rules.JSRule({
  name: "StĆ¼ndlicher Strompreis-Forecast",
  description: "Holt die Preise und pusht sie in die InMemory-Datenbank",
  triggers: [
    triggers.GenericCronTrigger("0 0 * * * ?") 
  ],
  execute: (event) => {
    console.info("Starte Strompreis-Abruf von EnergyForecast...");
    
    let response = actions.HTTP.sendHttpGetRequest(API_URL);

    if (response) {
      try {
        let jsonArray = JSON.parse(response);
        let currentPriceState = null;
        let now = time.ZonedDateTime.now();
        
        let rawItem = items.getItem(ITEM_NAME).rawItem;

        jsonArray.forEach(entry => {
          let preis = parseFloat(entry.price);
          let finalState = preis.toFixed(4) + " EUR/kWh";
          
          let javaZDT = ZonedDateTime.parse(entry.start);
          
          PersistenceExtensions.persist(rawItem, javaZDT, QuantityType.valueOf(finalState), "inmemory");

          let startZDT = time.toZDT(entry.start);
          let endZDT = time.toZDT(entry.end);
          if ((now.isAfter(startZDT) || now.isEqual(startZDT)) && now.isBefore(endZDT)) {
              currentPriceState = finalState;
          }
        });

        if (currentPriceState !== null) {
            items.getItem(ITEM_NAME).postUpdate(currentPriceState);
        }
        
        console.info("Forecast in InMemory geschrieben! Anzahl DatensƤtze: " + jsonArray.length);
        
      } catch (e) {
        console.error("Fehler beim Verarbeiten der Strompreis-Daten: " + e);
      }
    } else {
      console.error("Fehler: Konnte keine Daten abrufen.");
    }
  }
});

That works great for me, but thank you anyway for the binding. Without it, I would never have come up with the idea or realized the possibility!

39

Iā€™m sorry, but Iā€™m not getting any values via the binding. Even when I change the database. Iā€™ll deactivate it for now and try again later.

40

Sure this works but this is nearly the same the binding is doing plus some error handling and so on.
Do you also have problems with setup?

Ok, letā€™s see if we can figure out the problem:
Please provide me 2 screenshots similar to mine attached as example:

  • How does your item look like?
    In UI click Settings - Items, search your item and click on it.
    Result shall be similar to Pic 1)
  • How is your persistence configured?
    In UI click Settings - Persistence - Configure Persistence Policies - In Memory
    Result shall be similiar to Pic 2)

Pic 1

image
image1187Ɨ1099 47.6 KB

Pic 2

image
image1153Ɨ582 29.8 KB

41

Please donā€™t worry, itā€™s my fault to mix up Energy Forecast future AI energy prices with Energy Chatrs Info day-ahead prices and more.

As discussed before Iā€™ll prepare 2 bindigs

  1. this one with AI price forecast and some metrics
  2. another one, not published yet, with free access to day-ahead prices plus renewable shares, ā€¦
1 Like