JaccoR / hass-entso-e

Integration for Home Assistant to fetch day ahead energy prices from European countries via ENTSO-e Transparency Platform
159 stars 25 forks source link

Help needed: VAT of all countries #38

Open JaccoR opened 1 year ago

JaccoR commented 1 year ago

I am currently working on getting VAT and conversion rates in the integration. I made a dictionary with all countries and its data:

AREA_INFO = {"AT":{"code":"AT", "name":"Austria", "VAT":0.22, "Currency":"EUR"},
             "BE":{"code":"BE", "name":"Belgium", "VAT":0.06, "Currency":"EUR"},
             "BG":{"code":"BG", "name":"Bulgaria", "VAT":0.21, "Currency":"EUR"},
             "HR":{"code":"HR", "name":"Croatia", "VAT":0.21, "Currency":"EUR"},
             "CZ":{"code":"CZ", "name":"Czech Republic", "VAT":0.21, "Currency":"EUR"},
             "DK_1":{"code":"DK_1", "name":"Denmark Eastern (DK1)", "VAT":0.21, "Currency":"EUR"},
             "DK_2":{"code":"DK_2", "name":"Denmark Western (DK2)", "VAT":0.21, "Currency":"EUR"},
             "EE":{"code":"EE", "name":"Estonia", "VAT":0.21, "Currency":"EUR"},
             "FI":{"code":"FI", "name":"Finland", "VAT":0.24, "Currency":"EUR"},
             "FR":{"code":"FR", "name":"France", "VAT":0.21, "Currency":"EUR"},
             "LU":{"code":"DE_LU", "name":"Luxembourg", "VAT":0.21, "Currency":"EUR"},
             "DE":{"code":"DE_LU", "name":"Germany", "VAT":0.21, "Currency":"EUR"},
             "GR":{"code":"GR", "name":"Greece", "VAT":0.21, "Currency":"EUR"},
             "HU":{"code":"HU", "name":"Hungary", "VAT":0.21, "Currency":"EUR"},
             "IT_CNOR":{"code":"IT_CNOR", "name":"Italy Centre North", "VAT":0.21, "Currency":"EUR"},
             "IT_CSUD":{"code":"IT_CSUD", "name":"Italy Centre South", "VAT":0.21, "Currency":"EUR"},
             "IT_NORD":{"code":"IT_NORD", "name":"Italy North", "VAT":0.21, "Currency":"EUR"},
             "IT_SUD":{"code":"IT_SUD", "name":"Italy South", "VAT":0.21, "Currency":"EUR"},
             "IT_SICI":{"code":"IT_SICI", "name":"Italy Sicilia", "VAT":0.21, "Currency":"EUR"},
             "IT_SARD":{"code":"IT_SARD", "name":"Italy Sardinia", "VAT":0.21, "Currency":"EUR"},
             "LV":{"code":"LV", "name":"Latvia", "VAT":0.21, "Currency":"EUR"},
             "LT":{"code":"LT", "name":"Lithuania", "VAT":0.21, "Currency":"EUR"},
             "NL":{"code":"NL", "name":"Netherlands", "VAT":0.21, "Currency":"EUR"},
             "NO_1":{"code":"NO_1", "name":"Norway Oslo (NO1)", "VAT":0.25, "Currency":"EUR"},
             "NO_2":{"code":"NO_2", "name":"Norway Kr.Sand (NO2)", "VAT":0.25, "Currency":"EUR"},
             "NO_3":{"code":"NO_3", "name":"Norway Tr.heim (NO3)", "VAT":0.25, "Currency":"EUR"},
             "NO_4":{"code":"NO_4", "name":"Norway Tromsø (NO4)", "VAT":0, "Currency":"EUR"},
             "NO_5":{"code":"NO_5", "name":"Norway Bergen (NO5)", "VAT":0.25, "Currency":"EUR"},
             "PL":{"code":"PL", "name":"Poland", "VAT":0.21, "Currency":"EUR"},
             "PT":{"code":"PT", "name":"Portugal", "VAT":0.21, "Currency":"EUR"},
             "RO":{"code":"RO", "name":"Romania", "VAT":0.21, "Currency":"EUR"},
             "RS":{"code":"RS", "name":"Serbia", "VAT":0.21, "Currency":"EUR"},
             "SK":{"code":"SK", "name":"Slovakia", "VAT":0.21, "Currency":"EUR"},
             "SI":{"code":"SI", "name":"Slovenia", "VAT":0.21, "Currency":"EUR"},
             "ES":{"code":"ES", "name":"Spain", "VAT":0.21, "Currency":"EUR"},
             "SE_1":{"code":"SE_1", "name":"Sweden Luleå (SE1)", "VAT":0.25, "Currency":"EUR"},
             "SE_2":{"code":"SE_2", "name":"Sweden Sundsvall (SE2)", "VAT":0.25, "Currency":"EUR"},
             "SE_3":{"code":"SE_3", "name":"Sweden Stockholm (SE3)", "VAT":0.25, "Currency":"EUR"},
             "SE_4":{"code":"SE_4", "name":"Sweden Malmö (SE4)", "VAT":0.25, "Currency":"EUR"},
             "CH":{"code":"CH", "name":"Switzerland", "VAT":0.21, "Currency":"EUR"},
            #  "UK":{"code":"UK", "name":"United Kingdom", "VAT":0.21, "Currency":"EUR"},
            #  "AL":{"code":"AL", "name":"Albania", "VAT":0.21, "Currency":"EUR"},
            #  "BA":{"code":"BA", "name":"Bosnia and Herz.", "VAT":0.21, "Currency":"EUR"},
            #  "CY":{"code":"CY", "name":"Cyprus", "VAT":0.21, "Currency":"EUR"},
            #  "GE":{"code":"GE", "name":"Georgia", "VAT":0.21, "Currency":"EUR"},
            #  "IE":{"code":"IE", "name":"Ireland", "VAT":0.21, "Currency":"EUR"},
            #  "XK":{"code":"XK", "name":"Kosovo", "VAT":0.21, "Currency":"EUR"},
            #  "MT":{"code":"MT", "name":"Malta", "VAT":0.21, "Currency":"EUR"},
            #  "MD":{"code":"MD", "name":"Moldova", "VAT":0.21, "Currency":"EUR"},
            #  "ME":{"code":"ME", "name":"Montenegro", "VAT":0.21, "Currency":"EUR"},
            #  "MK":{"code":"MK", "name":"North Macedonia", "VAT":0.21, "Currency":"EUR"},
            #  "TR":{"code":"TR", "name":"Turkey", "VAT":0.21, "Currency":"EUR"},
            #  "UA":{"code":"UA", "name":"Ukraine", "VAT":0.21, "Currency":"EUR"},
            }

For now, all VAT values an Currency values are set to dummy values. Would greatly appreciate some help with it, as it is not easy to find the correct VAT values in some countries!

MrOzzOnline commented 1 year ago

Belgium: 6% until 31/12/2022, after that it's 21%

blowk commented 1 year ago

Belgium: 6% until 31/12/2022, after that it's 21%

Isn't it until 31/03/2023?

MrOzzOnline commented 1 year ago

Belgium: 6% until 31/12/2022, after that it's 21%

Isn't it until 31/03/2023?

Yeah, the official info on belgium.be is still 31/12, but 31/03/23 has been announced

ThorAlex87 commented 1 year ago

Norway: NO1, NO2, NO3, NO5: 25% NO4: 0%

jpulakka commented 1 year ago

Finland: 24 % until 30.11.2022, then 10 % until 30.4.2023, then (presumably) back to 24 %.

I would just set it to 24 % here, it has been that way since 2013, the temporary drop to 10 % is quite exceptional.

rest77 commented 1 year ago

Sweden 25% in all 4 areas. Any suggestion how to convert the price to SEK? I cant find a good source for the exchange rate.

JaccoR commented 1 year ago

Sweden 25% in all 4 areas. Any suggestion how to convert the price to SEK? I cant find a good source for the exchange rate.

You can use an integration like open exchange rates in the template to convert to SEK. I am planning on adding this in the future.

dingusdk commented 1 year ago

Danish vat is 25% in all areas