Row index exceeds table dimensions.

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

[Benjamin Kraus]

I don't see any issues with your code, but it would help if you identified which line of code is throwing the error. If you paste this code into an M-file in the editor, then run the M-file, it should tell you which line of code is throwing the error, which should help you identify the bug.

[olayinka ola]

Ahh apologies I know which line is throwing up the error. It is this one:

adjcls(idx, 3)=adjcls3{idx3, end};

[Peter Perkins]

Presumably it is the right-hand side that is causing the issue. The problem is not the SIZE of idx3, but the indices that it contains. idx3 contains indices into tday3, while adjcls3 has height equal to tday, which is the union of ...

You are going to need to step though your code and figure out why adjcls3 is the wrong height for the row indices you're using. Likely you are not realizing that union "returns the combined values of the two vectors with no repetitions", and you have repeated days.

[olayinka ola]

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};

Answer 1

[Athul Prakash]

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!