Results 1 to 5 of 5

Thread: Need a help with loading data using class module (Derivative & Portfolio)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    VBAX Regular
    Joined
    Sep 2017
    Posts
    16
    Location
    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •