smokkelaar / carchargewithhourcurrentrates Goto Github PK

import datetime as dt
from selenium import webdriver
from bs4 import BeautifulSoup



#######################################################
###Input: none
###Function: Get the day ahead prices form entsoe, and transform them to price per kWh including taxation. (*0.00121)
###Output: List of upcoming prices so far as possible. in the format: list[time, price buy, price sell]
#######################################################

def Ophalen():
    nu = dt.datetime.now(dt.timezone.utc)
    morgen = nu + dt.timedelta(days=1)
    urlvandaag = "https://transparency.entsoe.eu/transmission-domain/r2/dayAheadPrices/show?name=&defaultValue=false&viewType=TABLE&areaType=BZN&atch=false&dateTime.dateTime="+"{:02d}".format(nu.day)+"."+"{:02d}".format(nu.month)+"."+str(nu.year)+"+00:00|CET|DAY&biddingZone.values=CTY|10YNL----------L!BZN|10YNL----------L&resolution.values=PT60M&dateTime.timezone=CET_CEST&dateTime.timezone_input=CET+(UTC+1)+/+CEST+(UTC+2)"
    urlmorgen = "https://transparency.entsoe.eu/transmission-domain/r2/dayAheadPrices/show?name=&defaultValue=false&viewType=TABLE&areaType=BZN&atch=false&dateTime.dateTime="+"{:02d}".format(morgen.day)+"."+"{:02d}".format(morgen.month)+"."+str(morgen.year)+"+00:00|CET|DAY&biddingZone.values=CTY|10YNL----------L!BZN|10YNL----------L&resolution.values=PT15M&resolution.values=PT30M&resolution.values=PT60M&dateTime.timezone=CET_CEST&dateTime.timezone_input=CET+(UTC+1)+/+CEST+(UTC+2)"

    #print(urlvandaag)
    #print (urlmorgen)

    pagevandaag = webdriver.Chrome()
    pagemorgen = webdriver.Chrome()
    pagevandaag.get(urlvandaag)
    pagemorgen.get(urlmorgen)   
    
    soupv = BeautifulSoup(pagevandaag.page_source, 'html.parser')
    soupm = BeautifulSoup(pagemorgen.page_source, 'html.parser')

    pagevandaag.quit()
    pagemorgen.quit()

    price_hidev = soupv.find_all(class_='dv-value-cell')
    price_hidem = soupm.find_all(class_='dv-value-cell')
    returnvalues = []
    for price in price_hidev:
        try:
            #print(price)
            noISOdatum = str(price).split("\', \'")[2]
            
            datum = dt.datetime.fromisoformat(noISOdatum[:-1]) + dt.timedelta(hours=3)

            if ((datum.timestamp() - nu.timestamp()) >= 0):
                #print(datum + dt.timedelta(hours=-1))
                #print(price.text)
                returnvalues.append([datum, str(round(float(price.text)*0.00121, 7)), str(round(float(price.text)*0.00121, 7))])
        except:
            pass
    try:
        for price in price_hidem:
            try:
                #print(price)
                noISOdatum = str(price).split("\', \'")[2]
                datum = dt.datetime.fromisoformat(noISOdatum[:-1]) + dt.timedelta(hours=3)

                if ((datum.timestamp() - nu.timestamp()) >= 0):
                    #print(datum + dt.timedelta(hours=-1))
                    #print(price.text)
                    returnvalues.append([datum, str(round(float(price.text)*0.00121, 7)), str(round(float(price.text)*0.00121, 7))])
            except:
                pass
    except:
        pass
    return returnvalues