Control any RIO model from Excel
The RIO Function Library for Excel is a user-friendly Excel add-in covering every model in the RIO system. Using the library you may set up customized sheets for yield curve estimation, prepayment analysis, analysis of OTC derivatives and risk management directly in your favorite spread sheet environment. Data from the RIO database may be combined with proprietary data and real time input.
Interactive wizard
The unique RIO function wizard let you select any combination of input and output fields. The wizard integrates field selection, data base lookup and on-line. The RIO model is represented as a single Excel table function call which is pasted to the spreadsheet and automatically resized according to the number and dimension of input parameters.
Database integration
The RIO Function Library represent an interfaces the RIO database. Using a few key identifiers like calculation date, ISIN code or Yield Curve ID the function retrives the necessary information from the database. However, for sensitivity analysis you may override any parameter in the RIO database directly from Excel. This allows you to perform any type of sensitivity analysis with no change to the underlying database.
Multi CPU Server
The RIO function library supports the multi-cpu RIO calculation server. The server may be placed in-house or remotely accessed through the internet..
Large calculations are split into smaller packages, which are processed in parallel on the server.
RIO data functions
The RIO Function Library turns user defined data queries into Microsoft Excel functions which may be controlled through the RIO function wizard. This allows for centralized maintenance of complex data base queries and access parameters, while the data is made available enterprise-wide like a build-in Excel function.