Untitled

=makearray(counta(A2:A),counta(B1:1),lambda(r,c,let(row,index(A2:A,r),col,index(B1:1,c),
          if(col="CMP",googlefinance(row),ifna(index(googlefinance(row,"price",col),2,2))))))