OData - THE NATIVE EXCEL INTERFACE TO PATRONAS OPUS
Updated: Jul 20
Open Data Protocol - the best way to REST
Until now, with PATRONAS OPUS you could already quickly and easily receive displayed data (e. g. portfolio, order book, master data) directly via Generic Export as an Excel file for further processing. PATRONAS has set itself the goal of providing you with even more support for regular data queries. We asked ourselves how to map this with a modern technology framework in a most reasonable way.
The tried and tested PATRONAS OPUS already enables this task very well via our REST API. Therefore we worked on making the strength of the system - a modern and flexible API framework - available to users who do not develop themselves.
The Open Data Protocol (OData) is an http-based protocol for data exchange between compatible software systems, in our case between MS Excel and PATRONAS OPUS. OData works on the basis of entities, i. e. defined, typified classes with properties.
This means that OData can also be used by end users who want to directly use relevant entities for an evaluation. You can therefore easily create queries optimised for your use case in OData. To do this, it is sufficient to use an Excel version more recent than Excel 2016 and to have created a user specifically for the use of OData.
With this technology, you can easily access the data of our integrated portfolio, risk, compliance and order management solution PATRONAS OPUS from MS Excel and thus create the basis for regular reports.
Good to know: OData is documented in the PATRONAS OPUS HelpCenter, and we also offer training on this topic upon request.
Please contact us at email@example.com for enquiries about training or if you need direct support in creating OData use cases.
Examples of current application scenarios of our customers:
Portfolio enquiries, asset allocation evaluations based on them
Passing on data to external parties, e. g. fund databases
Checking stored data, e. g. comparison with data supplier
Reconciliation of model portfolios with pre-trade portfolio, especially for complex ESG mandates
Evaluations within the scope of authorisation management, e. g. overview of assigned user authorisations
Example: result of master data query
Example: portfolio query