Microsoft® Excel Integration
Build powerful sheet-based solutions with real-time results streaming into Excel, the end-user tool of choice on the trading floor.
Full Integration with Microsoft® Excel
- The entire power of the OpenGamma Platform in the hands of traders and risk managers, without their feeling like they have left the familiar Excel environment.
- Switch easily between the Excel and web user interfaces for advanced functionality and data/result sharing that would otherwise require emailing large XLS files between users.
- Keep complicated calculations where they belong: on the server and in your data centre, rather than on the desktop.
Seamless Access to the Full Range of OpenGamma Analytics
- Load portfolios, specify hypothetical positions, or combine the two into a worksheet-specific portfolio.
- View live ticking analytics computed in a shared View Processor, or specify bespoke calculations to be computed on an on-demand or live basis.
- Easily push portfolios and calculation configurations to the shared infrastructure, to allow traders and risk managers to collaborate on portfolio construction and risk management.
- Every component in a calculation (discount curve definitions, market data, function parameters) can be viewed or overridden from Excel.
- View complicated structures (discount curves and volatility surfaces, Jacobian matrices, VaR time series) in Excel.