Energy Spot Price v3.4

ENTSO-e Energy Rate QuickApp

Take control of your energy costs with the ENTSO-e Energy Rate QuickApp. It gives you current and upcoming hourly or 15-minute spot prices, sourced directly from the trusted ENTSO-e transparency platform and shown in your local currency. Since ENTSO-e is independent of power companies, the data is transparent and unbiased. No subscriptions, license fees, or special hardware are needed and is free to use.

Supported 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 or update

After downloading the file, unzip the file to get the .fqax file that can be install in FIBARO.
The package also includes the QuickApp icon in .png format.

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

💡To update, do not delete previous installed version if you want to keep your current settings and icon.
Simply upload the new .fqax file to FIBARO, and the setup process will handle the update automatically for you.

How to setup first time

After installing the QuickApp, simply set your local energy area in the general variable [EnergyArea]. The QuickApp will then start collecting your local electricity spot prices automatically.

Set your Energy Area in FIBARO under [Settings] > [General] > [Variables].

Other general variables you can set to change the control of the QuickApp:
[EnergyControlBy] - Hour or 15 Minutes that controls the general value outputs, default is Hour.
[EnergyNumberOfLowHighRates] - Number of selected lowest and highest prices used for daily triggers.
[EnergyUnit] - Show energy prices in kWh or MWh, default is kWh.
[EnergyTaxPct]  - You set the grid Tax/VAT in percent (%) in local variable.

Local grid costs

To calculate real grid costs that your local power company charge you, you simply add your local grid costs in a json formated string that can support different price lists over time and paste it in the local variable  [LocalGridPrices]. Default price list will be created for you when you install first time.

Example of different grid costs over time to create your own local price list:

[From] - Time (HH:mm) or date (DD/MM).
[To] - Time (HH:mm) or date (DD/MM).
[Days] - Weekdays like "Mon, Tue, Wed, Thu, Fri, Sat, Sun".
[AdjustmentPercent]  - Grid Adjustment percent cost added to the Grid Losses (%).
[DealerFee]  - Dealer fee cost.
[GridLossesPercent]  - Grid Losses percent cost (%).
[LocalGridCost]  - Local Grid cost.
[OperatorCost]  - Grid Operator deviation cost.

Rate price = (((((ENTSO-e rate × exchange rate) / unit scale) + operator cost) × grid losses% × adjustment%) + dealer fee + local grid cost) × tax%

Trigger scenes

You easy trigger scenes and devices based on the output value in the following general variables:
[EnergyRate]  - Current energy rate price in the selected currency.
[EnergyPriceIndexOfTheDay] - Current relative price index for the day.
[EnergyLowestRateOfTheDay] - TRUE/FALSE value that indicates lowest-price periods of the day.
[EnergyHighestRateOfTheDay] - TRUE/FALSE value that indicates highest-price periods of the day.
[EnergyAverageDayRate] - Average energy rate for the current day in the selected currency.[EnergyAverageNextDayRate] - Average energy rate for the next day in the selected currency.
[EnergyNextRate] - Next energy rate price in the selected currency.
[EnergyNextMinRate] - Time for the next lowest energy rate in the active control period.
[EnergyNextMaxRate] - Time for the next highest energy rate in the active control period.
[EnergyLevel]  - Current energy rate price level.
[EnergyNextLevel] - Next energy rate price level.
[EnergyMonthLevel] - Price level based on the average energy rate for the current month.

Level variables can have following values:

• 🟣 ExtremHIGH
• 🔴 VeryHIGH
• 🟠 HIGH
• 🟡 MEDIUM
• 🔵 LOW
• 🟢 VeryLOW
• ⚫ Negative

The price level is based on the threshold values defined in the QuickApp local variables [PriceLow], [PriceMedium], [PriceHigh], [PriceVeryHigh], and [PriceExtremHigh]. This allows you to adapt the price categories to your own electricity costs and local currency per kWh. The QuickApp creates default values automatically during installation.

Example to usage in Lua scen

Or in Block scen:
   

Exchange rate

If you not use Euro as your local currency, you set the currency in the FIBARO Energy panel.

By default the exchange currency is retrieved from FrankfurterApi, but if you want to use a more up-to-date exchange rate, you can register a free account and create a ApiKey at FreeCurrencyApi.
Then add your ApiKey in the QuickApp local variable [ExchangeApiKey].

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 QuickApp local variable [TariffHistory].

ENTSO-e Token

You can add your own ENTSO-e token in the QuickApp local variable [EntsoeToken], but this is not reqired.

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

What's new

v3.4 - 2026-06

• Added High/Low toggle and colored indicators for the current lowest/highest price levels.
• Fixed High/Low flags for global variables when using the [EnergyControlBy] setting.

v3.3 - 2026-05

• Replace separate grid cost variables with local JSON variable [LocalGridPrices] to support time-, weekday- and date-based grid cost rules.
• Fix ENTSO-e certificate error.

v3.2 - 2026-05

• Add and improved expandable 15-minute price rows and improved hourly summaries for countries with 15-minute ENTSO-e prices.
• Improve ENTSO-e interval parsing, UTC time handling and sub-hour aggregation for PT15M, PT30M and PT60M areas.
• Improve refresh flow, tariff history handling, cache fallback and lookup performance for better stability.
• Refine the UI layout with clearer settings sections, better extrema tables and improved daily price index text.
• Improve upgrade handling by preserving selected settings, removing duplicate/legacy QA devices.

Support

💡If you have any questions or suggestions, please send mail to [email protected]
    I you need support, just click on the mail symbol ✉️ at the bottom in the QuickApp.

Small donations are appreciated and help support further development of the QuickApp ❤️. If you want the unencrypted .fqa version, donate 40€ and I'll send it to you.