Gradcracker - Where the STEM jobs are
My Gradcracker Dashboard Login
My Account Activity
Webinars
Upcoming webinars I have registered for
0 of 13
Alerts
Alerts from my Followed employers
0
Following
Employers I am Following
0
Shortlist
Opportunities in my shortlist
0

New to Gradcracker?

Register here

Degree Apprenticeships Placements / Internships Graduate Jobs
Company Hubs A-Z Sector A-Z
STEM Societies
Webinars Toolkit

What we do

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.

Data Repository  

Data Repository  

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.

Data Interfaces  

Data Interfaces  

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  

Curve Builder  

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  

Curve Validation  

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.

Administrator App  

Administrator App  

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

Timebase Manager  

Timebase Manager  

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.

Eikon App  

Eikon App  

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.

Solution Architecture  

Solution Architecture  

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.

Rest API  

Rest API  

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 & Implementation

Lilac provides the full range of services required to develop, implement and support the solutions we offer, to ensure products and projects are delivered on time and to budget.

Project management, development, testing & implementation

  • We work with our clients to help integrate our software solutions across their business.

Training & support

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

We understand business

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

Hosted/managed

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

More on our Hub

Follow your favourite employers
Save jobs to your shortlist
Receive personalised alerts
Access our live webinars
Register now
Gradcracker and Cookies
We use cookies to ensure that we give you the best experience on our website.
If you continue we'll assume that you are happy to receive all cookies from Gradcracker.
Continue
Learn more