Negative Number - Printable Version

Code:
local http = require('ssl.https')

local json = require('json')



local date = os.date('*t') -- get today's date

local year = tostring(date.year)

local month = string.format('%02d', date.month)

local day = string.format('%02d', date.day)

local area = 'NO3' -- specify area



local url = string.format('https://www.hvakosterstrommen.no/api/v1/prices/%s/%s-%s_%s.json', year, month, day, area)



log('Fetching data from URL:', url)



local body, code, headers, status = http.request(url)



log('HTTP response code:', code)



if code == 200 then

    --log('Data retrieved successfully')

    --log('Response body:', body)



    local data = json.decode(body)

    log(data)



    local min_price = math.huge -- start with a very high value for minimum

    local max_price = -math.huge -- start with a very low value for maximum

    local total_price = 0

    local count = 0



    for i, item in ipairs(data) do

        local start_hour = string.sub(item.time_start, 12, 13)

        local end_hour = string.sub(item.time_end, 12, 13)

        local price = item.NOK_per_kWh



        -- Calculate min, max, and total prices for average

        if price < min_price then min_price = price end

        if price > max_price then max_price = price end

        total_price = total_price + price

        count = count + 1





        local time_range = string.format("%s TIL %s", start_hour, end_hour)



      --  log("Time Range:", time_range)

      --  log("Price:", price)



       

        

            local address = '35/0/' .. i  -- Example: '35/0/1', '35/0/2', etc.



            grp.create({name = time_range, address = address, datatype = 09})

            grp.write(time_range, price )

            



            -- Small delay between each write

            os.sleep(0.)

        

        

    end





    local average_price = total_price / count







    grp.write('35/1/0', min_price )

    grp.write('35/1/1', max_price )

    grp.write('35/1/2', average_price)



else

    log('Error fetching data:', status)

end