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 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 the expiry of the contract.

This makes the following possible:

• 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 opportune relations between the Data Reference of the elementary instruments of which they are composed. A wide number of fields, which can be easily customized by the user, allows the immediate grouping of the portfolio according to the desired classes.

Market Data

A database of market data allows the archiving, also automatically, of information relating to prices, dealing volumes, FX rates, interest rates and market indices. Such information can be used for:

• the mark to market evaluation of portfolios with immediate evidence of the P/L impacts on each open holding 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. This process of fair pricing holds particular importance for unlisted instruments.

Portfolios and Companies

Portfolios can be replicated automatically in order to allow the subjects involved in the different phases of the investment process to carry out their diverse operative tasks.

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

Transactions Data Quality

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

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 instruments and to support the organizational units of the Customer involved in the processes of investments’ 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 derivative financial instruments
• liquidity position of portfolios by calculating the monetary impact of each transaction on balances of investment current accounts at any date
• representation of collateral positions lent and received against 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.