[Bug]: Spanish market price is not correct

[TomasVelPar]

Contact Details

tomas.velasco.parra@gmail.com

VRM / Site iD

79108

Country / region

Spain (es)

B max

24

TB max

2.7

FB max

5

TG max

0

FG max

3.5

Battery costs

0.04166667

Buy price

p

Sell price

p

feed-in possible

yes

feed-in possible

yes

What happened?

at least buy prices at Spain are not obtained correctly. For example the real prices (sell and buy) are the following ones (for the peninsula):

they are obtained from:

https://www.esios.ree.es/es/analisis/1739?compare_indicators=1001&vis=1&start_date=12-09-2023T00%3A00&end_date=12-09-2023T23%3A55&compare_start_date=11-09-2023T00%3A00&groupby=hour

and the dynamic ESS shows this other ones (the same for buy and sell):

To obtain the real prices of buying (5 diferent types in Spain (Peninsula, Baleares, Canarias, Ceuta and Melilla)) and selling it could be used the api of the oficial api web: https://api.esios.ree.es/

For example i use the following web for the 5 buy prices:

url = 'https://api.esios.ree.es/indicators/1001?start_date=' + day_1 + 'T00%3A00%3A00&end_date=' + day_2 + 'T23%3A59%3A59'

and for the sell prices this other one:

url = 'https://api.esios.ree.es/indicators/1739?start_date=' + day_1 + 'T00%3A00%3A00&end_date=' + day_2 + 'T23%3A59%3A59'

Thanks so much!

Relevant log output

No response

Screenshots

![DESCRIPTION](LINK.png)

[dirkjanfaber]

The buy and sell formula's are used to distinguish between buy and sell prices. You now have both set to just p.

On https://github.com/victronenergy/dynamic-ess#configuration-of-the-victron-dynamic-ess-node this is explained:

The other thing to configure is the buy price formula and sell price formula (if you are allowed to sell back to the grid). This formula looks typically something like: (p+0.02+0.13)*1.21. It this example it breaks down to:

• p - the dynamic price / kWh
• € 0.02 - energy provider profit share
• € 0.13 - DSO working price + contributions/levy/taxes
• 21% - tax

The sell price formula looks often identical and in common cases looks something like (p-0.02+0.13)*1.21. So the energy provider profit share works the other way around.

With different providers, the formula will likely be different. So this does require some research on how your pricing is build up.

[TomasVelPar]

Thanks for your replay, but this other variables (prices asociates and taxes) will be added after. But the value of "p" in Spain could not be the same for sell and buy. just because in origin the value is not the same. The market stablish different valuesfor buy and sell. After those values it must be aplied profits, taxes, etc. and also diferent percentages of taxes depending on the hour of the day.

In the following link you could see this: https://www.esios.ree.es/es/pvpc

As could see in the images in some hours the softred area varies. This is becasue dependening the hour they put more or less taxes. There are not a direct relationship betwen buy and sell prices in Spain market. Thats why i send you the link teo get the real prices

[dirkjanfaber]

Thanks for the clarification. To be honest, adding this api to the system will probably take a while. Getting all of the bugs out and everything stable for the areas that follow the ENSTSOE prices is on top of the priority list for now.

[TomasVelPar]

Thanks so much again. So, until you have time to deploy this, is there any way (for users) to send the hourly price of buying and selling to the nodered or to somewhere to let the dynamic ESS still working?

[dirkjanfaber]

Not yet, but allowing the users to provide their own hourly prices for the calculations is definitely a good idea.