Dataset: UK Energy Trading

About this Dataset

UK Energy Trading

Context
In the Great Britain market, you can also trade without an asset such as a power plant, renewables or batteries. Therefore, it can be differentiated between physical trades – backed by an asset – and solely financial non-physical trades on the markets without actually providing or receiving energy.

This dataset can be used in building forecast models, optimisation models and in developing first trading strategies for both physical and non-physical energy trading.

A primer: Using this dataset, one can have a closer look into two auctions of the day-ahead electricity market in Great Britain and develop as well as backtest a trading strategy maximising profits between both auctions.

Content

 a csv-file (“auction_data.csv”) containing actual prices and traded volumes of both auctions as well as a price forecast for the first auction
 a csv-file (“forecast_inputs.csv”) with input variables that can be used to forecast the prices of the second auction (you can find a more detailed description of the input variables in a separate txt-file – “description_input_variables.txt”)
 a csv-file (“system_prices.csv”) with the forecasted price range of the system prices as well as the actual prices

Tables

Auction Data

@kaggle.kapilverma_uk_energy_trading.auction_data

481.26 KB
14880 rows
6 columns


CREATE TABLE auction_data (
  "date_wet" VARCHAR,
  "price_first_auction" VARCHAR,
  "price_second_auction" VARCHAR,
  "traded_volume_first_auction" VARCHAR,
  "traded_volume_second_auction" VARCHAR,
  "price_forecast_first_auction" VARCHAR
);

Forecast Inputs

@kaggle.kapilverma_uk_energy_trading.forecast_inputs

1.12 MB
14880 rows
19 columns


CREATE TABLE forecast_inputs (
  "date_wet" VARCHAR,
  "demand_plus_system_margin" VARCHAR,
  "demand" VARCHAR,
  "within_day_availability" VARCHAR,
  "margin" VARCHAR,
  "within_day_margin" VARCHAR,
  "long_term_wind" VARCHAR,
  "long_term_solar" VARCHAR,
  "long_term_wind_over_demand" VARCHAR,
  "long_term_wind_over_margin" VARCHAR,
  "long_term_solar_over_demand" VARCHAR,
  "long_term_solar_over_margin" VARCHAR,
  "margin_over_demand" VARCHAR,
  "snsp_forecast" VARCHAR,
  "stack_price" VARCHAR,
  "within_day_potential_stack_price" VARCHAR,
  "previous_day_ahead_price" VARCHAR,
  "previous_continuous_half_hour_vwap" VARCHAR,
  "inertia_forecast" VARCHAR
);

System Prices

@kaggle.kapilverma_uk_energy_trading.system_prices

304.92 KB
14880 rows
4 columns


CREATE TABLE system_prices (
  "date_wet" VARCHAR,
  "forecast_system_price_low" VARCHAR,
  "forecast_system_price_high" VARCHAR,
  "system_price" VARCHAR
);