Navigation Panel

Pokazywanie postów oznaczonych etykietą electricity. Pokaż wszystkie posty
Pokazywanie postów oznaczonych etykietą electricity. Pokaż wszystkie posty

How to Quote Business for Electricity - Profile Projection

To precisely determine the offer electricity price for an end consumer, the projection of their consumption has to be calculated in advance. Such a projection may be obtained by applying various methods. In this post, I present a variant of the algebraic method, which I used in the previous article to calculate the projection of price structure. The volume projection should reflect the shape that is inherent to the group of consumers that a client belongs to, as well as cycles – yearly, weekly and daily (depicted above) and also usually depressed consumption in public holidays and edge days and, finally, be based on actual data.

The hourly load volume projection for a future delivery period is usually based on the hourly consumption observed in the past. If we have such a past load profile for at least one year, then we can project for a future period, for example, by applying the yearly and weekly (alternatively monthly) averaging for the defined day types and day hours. The full description of this averaging is contained in section “Curve Shape” in the article about a price structure projection.

The profile projection created from such averaging will reflect – just like the price structure – yearly, weekly and daily cycles and usually depressed consumption in public holidays and edge days, if the actual data present such regularity. The sum of the hourly consumption may be quite easily transformed to the contracted delivery volume by multiplying each projected value by a certain number or by adding to each projected value another number.

However, what if we do not have actual data? Then, the best way is to use the branch profile that a consumer belongs to (cinema, shopping centre, dairy, office, etc.). In case we do not have such data as well, we can use a standard profile published by a distribution system operator. If installed devices make it possible to measure consumption in zones, then a branch or standard profile may be further transformed to reflect load in each zone based on the invoices issued on a yearly or monthly basis. The load proportions can be then altered in such a way to correspond to those observed in the past.

In case of a purchasing group, that is if just one offer price is to be quoted for multiple entities with different load characteristics, then the volume projections are added in such proportions in which they constitute the purchasing group. Of course, the load profile of each entity may be adjusted based on actual data before it is finally added to the group.

Should you have any remarks or questions – please leave a comment or feel free to contact me.

How to Quote Business for Electricity? - Introduction


How an offer price for electricity is calculated? From my observations, there are few experts and information about this subject and the exchange of knowledge is rather scant. That's why I decided to write a series of articles about the determination of electricity prices quoted for companies. If you either prepare price lists or offers, or you compare them to choose the most optimal one, this material may be helpful to you. Here you will learn the currently applied practical approach which assures that the final quote conforms to the real market conditions as well as to the client's load profile.

Generally, the offer price, among others, contains:
  • delivery hedge cost (that is the 'black energy' cost),
  • premia resulting from certificates, risks, settlement dates, margins,
  • distribution and transmission fees.

In this article, I'll concentrate only on the general idea of the determination of the hedging cost. The other costs related to licences, market access, guarantees or IT tools are not the subject of this presentation.

As the basis for settlement in Poland is the hourly spot market, the hedge should be applied to the hourly positions for the whole delivery period.

In order to illustrate the five steps of the algorithm, I'll use the title graph. The graph is simplified, as it covers only 24 delivery hours, yet in the whole leap year 2020, there are 8784 hours.


1. Profile Projection

Firstly, we generate the hourly profile projection, that is the expected load volumes - represented by the blue curve on the rear wall of the graph - based on the information about a client (branch, invoice data, overall delivery volume).



2. Forward Price Structure

Secondly, we generate the price structure, that is the future hourly prices of energy on the spot market - represented by the blue curve on the lower wall of the graph - based on the past spot market prices (curve shape) as well as on the actual forward market prices for yearly, quarterly and monthly standard products (curve level).



3. Position

Then, we determine an hourly position, that is the hourly products of volumes and prices - these are the blue cuboids on the graph.


4. Hedge Products

Afterwards, we choose the volumes of the standard hedge products in such a way, that their total position - which is the sum of the volumes of the orange cuboids on the graph - be equal to the overall position being hedged - which is the sum of volumes of blue cuboids.
There are two orange cuboids on the graph - one for the base and one for the peak (in Poland the peak is defined between 8:00 and 22:00 in working days), but there can be either one or many of them - it depends on what products are available on the market at the moment and if it's really worth buying them for hedging.


5. Hedge Cost

In the end, we determine the hedge cost, that is we calculate the sum of volumes of the orange cuboids on the graph divided by the total delivery volume.

The above algorithm can be simplified in such a way to hedge the volume instead of the position - then it's not necessary to generate the forward price structure. However, there is a risk that due to the adverse correlation of price and load volume the hedge products will not be chosen optimally. If, for example, a client consumes more energy in the second half-year than in the first one, and in the second half-year we expect higher prices than in the first one, then - hedged with the yearly base product only - the surplus gained in the first half-year will not compensate for the loss in the second half-year. This risk is not worth taking if the forward price structure is generated regularly, e.g. in order to calculate the value of the whole sales portfolio.


It is reasonable to calculate quotes by taking into account the portfolio effect, e.g. as a difference between the hedge value for the whole portfolio with a client and the hedge value of the portfolio without a client. It is worth doing so especially when premia stemming from risks are calculated on the portfolio level.

Of course, the processes of quotes determination should be automated in order to assure:
  • prompt reaction to make an offer,
  • confidence that there will be no errors,
  • process audit and compliance with the existing internal regulations.

In case of any questions or remarks, we are looking forward to hearing from you.