Automatic downloading of ‘Export data’ information
The automatic processing of information from the TenneT website can now be easily realised by downloading the information from the 'Export data' page. The required data, period and format can be indicated in the URL, after which you will immediately receive the export file.
This way of automatically downloading data is, however, linked to the way the new website works. If you wish to process the data from the website in an independent manner, you can use the XML files we offer (see XML Downloads and http://www.tennet.org/xml).
Data can be requested automatically by means of parameters. The following parameters can be used for this purpose:
| Name | Value |
| format | xml, csv, xls |
| datefrom | dd-mm-yyyy (e.g. 1-6-2006, 18-10-2006) |
| dateto | dd-mm-yyyy (e.g. 1-6-2006, 18-10-2006) |
| submit | 1 (for standard export with datefrom and dateto) |
| 2 (for 30-day-ahead market) | |
| 3 (for installed capacity) | |
| exporttype | see table below |
| Data | parameter |
| Balance Delta | balancedelta |
| Available capacity | availablecapacity |
| Bid price ladder | bidpriceladder |
| 30-day-ahead market | thirtydaysahead |
| History of deployed regulating and reserve capacity | volumerrecapacity |
| History of PRP imbalance | volumesettledimbalance |
| Ladder size < 15 min | laddersize15 |
| Total ladder size | laddersizetotal |
| Measurement data | measurementdata |
| Imbalance | imbalance |
| Imbalance price | settlementprices |
| Installed capacity | installedcapacity |
| Regulating margin | regulatingmargin |
| System balance | systembalance |
Examples
Data on the Balance Delta, dated 1 to 2 January 2006, in XML format:
http://www.tennet.org/english/operational_management/export_data.aspx?exporttype=balancedelta&format=xml&datefrom=1-1-2006&dateto=2-1-2006&submit=1
Data on available capacity, dated 1 to 28 February 2006, in CSV format:
http://www.tennet.org/english/operational_management/export_data.aspx?exporttype=availablecapacity&format=csv&datefrom=1-2-2006&dateto=28-2-2006&submit=1
Data on the bid price ladder, dated 1 to 31 March 2006, in Excel format:
http://www.tennet.org/english/operational_management/export_data.aspx?exporttype=bidpriceladder&format=xls&datefrom=1-3-2006&dateto=31-3-2006&submit=1
30-day-ahead market
The parameters for the 30-day-ahead market are not entirely the same.| parameter | values |
| tso | 1 (= E.ON Netz) |
| 2 (= ELIA) | |
| 3 (= RWE Net) | |
| submit | 2 |
Example:
Data on the 30-day-ahead market of RWE Net, in Excel format: http://www.tennet.org/english/operational_management/export_data.aspx?exporttype=thirtydaysahead&tso=3&format=xls&submit=2
Installed capacity
The parameters for the installed capacity are not entirely the same.| parameter | values |
| quarter | yyyy-q |
| (2007-1, 2007-2, etc) | |
| submit | 3 |
Example:
Data on installed capacity from the first quarter of 2007, in CSV format:
http://www.tennet.org/english/operational_management/export_data.aspx?exporttype=installedcapacity&format=csv&quarter=2007-1&submit=3