Overview

The Data Series module is one of the core components of Atlas ETRM. It stores and manages all time-series data used across the platform, including market prices, volume profiles, forward curves, Mark-to-Market (MTM) curves, climatic data, exchange rates, index values, and other factors.

To access Data Series, open the Data Room menu in the left-hand navigation and select Available Data Series. The Available Data Series screen presents a grid listing all data series registered in the system. For a full description of each column, see Appendix — Field Details.

Naming Convention

System-generated data series (those not created directly by a user) follow a standardised naming pattern:

{Provider}_{Tag1}_{Tag2}_…_{TagN}_{Dataset}

Where Provider is the data source, Tag fields fully describe the entity (e.g. bidding zone, thermal unit EIC, country), and Dataset is the unique dataset label.

Filtering and Queries

The grid provides two ways to locate data series, which can be used independently or together.

Grid Queries

A query builder row at the top of the grid allows the user to define filtering rules by selecting a column, choosing an operator (e.g. contains, equals, begins with), and entering a value. The filter is applied by pressing Enter or clicking Apply.

Queries can be saved for future use by selecting Create New Query from the Select Grid Query drop-down at the top-right of the grid. Saved queries can be recalled, modified, or cleared at any time.

Example

To display only data series produced by the Math Editor, set the rule Module equals “Math Editor”.

Then save the query for future use.

Search by Name

The Search by Name field in the upper-right corner allows free-text keyword search across data series names. The field supports the asterisk (*) as a wildcard character — for example, entering DAM*GR returns all series whose names contain both “DAM” and “GR” regardless of order. Filtering operates server-side, ensuring efficient performance over large datasets.

If a grid query is currently active, the Search by Name filter is applied on top of it, further narrowing the results within that query.

Creating a Data Series

There are two ways to create a data series:

Α. Manual creation

Click the + button at the top of the grid, fill in the required details in the form that appears (Name, Granularity, Type, UOM, upsampling/downsampling methods) and click Create.

Β. Excel template upload

Use the Create Dataseries button for bulk creation. For more details, see Mass Actions — Creating Data Series Entries via Template.

In both cases, the series is created with its metadata but contains no data values yet. To enter data, either type or paste values directly in the Data tab (see Editing a Data Series — Option A below) or use the Update Dataseries Data button for bulk loading (see Mass Actions — Loading and Updating Data Values via Template).

Editing a Data Series

A data series has two distinct editable parts: its metadata and its data values.

Editing Metadata

Basic metadata (Name, Type, UOM, upsampling, downsampling) can be edited by clicking the pencil icon in the Actions column of the grid, or by opening the series and clicking the Edit button.

Note: Granularity cannot be changed once a data series has been created. If a different granularity is needed, create a new series.

Editing Data Values

There are two ways to edit data values:

Α. Manual editing

Open the series, navigate to the Data tab, click the edit button above the table, type or paste values into the New Value column, then click Save.

Important: Always click Save after making changes. Navigating away without saving will discard all edits.

Β. Excel template upload

From the main grid — where multiple series can be selected at once, even across different granularities — or from within an individual series info page, use the Update Dataseries Data button. Recommended when loading or updating large date ranges. For more details, see Mass Actions — Loading and Updating Data Values via Template.

Deleting a Data Series

A data series may be deleted either from the grid or from the series info page.

From the grid, right-click the desired row and select Delete Dataseries. Multiple series can be deleted at once by first selecting them using the checkboxes.

Alternatively, open the series and click the Delete button in the left-hand panel.

Mass Actions

Creating Data Series Entries via Template

This process may be used to create one or more new data series and define their structure in a single upload.

1. In the Available Data Series grid, click Create Dataseries → Download Dataseries Create Template. An Excel file is downloaded to your computer.

2. Open the template in Excel. Each row defines one data series. Fill in the required columns: Name, Module, Upsampling & Downsampling Method, Source, Granularity, Type and UOM.

3. Save the completed file.

4. Return to the grid and click Create Dataseries → Create Dataseries. Select the completed file in the upload dialog and confirm.

5. The new data series appear in the grid. They are created with their metadata but contain no data values yet. To populate them with data, proceed to Loading and Updating Data Values via Template below.

Loading and Updating Data Values via Template

This process may be used to enter or update data values across one or more existing data series for a specific date range.

1. In the Available Data Series grid, select one or more data series using the checkboxes on the left.

2. Click Update Dataseries Data → Download Data Update Template.

3. A dialog appears where you set the target date range and time zone for the update.

4. Click Submit. An Excel file pre-populated with the selected series and date range is downloaded to your computer.

5. Open the file in Excel and populate the value columns with the new data. Copy-paste from existing spreadsheets is supported.

6. Save the completed file.

7. Return to the grid and click Update Dataseries Data → Update Data. Select the completed file and confirm the upload.

8. Open any of the updated series and navigate to the Data tab to verify the new values have been applied correctly.

Data Series Info Page

Double-clicking a row in the grid opens the data series info page in a new tab. The info page is divided into two tabs: Chart and Data.

Chart tab

Renders the time series as a line chart for a user-selected date range and time-zone. Indicators above the chart display the minimum, maximum, average, and sum for the visible range. The mouse scroll wheel can be used to zoom in and out. The left-hand panel shows the series metadata and provides the Load, Edit, and Delete action buttons.

Data tab

Displays data values in tabular form for the selected range. The table can be exported to Excel or CSV using the Data Export button. Values can be edited directly in this tab (see Section 2 — Editing a Data Series).

Appendix — Field Details