krose / nordpoolspotr

An R Wrapper to the NordPool Spot API.
0 stars 1 forks source link

Code not working any longer #1

Open mablmabl opened 1 month ago

mablmabl commented 1 month ago

This code will return a status code of 404

page=10 currency = "SEK price_date = Sys.Date()

np <- httr::GET(paste0("http://www.nordpoolgroup.com/api/marketdata/page/", page, "?currency=,", currency, currency, currency, "&endDate=", strftime(price_date, "%d-%m-%Y")))

and the code to unpack the content of np will not work

What has happened?

krose commented 1 month ago

They changed the api and the data has been locked up a bit more.

søn. 20. okt. 2024 11.16 skrev Mats Blomqvist @.***>:

This code will return a status code of 404

page=10 currency = "SEK price_date = Sys.Date()

np <- httr::GET(paste0("http://www.nordpoolgroup.com/api/marketdata/page/", page, "?currency=,", currency, currency, currency, "&endDate=", strftime(price_date, "%d-%m-%Y")))

and the code to unpack the content of np will not work

What has happened?

— Reply to this email directly, view it on GitHub https://github.com/krose/nordpoolspotr/issues/1, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEP2CNPX2YPLRUVWSRLTSTZ4NYG7AVCNFSM6AAAAABQIKPPZOVHI2DSMVQWIX3LMV43ASLTON2WKOZSGYYDAMRRGM4DANI . You are receiving this because you are subscribed to this thread.Message ID: @.***>

mablmabl commented 1 month ago

Ouch :-(

Is it no longer possible to get data, i.e. to change the code to work?

krose commented 1 month ago

Except from system prices, you can get much of the same data from https://github.com/krose/entsoeapi

søn. 20. okt. 2024 11.38 skrev Mats Blomqvist @.***>:

Ouch :-(

Is it no longer possible to get data, i.e. to change the code to work?

— Reply to this email directly, view it on GitHub https://github.com/krose/nordpoolspotr/issues/1#issuecomment-2424780731, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEP2CJAHBJ2GHEFOW2CAWDZ4N2YPAVCNFSM6AAAAABQIKPPZOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMRUG44DANZTGE . You are receiving this because you commented.Message ID: @.***>

mablmabl commented 1 month ago

Thanks for directing me to this. However I cannot understand how to get the prices from Entsoeapi. Background: I have a solar panel system on our roof. In order to calculate earnings I download hourly energy prices once a month by looping the code above and changing price_date. Can you direct me to where in Entsoeapi I can find the same functionality I would be very grateful. As I am not a professional energy person I do not know what system price is, I just want what the energy company calls spot price i.e. what I pay och get paid from them. Many thanks from a marine biologist

krose commented 1 month ago

Follow the readme.

mablmabl commented 3 weeks ago

Finally got the key. Everything works fine. Thanks for your guidance! One final question, is it possible to change currency so transm_day_ahead_prices will respond in SEK instead of EUR?

krose commented 3 weeks ago

It's sadly not published in SEK on the ENTSOE API. I suggest you use another package with financial data to get the fx rate in EURSEK.

mablmabl commented 3 weeks ago

ok, thanks for a quick response :-)