Index exceeds matrix dimensions Error
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Ji Li
am 18 Sep. 2018
Kommentiert: Walter Roberson
am 19 Sep. 2018
I have a function which writes inputs from Excel. The function doesn't report any errors in Matlab, but when I converted it into an Excel add-in, it tells me "Index exceeds matrix dimensions". The error occurs at the "Horizon" line in the code. How can I find out what the problem really is?
Inputs InputsData = xlsread(inputFileName, 'Portfolio', 'U4:U15');
N = InputsData(1);
K = InputsData(2);
PERC = InputsData(3);
PERC_T = InputsData(4);
GLOB = InputsData(5);
COUT = InputsData(6);
SEC = InputsData(7);
FI = InputsData(8);
LIMIT = InputsData(9);
HORIZON = InputsData(10);
ALC = InputsData(11);
CUT = InputsData(12);
2 Kommentare
Akzeptierte Antwort
Walter Roberson
am 19 Sep. 2018
For whatever reason, U13, U14, and U15 are not present in the returned data. That could occur with that code if the values in those locations are all not numeric, as well as for the case where those values all just do not exist.
2 Kommentare
Walter Roberson
am 19 Sep. 2018
[~, ~, InputsRaw] = xlsread(inputFileName, 'Portfolio', 'U4:U15');
N = InputsData{1};
K = InputsData{2};
PERC = InputsData{3};
PERC_T = InputsData{4};
GLOB = InputsData{5};
COUT = InputsData{6};
SEC = InputsData{7};
FI = InputsData{8};
LIMIT = InputsData{9};
HORIZON = InputsData{10};
ALC = InputsData{11};
CUT = InputsData{12};
I do not know what datatype HORIZON, ALC, and CUT will come out as.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Portfolio Optimization and Asset Allocation finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!