Rank: 12363 based on 0 downloads (last 30 days) and 0 file submitted
photo

Steven

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Comments and Ratings by Steven View all
Updated File Comments Rating
16 Mar 2012 Portfolio Optimizer Tool Portfolio Optimizer Tool Author: Patric Schenk

Hi,
I've now managed to open the tool but when I try to import data from excel I get the following error. Can someone help me please? Is it important how the dates are defined in Excel?

Error using datestr (line 179)
Cannot convert input into specified date string.
DATENUM failed.

Error in portfoliotool>updateImportDataPage (line 2095)
datesstr = cellstr(datestr(dates,handles.datestringformat));

Error in portfoliotool>button_dataimport_excelfile_import_Callback (line 2293)
updateImportDataPage(handles,prices,[],dates,priceslabels,[]);

Error in gui_mainfcn (line 96)
feval(varargin{:});

Error in portfoliotool (line 25)
gui_mainfcn(gui_State, varargin{:});

Error in
@(hObject,eventdata)portfoliotool('button_dataimport_excelfile_import_Callback',hObject,eventdata,guidata(hObject))


Error while evaluating uicontrol Callback

thanks

16 Mar 2012 Portfolio Optimizer Tool Portfolio Optimizer Tool Author: Patric Schenk

Hi,
I'm still unable to open the portfoliotool.m
What is the exact code to do this? And where should the file be saved?
I don't have the optimization toolbox. Is that a problem?
thanks
Steven

Contact us