Get prices from webpage via Excel

[admin]

This will get day-ahead prices from yesterday:

Code:

date = os.date('*t')
date.day = date.day - 1
param = os.date('%d-%m-%Y', os.time(date))

res = ssl.https.request('https://www.nordpoolgroup.com/api/marketdata/page/23?currency=NOK&endDate=' .. param)