Portfolio Optimization with Matlab and VBA. cell2mat doesn't work -

-

i trying write macro in vba execute matlab. when opened, matlab uses data stored in excel sheet macro recorded. in vba code recall matlab function , use cell2mat convert data excel matlab. make life easier post code:

public sub usa() dim matlab object set matlab = createobject("matlab.desktop.application") matlab.execute ("cd('c:\users\dales\dropbox\esempi')") serie = sheets("sp500").range("b3:ru686") grupposector = sheets("gruppot").range("b3:ru21") gruppomin = sheets("gruppo").range("z11:z29") gruppomax = sheets("gruppo").range("aa11:aa29") ris = matlab.putworkspacedata("prices", "base", serie) ris = matlab.putworkspacedata("grupposector", "base", grupposector) ris = matlab.putworkspacedata("gruppomin", "base", gruppomin) ris = matlab.putworkspacedata("gruppomax", "base", gruppomax) myresult = matlab.execute("[portrisk, portreturn, portwts] = obama( cell2mat(prices, cell2mat(grupposector), cell2mat(gruppomin), cell2mat(gruppomax));")  ris = matlab.getworkspacedata("portrisk", "base", portrisk) ris = matlab.getworkspacedata("portreturn", "base", portreturn) ris = matlab.getworkspacedata("portwts", "base", portwts)  sheets("spottimizzazione").range("a3:a18") = portrisk sheets("spottimizzazione").range("b3:b18") = portreturn sheets("spottimizzazione").range("e3:rx18") = portwts end sub

now when matlab opened macro, doesn't convert inputs in double format, stored strings.

where wrong?

your problem that, said, data imported strings. calling cell2mat directly not work, because keep data stored char.

what need do, in order solve problem, convert every cell in cell array doubles before transforming cell matrix.

this can achieved calling :

 myresult = matlab.execute("[portrisk, portreturn, portwts] = obama(...  cell2mat(cellfun(@str2double,prices,'uniformoutput',false)),...   cell2mat(cellfun(@str2double,grupposector,'uniformoutput',false)),...   cell2mat(cellfun(@str2double,gruppomin,'uniformoutput',false)),...   cell2mat(cellfun(@str2double,gruppomax,'uniformoutput',false)));")

this work, of course, if obama function needs double matrices inputs.


Comments

Post a Comment

Popular posts from this blog

html - Difficulties with background-image property -

-
i working bootstrap , change .jumbotron background image instead of default color. tried using "background-image: url("img/ponder.jpg");" , it's not working reason. have tried using , without quotation marks, , i've tried placing image in root folder.. still no luck. here picture of file structure (root folder): https://i.gyazo.com/1cf9dcfd20224c4fce8fe4a775863ab1.png and here code: html: <div class="jumbotron"> <div class="container text-center"> <h1>hello world</h1> <p>lorem ipsum dolor sit amet, consectetur adipiscing elit. integer @ pharetra eros, vel condimentum nunc. vivamus eget bibendum mauris. integer quis volutpat enim. duis id lorem feugiat, mattis sapien eget, luctus eros. pellentesque vestibulum tempus elit, sit amet luctus purus dictum vitae. suspendisse non aliquam augue. morbi sagittis mi @ turpis luctus pretium. vestibulum sit amet orci orci.</p> ...
Read more

visual studio code - What does the isShellCommand property actually do and how should you use it? -

-
what isshellcommand property , how should use it? the description when hovering says: "specifies whether command shell command or external programm. defaults false if omitted" and in https://code.visualstudio.com/docs/editor/tasks mention in example with: "we want run gulp command in shell (vs code directly executing it) used isshellcommand" so difference between shell command vs external program? does running isshellcommand = false mean vscode not "directly executing it" meaning run "command" , don´t listen output (because ran external command?) in turn means cannot use problem matchers. or if setting isshellcommand = true mean vscode "directly executing it" , keep track of , listen output generated can use problem matchers etc integrate vscode? considering example below using tsc compile typescript project: c:\users\j\code\vscode-project>where tsc c:\program files (x86)\microsoft sdks\typescript\1.4\tsc.exe ...
Read more

ios - Segue not passing data between ViewControllers -

-
Image
i making ios app uses payment methods. at moment trying work on checkout flow, contains oderformviewcontroller , checkouttableviewcontroller can see below: i connected both dragging segue, highlighted in blue. added segue identifier segue. i called first view controller e_orderformviewcontroller (its title shipping address), , in created ibaction for continue button , used -(void)prepareforsegue:(uistoryboardsegue *)segue sender:(id)sender pass in information. i have order model, properties in it. on checkouttableviewcontroller, have got labels , orderinfo public properties, first view controller 1 can access it. #import <foundation/foundation.h> @interface order : nsobject @property(strong, nonatomic) nsstring *shippingname; @property (strong, nonatomic) nsstring *shippingaddress; @property (strong, nonatomic) nsstring *shippingcity; @property(strong, nonatomic) nsstring *shippingstate; @property(strong, nonatomic) nsstring *shippingzip; @end //e_orderform...
Read more