EntsoE Binding [4.0.0.0;4.3.0.0)

Add-on Marketplace Bundles
, ,
141

Assuming that the margin of your energy company would be 0.38 c/kWh, you could use the following inline transformation to first convert euros to cents by multiplying the input by 100, then multiply it by 1.255 to add 25.5% VAT and then add 0.38 cent margin to it.

| parseFloat(input)*100*1.255+0.38

Markus

142

For some reason the inline transformation doesn’t work for me. When I had this transformation, there was no data in InfluxDB. After removing the transformation, InfluxDB was more or less immediately populated.

143

Ok, I need to test this with 4.3.0, I’ve only used the milestone builds so far
 Hopefully I have time tomorrow to check this


144

OK, thanks. One stupid question. Do I need to use “|” in front of the transformation? I was using the transformation in OH4.2.1 but it didn’t work (InfluxDB was not populated). I then updated to OH4.3.0 and again the transformation didn’t work. Finally I removed the transformation and InfluxDB was populated immediately.

145

Yes you do. Look at the screenshot I posted above at EntsoE Binding [4.0.0.0;4.3.0.0) - #120 by masipila

146

OK, thanks. I just wanted to check this. I have now this transformation and let’s see if it works (InfluxDB populated).

1 Like
147

It seems that populating my InfluxDB is now working under OH4.3.0. I think my problem was that I tried to use the latest jar-file under OH4.2.0. The transformation is also working. Now I have to figure out how to rename the old spot prices in InfluxDB.

148

Now that the binding is part of the official distribution in OH 4.3, should the marketplace version be unpublished or made available only untill OH version 4.2.x?

149

That should already be the case?

150

You mean the second version in title is excluded?
So “EntsoE Binding [4.0.0.0;4.3.0.0)” will not be available for OH version 4.3?

151

Exactly, and it seems to work as expected - from my 4.3 installation:
image

Correct.

152

Hi all

I’m trying to get electricity prices converted to SEK,

I have:

  • A working Entsoe binding configuration but I get prices in EUR/Kwh,
  • A working freecurrecybnding configuration.
  • I’ve set base currency for openhab settings to SEK and freecurrency binding as exchangerate provider.

How do I do to make Entsoe binding to use this item conversion preferably before storing to influxdb

Number ExchangerateEuro "VĂ€xelkurs euro" {channel="freecurrency:info:EUR:exchangeRate"}

Regards Marcus

153

You simply need to let UoM do the work for you by defining your item as Number:EnergyPrice and setting the unit to SEK/kWh. See Using the new Currency Units of Measurement in 4.1

Example:

Number:EnergyPrice SpotPrice { channel="entsoe:day-ahead:02b0905d44:spot-price", unit="SEK/kWh" }

or with VAT included:

Number:EnergyPrice SpotPrice { channel="entsoe:day-ahead:02b0905d44:spot-price", unit="SEK/kWh" [profile="transform:VAT"] }
154

Hi Thanks for your reply, it really helped me out, when I tried similar solutions I did in deed miss capital W in kWh. Now that part seems to work, however my VAT didn’t still saves value as if there vas no VAT profile even tough I installed Transformations service VAT. And except for that I might need to add electic companys margin of the price so I get a total price Spotprice + margin + VAT. Can anyone se why my VAT profile shouldn’t work?

Number:EnergyPrice energySpotPrice "Current Spot Price" <price> (AllForecastedItem) { channel="entsoe:day-ahead:c52272b366:spot-price", unit="SEK/kWh" [profile="transform:VAT", percentage="25.0"]}
155

I have had now 2 days in a row that the 1PM publishing window was delayed to ~4pm. Looking at the EntsoE website for Belgium, France and Netherlands at least.
Now this means the update will only happen the next day at 1PM
 Is there a way to manually trigger the binding to update? This way I could make a rule that keeps track of the last update and automatically retrys again after an hour.

156

Starting tomorrow, Entsoe will publish 15min tariffs. Selecting 60min, because I would like to keep the hourly tariffs, in the binding doesn’t work
..

157

My setup wont work with “,unit” in it, however like this seems to work:

Number:EnergyPrice energySpotPrice “Current Spot Price [%.4f SEK/kWh]” (AllForecastedItem) { channel=“entsoe:day-ahead:c52272b366:spot-price” [profile=“transform:VAT”, percentage=“25.0”]}

I have my percentage for vat set at “43.8” so that it gets close to what the Fortum app shows.

158

Hi,

is there any way to still get hourly prices somehow?

Thanks!

159

I don’t think entsoe publishes hourly values, so i’ve created a rule that averages the 15min values into hourly values.

1 Like
160

Hi emiel, could you please share your rule. Many thanks in advance.