Mathematica 9 is now available

Wolfram Library Archive


All Collections Articles Books Conference Proceedings
Courseware Demos MathSource Technical Notes
Title Downloads

Mathematica Link for Excel Example: Finance--Mathematica-Based Macros
Author

Anton Rowe
Organization: Episoft, Inc.
Description

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.
Subject

*Mathematica Technology > Application Packages > Wolfram Research Applications > Mathematica Link for Excel
Related items

*Mathematica Link for Excel   [in Technical Notes]
*Mathematica Link for Excel Example: Engineering   [in Technical Notes]
*Mathematica Link for Excel Example: Finance--Custom Mathematica Functions   [in Technical Notes]
*Mathematica Link for Excel Example: Industry   [in Technical Notes]
*Mathematica Link for Excel Example: Management   [in Technical Notes]
URL

http://www.wolfram.com/applications/excel_link/examples/finance.html
Downloads

Download
Portfolio.xls (306.5 KB) - Microsoft Excel document