Energy Spot Price

The ENTSO-e Energy Rate QuickApp give you the current and coming energy spot price rates by hour from ENTSO-e transparency platform in your local currency. ENTSO-e is independent from any power company and no subscription or specific hardware is required to get this to work.

(*Local currency now reqires a free account at https://exchangerate.host)

💡 If you pay your energy consumption by hour then this QA can save you money!

This QA has spot prices for the following countries: Austria, Belgium, Bosnia and Herz., Bulgaria, Croatia, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Lithuania, Luxembourg, Netherlands, North Macedonia, Norway, Poland, Portugal, Romania, Serbia, Slovakia, Slovenia, Spain, Sweden, Switzerland, Ukraine and United Kingdom.

How to install

After you have download, you need to unzip the file to get the .fqa file that can be install in FIBARO, I also provide the icon in .png format.

1. Click "+ Add device"
2. Choose Other Device
3. Choose Upload File
4. Select unzipped .fqa file

How it works

After you have add this QA in FIBARO devices, you need to set your local energy area that you belong to in the general variables [EnergyArea] to start collecting energy prices.

The variation of energy hour level in [EnergyHourLevel] is calculated from price values you set in the QA local variables [PriceLow], [PriceMedium], [PriceHigh], [PriceVeryHigh]. You set those prices from what you feel is the correct level prices for you in your local currency* by consumed kWh.

(*If you use other than € Euro as your local currency, you need to get your own free "API access key". See "Exchange rate in local currency" below for more information.)

Global variables to use in scenes:

[EnergyCurrentRate] show current energy rate price in selected currency.
[EnergyHourLevel] show what price level it is current hour.
[EnergyNextHourLevel] show what price level it will be the next hour.
[EnergyMonthLevel] show what the avrage price is in current month.

To calculate different energy prices including tax, costs, grid, fee, etc, you change these values in the local QA variables.

(EnergyRate * ExchangeRate + OperatorCost * Losses * Adjustment + DealerCost + GridCost * Tax)

Trigger scenes

You can then easy trigger scenes or devices based on the value in the general variables [EnergyHourLevel], [EnergyNextHourLevel] or [EnergyMonthLevel] that can have the following values:

• 🔴 VeryHIGH
• 🟠 HIGH
• 🟡 MEDIUM
• 🔵 LOW
• 🟢 VeryLOW
• 🟣 Negative (Only available if [NegativeRates] = ON)

Usage in Lua scen:

    local value = hub.getGlobalVariable("EnergyHourLevel")
    if (value == "VeryHIGH") then
        ...
    end

Or in Block scen:

FIBARO Tariff rates

You can turn ON/Off storage of ENTSO-e Energy Rates in the FIBARO Energy Tariff table with the general variable [EnergyTariffInFibaro], and you set how many days to store history in FIBARO tariff table in the QA variable [TariffHistory]. In FIBARO Tariff settings you also set your local currency to use in this QA.

Lua code samples

    -- How to get FIBARO Energy Tariff data
    local tariffData = api.get("/energy/billing/tariff")
    local currentRate = tariffData.rate
    local tariffTable = tariffData.additionalTariffs
    ...

    -- How to get General variable QA Tariff state table decoded in a Lua table
    local jsonString = fibaro.getGlobalVariable("EnergyTariffTable")
    local tariffTable = json.decode(jsonString)
    ...
 
    -- How to get current energy rate price
    local currentRate = fibaro.getGlobalVariable("EnergyCurrentRate")
    ...

ENTSO-e Token

You can get your own ENTSO-e token if needed and replace the existing token in the local QA variable [ENTSOE_Token], but this is not reqired to get the QA to work.

💡 How to request for your own token at ENTSO-e site: ENTSO-e Restful API access

Exchange rate in local currency

If you use other currency than the default Euro € in FIBARO Tariff settings, then you need to register a free account at https://exchangerate.host/signup/free to get a "API Access Key", that is required in the local QA variable [ExchAccessKey] to get your local currency rates.

Feedback

I would love if you gave me some feedback on whether or not you like this QA, maybe I missed some function you need, let me know... Or just give your Rating on the QuickApp:

https://marketplace.fibaro.com/items/entso-e-energy-rate