It is my understanding that you have created 2 tables with 20% percentile value for each year and stock-market capitalizations for each year respectively and you intend to create a new table that reads these both tables and extract 20% of the smallest stocks for each year.
To achieve this after importing both tables (MCTable and PRCtbl02) into your workspace, you can iterate over all rows of the table (MCTable) with market capitalizations and pick each suitable row with value < 20% percentile for that respective year, and keep on appending it to an output table (newly created table initially). The following code illustrates how to achieve the above:
%Create an empty table
t=table;
%Iterate over all rows in the table
for i=1:size(MCtable,1)
%year represents each for respective value
year=MCtable.years(i);
%this if condition is the necessary condition for value <20% value
if(MCtable.SumMC(i)<PRCtbl02.Var2(year-1962+1))
%appending value to table
t=[t;MCtable(i,:)];
end
end
Hope this helps.
