Learn R Programming

finnishgrid

The goal of finnishgrid is to provide an easy one-liner access to all Fingrid Open Data API functions.

Installation

You can install the development version of finnishgrid from GitHub with:

# install.packages("devtools")
# required dependencies httr and jsonlite
# install.packages(c("httr", "jsonlite"))
devtools::install_github("virmar/finnishgrid")

Free API registration

Read basic API specification at https://data.fingrid.fi/en/instructions and register free user account.

Optional: add API key as your environment variable (~/.Renviron)

FINGRID_OPENDATA_API_KEY=MY_SECRET_KEY_FROM_API_PAGES

Example

Let’s get Finnish hourly electricity consumption and production time-series data for basic visualization.

library(finnishgrid)
start_time_utc = "2024-06-01T00:00:00.000Z"
end_time_utc = "2024-06-03T00:00:00.000Z"
user_key = NA  # TODO: replace with right key or use .Renviron file

Fetching data with helper functions

elec_cons <- powersys_electricity_consumption_FI_RTD(start_time_utc = start_time_utc,
                                            end_time_utc = end_time_utc,
                                            user_key = user_key)
Sys.sleep(1)

elec_prod <- powersys_electricity_production_FI_RTD(start_time_utc = start_time_utc,
                                           end_time_utc = end_time_utc,
                                           user_key = user_key)
Sys.sleep(1)

min_elec_cons <- min(elec_cons$value)  # consumption
max_elec_cons <- max(elec_cons$value)

min_elec_prod <- min(elec_prod$value)  # production
max_elec_prod <- max(elec_prod$value)

y_max <- max(max_elec_cons, max_elec_prod)
y_min <- min(min_elec_cons, min_elec_prod)

Basic data visualization

plot(elec_cons$start_time, elec_cons$value, type = 'l',
     col = "green", ylim = c(y_min, y_max),
     ylab = "Produced/Consumed (MW)",
     xlab = "Time", main = "Electricity",
     sub = "Data source Fingrid / data.fingrid.fi, license CC 4.0 BY")
lines(elec_prod$start_time, elec_prod$value, type = 'l', col = "blue")
legend("topright", c("Cons", "Prod"), fill = c("green", "blue"))

Get electricity consumption in Finland with get_data() function

API page: https://data.fingrid.fi/en/datasets/124

tmp <- get_data(api_number = 193,  # energy consumption
                start_time = start_time_utc, 
                end_time = end_time_utc, 
                user_key = NA)
summary(tmp)
#>  start_time_utc                 end_time_utc                     value     
#>  Min.   :2024-06-01 00:00:00   Min.   :2024-06-01 00:03:00   Min.   :6434  
#>  1st Qu.:2024-06-01 11:59:15   1st Qu.:2024-06-01 12:02:15   1st Qu.:6914  
#>  Median :2024-06-01 23:58:30   Median :2024-06-02 00:01:30   Median :7441  
#>  Mean   :2024-06-01 23:58:30   Mean   :2024-06-02 00:01:30   Mean   :7347  
#>  3rd Qu.:2024-06-02 11:57:45   3rd Qu.:2024-06-02 12:00:45   3rd Qu.:7726  
#>  Max.   :2024-06-02 23:57:00   Max.   :2024-06-03 00:00:00   Max.   :8166  
#>        id     
#>  Min.   :193  
#>  1st Qu.:193  
#>  Median :193  
#>  Mean   :193  
#>  3rd Qu.:193  
#>  Max.   :193

Copy Link

Version

Install

install.packages('finnishgrid')

Monthly Downloads

247

Version

0.2.0

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Maintainer

Markus Virtanen

Last Published

June 5th, 2024

Functions in finnishgrid (0.2.0)

border_id_trans_cap_EE_FI

Intraday transmission capacity EE-FI
border_da_trans_cap_SE1_FI_official

Day-ahead transmission capacity SE1-FI - official
border_da_trans_cap_FI_SE1_planned

Day-ahead transmission capacity FI-SE1 - planned
border_da_trans_cap_SE3_FI_official

Day-ahead transmission capacity SE3-FI - official
border_da_trans_cap_SE3_FI_planned

Day-ahead transmission capacity SE3-FI - planned
border_da_trans_cap_SE1_FI_planned

Day-ahead transmission capacity SE1-FI - planned
border_da_trans_cap_FI_SE3_official

Day-ahead transmission capacity FI-SE3 - official
border_da_trans_cap_FI_EE_official

Day-ahead transmission capacity FI-EE - official
border_da_trans_cap_FI_SE3_planned

Day-ahead transmission capacity FI-SE3 - planned
border_da_trans_cap_FI_SE1_official

Day-ahead transmission capacity FI-SE1 - official
border_id_trans_cap_FI_EE_RTD

Intraday transmission capacity FI-EE - real time data
border_measured_electricity_flow_FI_EE

Transmission of electricity between Finland and Estonia
border_id_trans_cap_EE_FI_RTD

Intraday transmission capacity EE-FI - real time data
border_id_trans_cap_SE1_FI

Intraday transmission capacity SE1-FI
border_id_trans_cap_SE3_FI

Intraday transmission capacity SE3-FI
border_id_trans_cap_FI_SE3

Intraday transmission capacity FI-SE3
border_id_trans_cap_FI_SE1

Intraday transmission capacity FI - SE1
border_id_trans_cap_FI_EE

Intraday transmission capacity FI-EE
border_measured_electricity_flow_FI_SE1

Transmission of electricity between Finland and Northern Sweden - measured every 15 minutes
border_measured_electricity_flow_FI_NO

Transmission of electricity between Finland and Norway
electricity_production_forecast15_FI_DA

Electricity production prediction - updated every 15 minutes
border_measured_electricity_flow_FI_SE3

Transmission of electricity between Finland and Central Sweden - measured every 15 minutes
electricity_consumption_forecast_FI_DA

Electricity consumption forecast - next 24 hours
electricity_production_FI

Electricity production in Finland
electricity_solar_pwr_production_forecast_quart_upd

Solar power generation forecast - updated every 15 minutes
electricity_production_forecast_FI_DA

Electricity production prediction - premilinary
electricity_solar_pwr_production_forecast_daily_upd

Solar power generation forecast - updated once a day
electricity_wind_pwr_production_forecast_daily_upd

Wind power generation forecast - updated once a day
electricity_consumption_FI

Electricity consumption in Finland
electricity_consumption_forecast_FI

Electricity consumption forecast
electricity_wind_pwr_production_forecast_quart_upd

Wind power generation forecast - updated every 15 minutes
congestion_income_FI_EE

Congestion income between FI-EE
esg_emission_factor_elec_production_FI_RTD

Emission factor of electricity production in Finland - real time data
fcr_d_hourlymarket_bidsum_down

Frequency containment reserve for disturbances downwards regulation, received bids in hourly market
electricity_solar_pwr_total_cap

Total production capacity used in the solar power forecast
fcr_d_nordictrade_up

Frequency containment reserves for disturbances upwards regulation, nordic trade
electricity_wind_pwr_production

Wind power generation - 15 min data
fcr_d_hourlymarket_bidsum_up

Frequency containment reserve for disturbances upwards regulation, received bids in hourly market
fcr_d_hourlymarket_procured_up

Frequency containment reserve for disturbances upwards regulation, procured volumes in hourly market
congestion_income_FI_SE1

Congestion income between FI-SE1
fcr_d_nordictrade_down

Frequency containment reserves for disturbances downward regulation, nordic trade
congestion_income_FI_SE3

Congestion income between FI-SE3
fcr_n_activated

Frequency Containment Reserve for Normal operation, activated
fcr_n_activated_down

Frequency Containment Reserve for Normal operation, activated down-regulation
fcr_n_hourlymarket_prices

Frequency Containment Reserve for Normal operation, hourly market prices
fcr_n_yearlymarket_plans

Frequency Containment Reserve for Normal operation, yearly market plans
fcr_d_yearlymarket_plans_up

Frequency containment reserves for disturbances upwards regulation, reserve plans in the yearly market
fcr_d_hourlymarket_prices_down

Frequency containment reserves for disturbances downwards regulation, hourly market prices
ffr_procurement_forecast

Fast Frequency Reserve FFR, procurement forecast
fcr_n_activated_up

Frequency Containment Reserve for Normal operation, activated up-regulation
ffr_price

Fast Frequency Reserve FFR, price
fcr_d_yearlymarket_plans_down

Frequency containment reserves for disturbances downward regulation, reserve plans in the yearly market
fcr_n_hourlymarket_volumes

Frequency Containment Reserve for Normal operation, hourly market volumes
ffr_procured

Fast Frequency Reserve FFR, procured volume
esg_emission_factor_elec_consumption_FI_RTD

Emission factor for electricity consumed in Finland - real time data
electricity_wind_pwr_total_cap

Total production capacity used in the wind power forecast
imbalance_incentcomp_NO1

Incentivising Component (IC) NO1
imbalance_incentcomp_FI

Incentivising Component (IC) FI
imbalance_incentcomp_NO3

Incentivising Component (IC) NO3
imbalance_incentcomp_NO2

Incentivising Component (IC) NO2
get_page_data

Returns one page of JSON data
imbalance_consumption_price

The price of comsumption imbalance electricity
imbalance_incentcomp_DK2

Incentivising Component (IC) DK2
imbalance_incentcomp_DK1

Incentivising Component (IC) DK1
fcr_n_hourlymarket_bidsum

Frequency Containment Reserve for Normal operation, hourly market bids
get_data

Main logic forming the API call.
ffr_received_bids

Fast Frequency Reserve FFR, received bids
fcr_d_hourlymarket_procured_down

Frequency containment reserve for disturbances downwards regulation, procured volumes in hourly market
fcr_n_foreign_trade

Frequency Containment Reserve for Normal operation, foreign trade
fcr_d_hourlymarket_prices_up

Frequency containment reserves for disturbances upwards regulation, hourly market prices
imbalance_production_sales_price

The sales price of production imbalance electricity
imbalance_production_purchase_price

The buying price of production imbalance electricity
imbalance_incentcomp_NO4

Incentivising Component (IC) NO4
imbalance_incentcomp_NO5

Incentivising Component (IC) NO5
imbalance_incentcomp_SE3

Incentivising Component (IC) SE3
imbalance_incentcomp_SE4

Incentivising Component (IC) SE4
imbalance_voaa_se1

Value of Avoided Activation (VoAA) SE1
imbalance_voaa_se2

Vältetyn aktivoinnin arvo (VoAA) SE2
imbalance_voaa_fi

Value of Avoided Activation (VoAA) FI
imbalance_voaa_no2

Value of Avoided Activation (VoAA) NO2
imbalance_incentcomp_SE1

Incentivising Component (IC) SE1
imbalance_incentcomp_SE2

Incentivising Component (IC)SE2
imbalance_voaa_se4

Value of Avoided Activation (VoAA) SE4
imbalance_voaa_se3

Value of Avoided Activation (VoAA) SE3
imbalance_voaa_no3

Value of Avoided Activation (VoAA) NO3
mfrr_cm_hourly_bids_up

Balancing Capacity (mFRR), up, hourly market, bids
mfrr_cm_hourly_bids_down

Balancing Capacity (mFRR), down, hourly market, bids
imbalance_voaa_no1

Value of Avoided Activation (VoAA) NO1
imbalance_voaa_no4

Value of Avoided Activation (VoAA) NO4
mfrr_cm_hourly_price_down

Balancing Capacity (mFRR), down, hourly market, price
imbalance_voaa_no5

Value of Avoided Activation (VoAA) NO5
mfrr_em_ordered_regulations_down

Ordered down-regulations from Balancing energy market in Finland
mfrr_cm_hourly_price_up

Balancing Capacity Market (mFRR), up, hourly market, price
mfrr_cm_hourly_procured_up

Balancing Capacity (mFRR), up, hourly market, procured volume
mfrr_cm_weekly_price

Balancing Capacity Market price
mfrr_cm_hourly_procuforecast_down

Balancing Capacity (mFRR), down, hourly market, procurement forecast
mfrr_cm_hourly_procuforecast_up

Balancing Capacity (mFRR), up, hourly market, procurement forecast
mfrr_em_hour_change_regulation_down

Hour change regulation, down-regulation
mfrr_em_special_regulation_up

Special regulation, up-regulation
mfrr_em_hour_change_regulation_up

Hour change regulation, up-regulation
nscut_measured_flow

Measured transmission of electricity in Finland from north to south
mfrr_em_bids_price_last_activated_down_RTD

Down-regulation bids, price of the last activated - real time data
mfrr_em_price_last_activated_bid_RTD

Price of the last activated up-regulation bid - real time data
mfrr_em_ordered_regulations_up

Ordered up-regulations from Balancing energy market in Finland
mfrr_cm_weekly_procured

Balancing Capacity Market results
mfrr_em_other_pwr_regulation_down

Other power transactions, down-regulation
mfrr_em_price_regulation_down

Down-regulation price in the Balancing energy market
imbalance_power_FI_SE

Imbalance power between Finland and Sweden
imbalance_voaa_dk1

Value of Avoided Activation (VoAA) DK1
powersys_electricity_netimport

Net import/export of electricity - real time data
mfrr_cm_hourly_procured_down

Balancing Capacity (mFRR), down, hourly market, procured volume
mfrr_em_bids_sum_regulation_up

The sum of the up-regulation bids in the balancing energy market
imbalance_price

Imbalance price
imbalance_voaa_dk2

Value of Avoided Activation (VoAA) DK2
powersys_electricity_consumption_FI_RTD

Electricity consumption in Finland - real time data
powersys_cumulative_surplus_RTD

Surplus/deficit, cumulative - real time data
mfrr_em_price_regulation_up

Up-regulating price in the Balancing energy market
mfrr_em_bids_sum_regulation_down

The sum of the down-regualtion bids in the Balancing energy market
mfrr_cm_hourly_procured_EE

Balancing Capacity (mFRR), hourly market, procurement from Estonia
powersys_cogeneration_district_heating_RTD

Cogeneration of district heating - real time data
powersys_industrial_cogeneration_RTD

Industrial cogeneration - real time data
powersys_hydro_power_production_RTD

Hydro power production - real time data
mfrr_em_special_regulation_down

Special regulation, down-regulation
powersys_kinetic_energy_nordic_pwr_sys_RTD

Kinetic energy of the Nordic power system - real time data
nscut_weekly_plan_cap_NS

Planned weekly capacity from north to south
mfrr_em_other_pwr_regulation_up

Other power transactions, up-regulation
powersys_production_surplus

Electricity production, surplus/deficit - real time data
powersys_time_deviation_RTD

Time deviation - real time data
powersys_state_RTD

Power system state - real time data
powersys_electricity_shortage_status_RTD

Electricity shortage status
powersys_trans_FI_EE_RTD

Transmission between Finland and Estonia - real time data
powersys_temp_rovaniemi_RTD

Temperature in Rovaniemi - real time data
powersys_trans_FI_SE1_RTD

Transmission between Finland and Northern Sweden - real time data
powersys_trans_FI_NO_RTD

Transmission between Finland and Norway - real time data
powersys_peak_load_power_RTD

Peak load power - real time data
powersys_frequency_RTD

Frequency - real time data
powersys_temp_helsinki_RTD

Temperature in Helsinki - real time data
powersys_trans_FI_OO_RTD

Transmission between Sweden and Åland - real time data
powersys_nuclear_power_production_RTD

Nuclear power production - real time data
powersys_trans_FI_SE3_RTD

Transmission between Finland and Central Sweden - real time data
powersys_wind_pwr_production_RTD

Wind power production - real time data
powersys_electricity_production_FI_RTD

Electricity production in Finland - real time data
nscut_weekly_plan_cap_SN

Planned weekly capacity from south to north
powersys_electricity_production_reservetotal_RTD

Electricity production, reserve power plants and small-scale production - real time data
powersys_temp_jyvaskyla_RTD

Temperature in Jyväskylä - real time data
powersys_temp_oulu_RTD

Temperature in Oulu - real time data
afrr_activated_up

Automatic Frequency Restoration Reserve, activated, up
afrr_price_down

Automatic Frequency Restoration Reserve, price, down
afrr_activated_down

Automatic Frequency Restoration Reserve, activated, down
border_commercial_electricity_flow_FI_SE3

Commercial transmission of electricity between FI-SE3
afrr_capacity_down

Automatic Frequency Restoration Reserve, capacity, down
border_commercial_electricity_flow_FI_SE1

Commercial transmission of electricity between FI-SE1
border_commercial_electricity_flow_FI_EE

Commercial transmission of electricity between FI-EE
border_da_trans_cap_EE_FI_official

Day-ahead transmission capacity EE-FI - official
afrr_price_up

Automatic Frequency Restoration Reserve, price, up
afrr_capacity_up

Automatic Frequency Restoration Reserve, capacity, up