Index exceeds matrix dimensions Error
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Ji Li
le 18 Sep 2018
Commenté : Walter Roberson
le 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 commentaires
Réponse acceptée
Walter Roberson
le 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 commentaires
Walter Roberson
le 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.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Portfolio Optimization and Asset Allocation dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!