MATLAB Answers

Row index exceeds table dimensions.

10 views (last 30 days)
olayinka ola
olayinka ola on 16 Nov 2020
Commented: olayinka ola on 19 Nov 2020
In the attached image of my workspace for the below code I can see that adjcls3 is 1663x1 and idx3 is 1889x1 however I don't know how to fix the error I am receiving
"Row index exceeds table dimensions."
Question: How do I solve the row index exeeds table dimensions issue?
Here is the code:
R = readtable("Backtesting/OIH.xlsx");
tday1 = R{1:end, 1};
tday1.Format = 'yyyy-MMM-dd';
adjcls1=R(:,end);
T = readtable("Backtesting/RKH.xls");
tday2 = T{1:end, 1};
tday2.Format = 'yyyy-MMM-dd';
adjcls2=T(:,end);
H = readtable("Backtesting/RTH.xlsx");
tday3 = T{1:end, 1};
tday3.Format = 'yyyy-MMM-dd';
adjcls3=H(:,end);
tday=union(tday1, tday2);
tday=union(tday, tday3);
adjcls=NaN(length(tday), 3);
[foo idx1 idx]=intersect(tday1, tday);
adjcls(idx, 1)=adjcls1{idx1, 1}
[foo idx2 idx]=intersect(tday2, tday);
adjcls(idx, 2)=adjcls2{idx2, 1};
[foo idx3 idx]=intersect(tday3, tday);
adjcls(idx, 3)=adjcls3{idx3, end};
Workspace
  4 Comments
olayinka ola
olayinka ola on 19 Nov 2020
Stepping back through the code did it. Simple error from me on line 10:
tday3 = T{1:end, 1};
should have been. Works now
tday3 = H{1:end, 1};

Sign in to comment.

Answers (1)

Athul Prakash
Athul Prakash on 19 Nov 2020
If you could attach the input file, others users may actually run the code with that data and witness the exact error themselves.
However, since you're obtaining the indices from an intersect function (2nd last line), I suspect that somehow it returns more/less values than expected and this is causing your index error. You may inspect the values of 'idx' and 'idx1' by setting a breakpoint on the last line and double-clicking the variables as they appear in the variables section.
Hope it Helps!

Tags

Products


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!