PortOpt

Using Excel Builder and VBA to create a custom application for Microsoft Excel.

Description

A simple example that illustrates how to use Excel Builder and Visual Basic for Applications (VBA) to create a custom GUI-based application that plugs right into Microsoft Excel.

This submission contains all the files associated with the October issue of News and Notes article related to Deploying MATLAB Applications for Excel.

For more information, see this News and Notes article:
http://www.mathworks.com/company/newsletter/oct02/matlabxl.shtml

• Required Products: MATLAB Compiler; MATLAB Builder EX
• MATLAB release: MATLAB 6.5 (R13)

Other Files

install.bat,
bin/FigureMenuBar.fig,
bin/FigureToolBar.fig,
bin/win32/mclxlmain.dll,
bin/win32/mwcomutil.dll,
mwregsvr.exe,
MyPortfolio.xls,
portfolio_1_0.dll,
PortOpt.xla,
PortOpt.xls,
PortOpt.doc

[Ronin Samurai]

Nice demonstration of Matlab's capability though I wish the zip contained the .m files as well.

[rolo ferguson]

No M file please put the M File

[Fabio Fornasari]

I'm searching all(not illegal)patterns and softwares which make me able to work in implants telemonitoring and teleregulations;particularly for water-gas networks.
this SW useful seems useful for me

[Blake Schaz]

It was difficult to see how VB was used with MATLAB to create the application. Including the .m file would definately help.

[li zeze]

I compute efficient frontier by command portopt with matlab2007b, find an error:
ExpReturn = [0.1 0.2 0.15];

ExpCovariance = [0.005 -0.010 0.004
                -0.010 0.040 -0.002
                 0.004 -0.002 0.023];
 
NumPorts = 20;
portopt(ExpReturn, ExpCovariance, NumPorts)

??? Error using ==> linprog
Too many input arguments.

Error in ==> portopt at 189
[MaxReturnWeights, Fval, ErrorFlag] = linprog(-ExpReturn, Aineq, Bineq, Aeq, Beq, LB, UB, W0, options);
why?

[Dimitri Shvorob]

Considerable and serious effort, but is this really going to aid someone learning Excel Builder? I would not recommend it.