Add AD 🇦🇩 exchanges

[Manu1400]

Add link (without realtime value) :

• ES<->AD exchange : 110 kV
• FR<->AD exchange : 225 kV

source :

• "L'électricité consommée en Andorre (de moyenne pour les années 2010 et 2011, 599.000 MW.h) est principalement importée
  de France et d’Espagne." in https://unfccc.int/sites/default/files/resource/AND_BUR1_Definitiu.pdf
• http://pyrenees-orientales.cci.fr/sites/default/files/Aur%C3%A9lie%20Greck/B2B20180925Deroul_1%20CMiquel_FR.pdf (page 5), or in english : https://unfccc.int/sites/default/files/resource/1_Andorra_FSV_Presentation.pdf

[alixunderplatz]

Hi @Manu1400
technical exchange capacities in Megawatts are required for the interconnectors on the map (not the voltages of the power lines).
Without real-time data, it is not necessary to include them in the code for the map, as they won't appear.
Could you find any real-time exchange data for Andorra with France and Spain?
If not, I'd close the issue.

[gwpicard]

@Manu1400 any updates on real-time exchange data between FR/ES <--> AD? If not as @alixunderplatz we would close this issue because it won't change much in terms of our data just listing the existence of the exchange without data

[silimotion]

I've found that the exchange between Spain and Andorra is published in the REE website:

Would this be useful? It seems ESIOS is also used in the Spain-Morocco connection.

[VIKTORVAV99]

I've found that the exchange between Spain and Andorra is published in the REE website:

Would this be useful? It seems ESIOS is also used in the Spain-Morocco connection.

Nice! Looks like we should be able to build a parser with this info and get the exchange added.

[VIKTORVAV99]

I found a slight problem, the dataset that should contain the aggregated final import export for the Spain -> Andorra exchange is empty...

Here is the Andorra exchange dataset:
https://www.esios.ree.es/en/analysis/10210?vis=1&start_date=24-07-2023T00%3A00&end_date=24-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

Here is the Morocco exchange dataset (that we currently use):
https://www.esios.ree.es/en/analysis/10209?vis=1&start_date=24-07-2023T00%3A00&end_date=24-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

Now there is a bunch of other Andorra exchange datasets that we could maybe use? (like the day ahead one?)

Day ahead dataset (I think):
https://www.esios.ree.es/en/analysis/10131?vis=1&start_date=24-07-2023T00%3A00&end_date=25-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

[silimotion]

I was also investigating the API and found the same problem. The best data that I found was this:
https://www.esios.ree.es/en/analysis/10278?vis=1&start_date=24-07-2023T00%3A00&end_date=25-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

It seems to also take into account intra-day market.

By the way, while looking at the data produced by the ESIOS parser for Spain-Morocco (available also in the map), I've seen that it is quite different from the one available at the REE ESIOS webpage. Could you check this out? If this is correct we'll have to fix that before/during these Andorra changes, assuming we reuse this parser.

[VIKTORVAV99]

Picking this up again.

As far as I can tell the final net exchange between ES and AD should be the sum of the day-ahead data + intraday data + any emergency import/exports which should be what we have added already.

I'll see if I can find any data for the French side but I have also reached out to ENTSO-E about the lack of data there.

[VIKTORVAV99]

So I got this back from ENTSO-E:

To follow up on your request, please find below the feedback that we received from the French data provider:

"Unfortunately, we do not possess public data showing our exchanges with Andorra."

I'm not sure there is much more we can do about this if there is no public data.

[tuxity]

There is some information here from FEDA: https://www.feda.ad/energia-i-meteo/energia/historic

I have sent them an email to get the data by hour, no response yet.

[VIKTORVAV99]

There is some information here from FEDA: https://www.feda.ad/energia-i-meteo/energia/historic

I have sent them an email to get the data by hour, no response yet.

Thanks! Please do let us know when they reach back to you!