Thanks for simplifying it for me!
I was able to load the table for each instruments as below, except the Portfolio table.
Capture3.jpg
Dim i As Integer, j As Integer
Dim Mat As Variant
Mat = newPort.GetData("Cash")
'load output range with matrix from Getdata() Function
For i = 1 To 10
For j = 1 To 3
Range("Output_Cash").Cells(i, j) = Mat(i, j)
Next j
Next i
Regarding the table for Portfolio, could you please provide me with your advice?
Any suggestions most welcome, I'm open to any approach.
Regards,
Demian