 |
Mathematica Link for Excel lets you easily process financial data and perform sophisticated analyses by using custom functions written in Mathematica. You can also use Mathematica-based macros to automatically calculate and visualize your data in Excel.
Here, Mathematica calculates an optimal portfolio composition, visualizes the efficient frontier, and displays the historical stock prices for the stocks selected. A Mathematica-based macro is stored in the Excel workbook, inside an Initialization code box. One click of the Mathematica Evaluate button runs the code and updates all Mathematica calculations.
|
|
For the newest resources, visit Wolfram Repositories and Archives »
