Research

The financial framework to turn ideas into strategies

Financial Query Language (FQL)

Our Financial Query Language (FQL) allows analysts to write financial ideas in a concise way which stays close to the analysts’ trend of thought.

The language is designed to be simple so that users without a programming background can easily get started. For instance, calculating a price to earnings ratio at any point in time should not be more complicated than writing price/earnings.

Screen Captures

Financial objects

Three kinds of objects constitute the building blocks of an investment process. These objects can either be imported from external providers or calculated on the fly.

Data objects contain any time-varying quantities (for instance a price would be stored in such an object).

Portfolio objects allow crafting portfolios or investment universes (for instance managed portfolios or benchmarks would be created or stored in such an object).

Riskmodel objects store external provider’s risk models but also allow you to easily create risk models that are bespoke to your investment process.

FQL is used all across these objects and, in turn, any object can be called from a FQL formula.

Screen Capture

Permissions and Audit Trail

Users can decide what to share, either to individual users or to groups.

Administrators can establish Chinese walls between teams.

When an object is saved, its previous versions are kept so that the audit trail on a model is always available.

Screen Capture

Calculation engine

Our calculation engine is integrated in the same backend as the Qube database for fast data access and fast calculations for universes that can contain millions of instruments.

It provides integrated caching of calculation results (different cache zones can be defined to favor persistence of long calculations) and automatic invalidation of relevant cache zones when models get changed by users.

Advantages

No need to store intermediate results that often cause errors as the cache automatically does it.

FQL formulas are ready for backtesting and implementation, no translation risk and cost.

Develop models to capture market behavior and relevant risk models.

Only the code relevant to the financial idea is left thus facilitating auditability

Any data formula thus defined can be called from APIs or User Interfaces

Permissioning system with small granularity

Audit trail of formulas readily available