Fundamental Data Manager

Support & Implementation

Current Jobs

About Us

Contact Us

Fundamental Data Manager

Support & Implementation

Current Jobs

About Us

Contact Us

Fundamental Data Manager

The Fundamental Data Manager is a modular system for the collection of commodities and financial data curves

Support & Implementation

Lilac provides the full range of services required to develop, implement and support the solutions we offer.

Current Jobs

The Lilac team boasts a strong mix of technical and industry skills, using the latest development tools.

About Us

Lilac Energy Software Solutions is a specialist supplier of software systems to energy and commodity clients worldwide.

Lilac Energy Software Solutions is a specialist supplier of software systems to energy and commodity clients worldwide.

The Lilac team boasts a strong mix of technical and industry skills, using the latest development tools together with strong experience and a targeted approach.

Our broad experience and knowledge enables us to grasp complex problems quickly, put requirements into context and design and deliver intuitive, well-engineered solutions that combine flexibility and efficiency.

Lilac understands that every energy business is different, and needs solutions that work for that business and match the individual client’s priorities.

Lilac Energy Software Solutions Ltd, Registered Company number SC447961

Our Partners

Lilac and Refinitiv work in close partnership to offer solutions to clients that automates Refinitiv PointConnect, DSS and Elektron data take-on allowing them to easily commingle, manage and analyse. Clients have the flexibility of implementing these solutions as cloud or a client-hosted installation. The close co-operation between Lilac and Refinitiv strengthens both companies’ data offerings and will offer customers a comprehensive overall solution.

Lilac Energy Software Solutions has a partnership with APT Energy to deliver a portfolio of highly detailed interactive Energy Trading Simulations. These trading games have been developed with major utilities ensuring a detailed and realistic insight and hands-on experience covering most European markets.

Lilac Energy Software solutions has a partnership with APT Energy to deliver a portfolio of highly detailed interactive Energy Trading Simulations. These trading games have been developed with major utilities ensuring a detailed and realistic insight and hands-on experience covering most European markets

About us

Lilac Energy Software Solutions is a specialist supplier of software systems to energy and commodity clients worldwide. The Lilac team has a strong mix of technical and industry skills, using the latest development tools which combines with strong experience and a targeted approach.

Lilac staff have almost 20 years of experience within the field of system and service solutions for the deregulated energy markets, starting within market modelling, contract analysis, price forecasting consultancy followed by developing trading, decision support and contract management systems for energy companies throughout Europe. Our team has extensive knowledge of delivering software development and services projects on time and to budget. 

We have a constantly increasing product range and a number of clients and partners throughout Europe. Lilac’s main offering is its Fundamental Data Management system and this forms our main software product.

Our aim is to become the leading global provider of Fundamental Data Management software for a variety of data types and clients ranging from Energy to Agriculture who want to look at specific and detailed market analysis and scenarios.

The team has a flexible approach in delivering solutions and works closely with its clients to ensure timely delivery of solutions, services and focused advice. Projects are carefully managed to ensure they are delivered on time and to budget.

Fundamental Data Manager

The Fundamental Data Manager (FDM) is a modular system for the collection of commodities and financial data curves, which typically include forecast and actual commodity consumption and production, and actual and forecast market prices.The system has been designed to support data inputs from a variety of sources as well as customer-generated (“Proprietary”) data.

Regardless of source, the system maintains a catalogue of metadata describing the source and nature of the data stored, allowing keyword and other searches across all data held in the system.

Access to the data and metadata is made available using REST API, and optionally also via a published database API (Microsoft SQL Server) and as such can be accessed by any data-aware tool, including:

  • Microsoft Office applications such as Excel.
  • Scripting languages such as Python and third party charting / dashboarding tools.
  • Third party data analysis tools (Microsoft PowerBI, etc).
  • Client-developed tools and models.

Database clients need not be hosted on Microsoft platforms; data access from other platforms such as Linux is also possible.

The FDM Data Repository is used to contain the data itself, along with its metadata, and also to provide powerful interfaces to create, maintain and query that data.

FDM supports a number of off-the-shelf data provider interfaces. In addition to these, new interfaces are constantly being added, including customised interfaces if required. Customers are also able to develop their own interfaces using the published database API, whether via a published API, through “scraping” or other methods.

Curve Builder allows formulae to be defined that calculate a set of values based on other curves. The formulae can then be attached to Proprietary Curves, such that their values are calculated from the formula automatically when any of the underlying data changes; “Derived Curves”.

Curve Validation enables various validation rules (or groups of rules) at a curve level to be checked at appropriate times. If any of the rules are breached the end user or system is made aware using an appropriate notification protocol.

The Administrator Web Application provides functionality to view the status of the system, to; view, import and edit curve metadata, and other administrative functions.

The Timebase Manager element of FDM extends the core functionality to allow loaded data curves to be converted and retrieved not just in their original time base and in UTC, but also in a user-selected time base and time zone.

The Eikon App allows any curve data that is stored in the data repository to be displayed in a chart in Refinitiv’s Eikon software. This includes data taken from Refinitiv and non-Refinitiv sources, including customers’ own Proprietary Data and Derived Curves.

The Data Repository is supported by  SQL Server (Express, Standard or Enterprise) with clients accessing the system using Excel 2010 (or later) and Web based calls, via any standards-based browser such as Chrome.

The REST API allows data to be queried from the Data Repository using standardised HTTPS GET and POST calls. The REST API is always secured over SSL, and permissions are granted via REST tokens.

REST responses are in JSON and can be readily used by languages including Python, Java, C# and R (amongst others).  Certain endpoints also support CSV return bodies, suitable for direct use by tools such as Excel, PowerBI and other visualisation and business intelligence tools.

The FDM Data Repository is used to contain the data itself, along with its metadata, and also to provide powerful interfaces to create, maintain and query that data.

FDM supports a number of off-the-shelf data provider interfaces. In addition to these, new interfaces are constantly being added, including customised interfaces if required. Customers are also able to develop their own interfaces using the published database API, whether via a published API, through “scraping” or other methods.

Curve Builder allows formulae to be defined that calculate a set of values based on other curves. The formulae can then be attached to Proprietary Curves, such that their values are calculated from the formula automatically when any of the underlying data changes; “Derived Curves”.

Curve Validation enables various validation rules (or groups of rules) at a curve level to be checked at appropriate times. If any of the rules are breached the end user or system is made aware using an appropriate notification protocol.

The Administrator Web Application provides functionality to view the status of the system, to; view, import and edit curve metadata, and other administrative functions.

The Timebase Manager element of FDM extends the core functionality to allow loaded data curves to be converted and retrieved not just in their original time base and in UTC, but also in a user-selected time base and time zone.

The Eikon App allows any curve data that is stored in the data repository to be displayed in a chart in Refinitiv’s Eikon software. This includes data taken from Refinitiv and non-Refinitiv sources, including customers’ own Proprietary Data and Derived Curves.

The Data Repository is supported by  SQL Server (Express, Standard or Enterprise) with clients accessing the system using Excel 2010 (or later) and Web based calls, via any standards-based browser such as Chrome.

The REST API allows data to be queried from the Data Repository using standardised HTTPS GET and POST calls. The REST API is always secured over SSL, and permissions are granted via REST tokens.

REST responses are in JSON and can be readily used by languages including Python, Java, C# and R (amongst others).  Certain endpoints also support CSV return bodies, suitable for direct use by tools such as Excel, PowerBI and other visualisation and business intelligence tools.

Support and Implementation

Project Management, Development, Testing & Implementation

We work with you to help integrate our software solutions across your business.

Training & Support

Our team is on hand to offer any training and support that you may require across all of our products.

We Understand Your Business

We work closely with our clients to determine the combination and extent of the service required for their particular business processes.

Hosted/Managed

We offer our solutions on a hosted and fully managed service basis, minimising the impact on existing IT infrastructure.

Support and Implementation

Project Management, Development, Testing & Implementation

We work with you to help integrate our software solutions across your business.

Training & Support

Our team is on hand to offer any training and support that you may require across all of our products.

We Understand Your Business

We work closely with our clients to determine the combination and extent of the service required for their particular business processes.

Hosted/Managed

We offer our solutions on a hosted and fully managed service basis, minimising the impact on existing IT infrastructure.

Project Management, Development, Testing & Implementation

We work with you to help integrate our software solutions across your business.

Training & Support

Our team is on hand to offer any training and support that you may require across all of our products.

We Understand Your Business

We work closely with our clients to determine the combination and extent of the service required for their particular business processes.

Hosted/Managed

We offer our solutions on a hosted and fully managed service basis, minimising the impact on existing IT infrastructure.

Current Jobs

Click this link to see a full listing of jobs currently available at lilac energy.

Contact Us

INFO@LILACENERGY.COM

+44 (0)131 248 3009

4 REDHEUGHS RIGG, WESTPOINT, SOUTH GYLE, EDINBURGH, EH12 9DQ, UNITED KINGDOM

INFO@LILACENERGY.COM

+44 (0)131 248 3009

4 REDHEUGHS RIGG, WESTPOINT, SOUTH GYLE, EDINBURGH, EH12 9DQ, UNITED KINGDOM

Copyright © 2023 Lilac Energy Software Solutions Ltd