NordPool day-ahead electricity prices (Estonia)

[martinarva]

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Hi!

I just bought BMW i3 and 10kw solar panels with Huawei inverter will be mounted to my home roof within a month or so. Solar guys offered me Menergi Zappy EV charger with Hub and Harvi electricity meter for a smart EV chanrging taking account of my own PE electricity producing. My issue was, that Myenergi is not compatible with Home Assistant where all my smart home stuff is. I even have to put double EV meter (Shelly EM) to get the electricity usage to home assistant, but the EV charger logic will be outside of the Home Assistant.

So I started searching around internet and found EVCC, which ticks almost all my requirements. Really great job you have done here. I havent deciced yet wich EV Charger to get, and will use Shelly plug so i can play around.

As i live quite a bit north of you, in Estonia, we don't too much sun available in some of the winter months, so probably some parts of the year PE would not be enough and it would be smart to look at the electricity prices to decide when to charge the EV.

Luckily in Estonia we are a part of NordPool open market and we get one day ahead electricity prices which are available through Elering API.

Api documendation and direct link to NordPool day-ahead prices: https://dashboard.elering.ee/assets/api-doc.html#/nps-controller/getPriceUsingGET

Would it be possible and how to integrate such information from Elering API?

If yes, then would it be possible to make some more advance logic behind Flexible Energy Tariffs instead of just defining "cheap" price of with under charging happens and over not. For example, if we know ahead that tomorrow won't be a so called cheap price at all it will still charge with the lowest available or something like this.

Here is a last 30 days for example:
https://dashboard.elering.ee/et/nps/price?interval=minute&period=months&start=2021-08-31T21:00:00.000Z&end=2021-09-30T20:59:59.999Z

Would be smart to set "cheap" price under 100€/MWh, because looks like in the night it has been below that, but for example today is the highest price in the history and I would have a empty ac battery in the morning. Maybe you have some other great ideas how to solve this.

Again big thanks for the work you have done and i hope my idea is something that you have interest. The nordpool integration would cover Nordics not only Estonia. Even Norway which is a big EV market.

[andig]

Thank you for your interest in evcc!

Luckily in Estonia we are a part of NordPool open market and we get one day ahead electricity prices which are available through Elering API.

Api documendation and direct link to NordPool day-ahead prices: https://dashboard.elering.ee/assets/api-doc.html#/nps-controller/getPriceUsingGET

Would it be possible and how to integrate such information from Elering API?

Yes, that looks straightforward. Right now, we'd only need to look at the current rate, not even the day-ahead prices.

If yes, then would it be possible to make some more advance logic behind Flexible Energy Tariffs instead of just defining "cheap" price of with under charging happens and over not. For example, if we know ahead that tomorrow won't be a so called cheap price at all it will still charge with the lowest available or something like this.

Seems what you're asking for is a planning/scheduling capability that we currently don't have.

Would be smart to set "cheap" price under 100€/MWh, because looks like in the night it has been below that, but for example today is the highest price in the history and I would have a empty ac battery in the morning. Maybe you have some other great ideas how to solve this.

If you want to implement the planning externally, you could just control evcc through it's rest api. Unfortunately we won't support planning in the near future.

If it helps I could add NordPool right away, but would need an API token for testing ([email protected]).

[martinarva]

Thanks for a promt answer!

NordPool Estonia adding would be great start. I think you can get the information even without a token.

For example curl for today's prices:
curl -X GET "https://dashboard.elering.ee/api/nps/price?start=2021-09-13T00%3A00%3A00Z&end=2021-09-13T23%3A59%3A59.999Z" -H "accept: */*"

Request URL: https://dashboard.elering.ee/api/nps/price?start=2021-09-13T00%3A00%3A00Z&end=2021-09-13T23%3A59%3A59.999Z

Parameters are:
start
string($date-time)
(query)

end
string($date-time)
(query)

Time is estonian (GMT+2)

On planning, you are right, I can probably do it in Home Assistant over API. Have to check into it if I get it up and running and hourly electricity prices as well.

[RTTTC]

Looks like this was long forgotten easy way to add Nordpool data (with no token) At least for Estonia :)
AND looks like data is available for EE, LV, LT and FI
https://dashboard.elering.ee/assets/api-doc.html#/nps-controller

[Peethiplatsch]

Hey, I just checked your documentation and the Nord Pool integration is only available for Estland. Since I am living in Denmark, I would like to ask if DK1 & DK2 could be integrated as well. :)
If that helps you, I wouldn't need any translation since I am German :P

[andig]

@Peethiplatsch the provider is Elering. Do they have DK regions? If not we need a new data provider.

[Peethiplatsch]

@andig from what I know, Nord Pool is our electricity stock in Denmark as well. Also, the post from @iotux from May 23 shows that DK1 & DK2 is part of their API.
Looking at the URL (https://www.nordpoolgroup.com/api/marketdata/page/10/EUR/24-05-2023) he later posted, you can also find entries for DK1 and DK2 :)
And we only have two areas here in Denmark. Its west of Storbelt (DK1) and east of Storbelt (DK2).

And thanks a lot for your quick reply, much appreciated.

[andig]

Adding new tariffs is not that difficult- maybe you want to try yourself? Otherwise Entso-E should already fulfill the purpose, so no need to add Nordpool?

[Peethiplatsch]

@andig Haha damnit, I just wanted to answer you and saw that Energinet is implemented. So I have my Nord Pool data ^^ Sorry for the question and many thanks again for your response. I was totally blind and just searched for Nord Pool -.-

[RTTTC]

@andig would it be possible to add overhead cost calculation to this tariff ?
For example my energy price is simply Nordpool + 0.09468 Eur per kWh (this overhead is announced every 6 months)
Some countries/providers may have VAT separately, some may have fixed overhead plus VAT or some such combination.

Something similar as here perhaps? https://github.com/custom-components/nordpool#additional-costs

[iotux]

Allow me to introduce myself. I am a 78 year retiree from Norway and a lucky owner of a fully electrified vehicle. Just a few days ago I became aware of the evcc project when searching for a system to take control of my charging. I have also come to understand that "evcc" is heavily focused on solar power.

In Norway around 80 percent of newly sold cars are electric, which is quite a huge share. Solar power systems are not quite common, but with the crazily fluctuating power prizes, a system for charging automation would certainly be welcome. Even without an EV, a lot of people could take advantage of power meter control to distribute power to other power hungry devices like heat pumps, washing machines and so on.

With these factors in mind, I purchased a Tibber Pulse to take control of the power consumption. As avid follower and user of open source software, I decided to take control of the Tibber Pulse and bypass the Tibber cloud connection and feed an MQTT broker directly. With this in mind, I wrote a program to take advantage of date from Pulse to keep in control of my power consumption. At that time, the program was only intended for my own personal use. I like word play, so I named the program "ElWiz", short for "Electricity Wizard" and made it public available on Github. The program sparked some interest, and it has already been forked a dozen times. After seeing this intererst, I decided to do some efforts to make it more fitted for public use.

The program consists of two parts. One is the core program, which task is to aquire data from power meters and distribute it in a human readable form to smart home systems like Homeassistant and others. MQTT is used for publishing data to a subscriber like Homeassistant. It is designed with different source and destination systems in mind, and therefore it has a plugin system in both ends. For Homeassistant, ElWiz takes advantage of HA's auto discovery system. In that regard, the program is fully integrated in HA by means of the HA plugin. A simple plugin could even send power prices direct to evcc either direct by MQTT messages or with a simple API.

The other part is two price fetching programs, one for fetching prices from Nord Pool, and one for fetching prices from Entso-E.
Both price fetching programs have currency translation abilities. From Nord Pool the prices for most European countries are available in the actual native country currency. The DayAhead prices are available around 13:00 CET/CEST. Entso-E get the prices directly from Nord Pool and cover the same areas and are available around one hour later. The price currency is only EUR, but it be translated to other currencies. The programs can also calculate different tax models.

ElWiz is awailable from Github here: https://github.com/iotux/ElWiz.git Comprehensive documentation is available.

The programs are written in the Node.JS language, but a couple of days ago, I started to rewrite the price fetching programs to golang, having evcc integration in mind. I have no experience with the go language, but with some help from OpenAI ChatGPT, I have got the programs in an executable condition. I also used some time to get the UI Norwegian translation up to 100%. Now I an interested in getting in touch with the evcc developers to discuss integration.

[iotux]

A screenshot from a part of the HA integration.