Formula calculation

Formulas

On the fly formula calculation

The Timeseries Refinery includes a rich set of built-in operators to create advanced, real-time calculations with ease. Designed to be intuitive and user-friendly, it ensures full traceability and auditability across your system, from the dashboards down to the primary sources.


Timeseries Refinery formula editor

Formulas

Build formulas in no-code

Building formulas is effortless thanks to a user-friendly interface with dropdown menus for all operators and a powerful search engine that makes navigating the series catalog fast and intuitive.

Formulas

View the formula in the series info page

Each formula is fully auditable from the information page of the series itself down to the primary source series — ensuring transparency, reliability, and trust in your data.

Formula time series info screenshot
Formula versions screenshot

Formulas

Versioned formulas

When a formula is changed, the version of the formula is logged with the user name or script name that has made the modification.

Formulas

Build formulas in bulk

Easily generate formulas in bulk by uploading a CSV file or automate the process programmatically using the Python API or REST API.


Request a demo

References

Designed and used by experts from:

TotalEnergies Engie PetroIneos Mercuria eFlower WirelessCar Elax Energie Greenalp EPYR KallistaEnergy

The Timeseries Refinery is an open-source platform for storing, computing and visualising versioned time series data — built for data-driven teams in energy, trading and industry. Its bitemporal storage keeps every version of every series: any series can be queried as it was known at any past date (as-of queries) — and computed series follow the same law: formulas evaluate against the versions known at that date. It provides a traceable formula engine, real-time dashboarding, an Excel client, and full Python and REST APIs. Learn more