Excel Integration

Build powerful sheet-based solutions with real-time results streaming into Excel, the end-user tool of choice on the trading floor.

Excel integration

Full Integration with Microsoft® Excel

The entire power of the OpenGamma Platform in the hands of traders and risk managers - without leaving 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 center, rather than on the desktop.
  • All data objects and calculations are available via cell variables/functions or via VBA: allowing Excel power users to create custom solutions without the problems of emailing around 100MB Excel files with untraceable, uncontrolled VBA running core calculations.
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, allowing 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 in Excel.
  • View complicated structures (discount curves, VaR time series) in Excel.
  • Easily access the full range of the OpenGamma Platform’s stress testing and scenario analysis capabilities.