Products

A2A Develops Comprehensive Risk Management Solution for Energy Markets

“When you deal with numbers all day and work with sophisticated analytical models, having an integrated environment is invaluable. With MATLAB we visualize data, conduct back-testing, and plot graphs to see the results of changes we make, all in one environment, and that saves time.” —Simone Visonà, A2A

Intuitive Analytics Uses MATLAB to Build Quantitative Tools to Help Bond Issuers Manage Risk

"Because MATLAB enables us to build and distribute applications to analysts that are accessible from Excel, we are quickly bringing to market products that are adopted and deployed by investment banks." - Peter Orr, Intuitive Analytics

Spreadsheet Link EX (for Microsoft Excel)

Description

Introduction

Spreadsheet Link™ EX connects Excel® spreadsheet software with the MATLAB® workspace, enabling you to access the MATLAB environment from an Excel spreadsheet. With Spreadsheet Link EX software, you can exchange data between MATLAB and Excel, taking advantage of the familiar Excel interface while accessing the computational speed and visualization capabilities of MATLAB.

Spreadsheet Link EX is especially useful as an array editor for viewing and editing data interactively in any MATLAB application. Any data that you can import into Excel can be passed to MATLAB for analysis and visualization. The connection between MATLAB and Excel is "live" and requires no intermediate files or low-level, inter-process programming.

Key Features

  • Data preprocessing, editing, and viewing in the familiar Excel® environment
  • Sophisticated analysis of Excel data using MATLAB® and application toolboxes
  • Delivery of Excel based applications, using MATLAB as a computational and graphics engine and Excel as an interface
  • Interactive selection of available functions using the MATLAB Function Wizard
  • Visual interface for customization of all Spreadsheet Link™ EX preferences