The new App of Indexed Prices allows you to import indexed prices from multiple countries into your project based on the formula you have contracted with your trading company.
In this way, you will be able to calculate how much your consumption represents in euros, depending on the formula offered by your supplier with the variables of the free market in each country.
Currently, the application is integrated with the markets of the following countries:
- Spain: ESIOS (Red Eléctrica Española)
- Portugal: Redes Energéticas Nacionais
This article includes the following sections:
- Prerequisites to be able to set up the indexed prices
- Configuration of the indexed prices
- Overview of the home screen
- Import of prices
- Country concepts included in the application
- User or variable concepts
- Additional information
Prerequisites to be able to set up the indexed prices
The first step before you start using this application is to create your prices in the Supplies and Prices section. When you do so, you must select the option "Based in wholesale market". Subsequently, in the "Price change interval" you will select the frequency depending on the tariff structure of each country:
- Spain prices: Hourly
- Portugal prices: 30 minutes
To learn how to create these prices, click on the following link. This article may also be of interest to you.
Configuration of the indexed prices
All prices created will appear on the initial screen, distributed in two tables: configured and not configured. Initially, all the prices will appear in the non-configured table pending to be configured. From that table, and selecting the Configure button, the configuration menu will open, where you will have to follow the following steps:
- Define your indexed price formula.
- Select the applicable losses, in case they are included in your price.
- Create the variable concepts you need and use them in your formula.
- Variable items can have as many price changes as necessary.
- Select the date from which you want to calculate the price, and... That's it!
Overview of the home screen
The home screen will show the indexed prices divided into two tables, depending on whether they have already been configured or not.
The following fields will be displayed in the configured table:
- Country of the selected indexed price.
- Last indexed price that the application has been able to calculate.
- NOTE: depending on the country, this date will be one or another. In the case of Spain, if everything works fine, the date will be the current day at 23:00 h, and in the case of Portugal at 23:30 h because it is a market that operates with 30-minute prices.
- Last indexed price that the application has been able to consolidate.
- NOTE: Indexed prices will only be consolidated in the case of Spain, where the final C2 market closing price will be used.
- Status of the price, if it has been calculated correctly, or if any problem has occurred.
- CORRECT: The price is being calculated correctly.
- WARNING: The price could not be calculated correctly in the last 24 hours. This symbol is displayed whenever values of the items could not be obtained in the last recalculation, and by hovering the mouse over it, you can obtain information on which item could not be obtained.
- NOTE: in the case of using the SNP concept in the Spanish market, this symbol will always appear in your price, since ESIOS publishes the SNP concept two days in advance compared to the rest of the concepts.
- ERROR: The price cannot be calculated due to a configuration error.
- Configuration actions:
- The possibility of recalculating the price from a date other than the one already calculated.
- The possibility of deleting the configuration for that price.
- NOTE: this action will be necessary if you wish to modify the current price configuration.
Import of prices
Prices are calculated and imported to the platform, depending on the country, each day at the following times:
- Spain: at 03:00 of the current day.
- Example: on 01/01/2024 at 03:00 the prices will be calculated until 23:00 of the same day.
- Portugal: at 23:00 of the previous day.
- Example: on 01/01/2023 at 23:00 the prices will be calculated until 23:30 of the following day.
Country concepts included in the application
Spain
Currently, the application contains the following concepts for the Spanish market:
You can also select the network loss concept obtained from market openings and closings, which ESIOS publishes in its documents.
The losses that can be selected are:
- 2.0TD
- 3.0TD y 3.0TDVE
- 6.1TD y 6.1TDVE
- 6.2TD
- 6.3TD
- 6.4TD
Portugal
Currently, the application contains the following concepts for the Portugal market:
- MD: Daily Market (calculated by OMIE and published by REN).
- LOSS: Network Losses published by the Entidade Reguladora dos Serviços Energéticos including:
- BT: Low Voltage
- MT: Medium Voltage
- AT: High Voltage
- AT/RT: High Voltage / Transmission Grids
- MAT: Very High Voltage
User or variable concepts
You can define as many variable concepts as you want, with the name you want and per period, adding as many price changes as you need.
These concepts are available in all prices, regardless of the country of your defined tariff.
Additional information
Other points to bear in mind for the proper functioning and understanding of the application are the following:
- Once a price has been configured, price changes can be added for variable concepts on future dates, but if you wish to modify the formula or add price changes in the past, the configuration must be deleted, and a new one must be created.
- Once you have created a price configuration, within the configuration screen the date field will be locked and will indicate the date for which that price started to be calculated. In case you decide to recalculate that price (from the initial screen) for an earlier date than the one selected in the initial configuration, that date will be updated to indicate that the price has been recalculated from an older date than the one initially selected.
- The concepts that include a drop-down menu have only one variable name, and that is the one you should use in the formula regardless of the selected option.