Sofia core 

All information in Sofia is calculated in real time, based on parameters defined by the user and keeping account of each new transaction that is introduced or each successive piece of information.
For example, the execution of an order results in an automatic and immediate update in the portfolio holding and the treasury situation. On one side, this approach ensures that the most up-to-date situation is made available to all users in a timely manner while on the other it limits the need to resort to costly processing cycles.

Sofia’s Tool Box is made up of a set of common tools to visualize, interrogate and analyse the data which provides:

• query functions for visualizing portfolios or single holdings referable to any date range, past or future, with the immediate recalculation of initial and final asset holding and financial and economic flows of the period
• macro functions that allow to memorize sequences of user commands executed in a recurrent way and to recall these same commands when necessary
• data export user functions in multiple format (Excel, Access, CSV, SQL)
• screens that can be personalized and saved by each user
• selection, sorting, classification and sum functions

With Sofia it is possible to manage all information supporting the investment process of management and control of investments.

Data Reference of the Financial Instruments

Sofia allows the registration of the contractual elements of each financial instrument in a portfolio, including also the creation of all events (and cash flows) until maturity.

This allows:

• a provisional analysis on P/L and treasury impacts
• the calculation of the theoretical price of the instrument based on market conditions and Sofia fair pricing models

Complex financial instruments can be managed in a unitary way by means of proper links between the Data References of the underlying basic instruments they are composed. A wide number of fields, which can be easily customized by the user, allows the grouping of the portfolios data according to the decided criteria.

Market Data

A database of market data allows the storage and update, also automatically, of information related to prices, dealing volumes, FX rates, interest rates and market indixes. Such information can be used for:

• the mark to market evaluation of portfolios with immediate evidence of the P/L impacts on  open position according to the evaluation rules outlined
• the calculation of yield and risk measures for entire portfolios or parts of them

Thanks to its wide range of tools for the calculation of the fair price, Sofia offers the possibility to evaluate ad hoc portfolios and financial instruments. The fair pricing process has a relevant importance for unlisted instruments.

Portfolios and Companies

Portfolios transaction can be replicated automatically to allow the teams involved in the different phases of the investment process to carry out their specific tasks.

This replica also allows the application - to the same portfolio - of different evaluation and accounting rules.

Transactions update

Transactions in Sofia can be created automatically through Order routing interfaces, inserted by using import functions or automatically generated by the system.

Data Quality

Data quality control tools are available in Sofia to optimise the processes aimed at ensuring the quality of the information recorded in Sofia in terms of adequacy, completeness and accuracy.

With Sofia it is possible to manage a wide range of financial assets to support the Customer in the investment decision, evaluation, administration and control of:

• all types of bonds, shares, Investment Funds, OICR, ETF, Alternative Investment Funds, Money Market instruments
• both OTC and listed derivatives
• liquidity position of portfolios by calculating the monetary impact of each transaction on cash accounts at any date
• representation of collateral positions delivered and received in relation to securities lending, OTC and listed derivatives transactions

In Sofia, it is possible to carry out extensive profiling that allows the authorisations of different users to be segregated at the desired level of detail.
Concerning the audit trail, Sofia allows the reconstruction of all the tasks completed by the user on all the main archives (orders, transactions, data reference, etc.).

In order to guarantee the maximum standards of efficiency and to minimize the risk of error, the Scheduler allows the automatic execution of macros with a desired frequency at predefined times, eliminating the need of user involvement.