Historical Analysis and Estimation Tool for Energy Trading
View/ Open
Abstract
Many forms of commodities are traded in today’s financial world, the most commonly used commodity, ‘Electricity’, is no exception. Electricity is mostly traded on a day to day basis, where the buyers and suppliers agree on a fixed price for electricity to be generated and dispatched. These allow the markets to adjust themselves to efficient pricing based on the simple supply and demand principle.
The objective of this paper is to understand the day ahead market data and collecting historical market data and storing in to a RDBMS database, and design and program a windows-based application using C# programming language, to query the RDBMS in transact SQL to display the market data in a format that is easy to read. Use of this tool would allow deeper analysis and provide the ability to estimate possible profitability for future trading by calculating the variances, standard deviation, upper bounds, lower bounds, averages.