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

  • Contact Us
  • Bookmark and Share

Spreadsheet Link EX (for Microsoft Excel)

Description

Managing the Link and Manipulating Your Data

With Spreadsheet Link EX, Microsoft Excel becomes an easy-to-use data-storage and application-development front end for MATLAB. You work with Spreadsheet Link EX functions from an Excel worksheet or macro without leaving the Excel environment. You can use the Excel interface to edit and view your data and then use Spreadsheet Link EX to pass data and commands to MATLAB. You can pass data stored in an Excel spreadsheet to the MATLAB workspace. Similarly, you can easily bring data from the MATLAB workspace into an Excel spreadsheet.

The MATLAB workspace includes all the variables created by MATLAB, Handle Graphics®, and related toolboxes. MATLAB functions can access and share the data in these variables, and you can call these same MATLAB functions from Excel formulas, macros, or Excel Visual Basic® subroutines or functions.

Because both MATLAB and Excel are extensible, you can develop and incorporate your own data analysis functions and techniques.

 

40505 wm excellink prefdialog w 16671

The Preferences dialog, which you can use to interactively configure your environment.

Previous