It is common for investment companies to do this process manually, pulling data from multiple sources in different formats. A single daily portfolio report could show the position weights from the latest valuations generated by a SQL query; the return of those instruments for the day from your market data provider; and the largest client flows from a flat csv file.
If the reports are made in Excel, maintaining the workbooks/sheets, changing ranges as data sets expand or contract, and maintaining custom views of the data can be frustrating. The pressure on teams producing these reports is immense; the process is tedious; their time to deal with other critical operational issues is greatly reduced; and the speed and mechanisms for producing reports make mistakes inevitable.
There are better ways of doing it.
You may have a technical team that handles all the data requests and integrates the various sources needed for the reports. However, these requests are intellectually complex, needing intelligent and costly people to implement.
A lot of their expensive time will be spent manually repeating the same requests, which makes this a costly solution that does not reduce the chance of human error.
Quintessence ingests all your data sources or virtualises the data from other databases or APIs so that you can access it all through a single portal. Integrating and updating your data sources is no longer required and you have everything you need to construct your reports in one place.
“Yes, but what about the analysts’ research in the Excel files?” you might wonder. With Quintessence that data is there too. In fact, all your financial and investment data and your business logic can be accessed in one place, including all your live market data.
Using Quintessence, you can define and store functions and business logic that can be used in any report. Once you have defined these, you have the building blocks you need to construct most reports. Customising new reports only requires tweaking your data views and adjusting formatting.
Since all reports are built on the same data source, they will always reconcile, and multiple reports can be produced with varied parameters and views. There is also no need to store a history of each report, as it can be generated again at any time.
With Quintessence you can tailor views easily. One fund manager may want to see their listed positions and any derivatives they have with the same underlying, combined into a single line item, while another may want to see these separately. This can be easily managed by storing the logic and data of both views and selecting the appropriate one for your end user.
You can distribute your saved reports through Quintessence via email, SFTP, API or flat files dropped in the desired location on a scheduled or ad hoc basis.