Announcement

Collapse
No announcement yet.

Excel DDE VBA

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel DDE VBA

    I have installed the eSignal Data Manager and QLink 4.0. I run Vista, but have set the Compatability mode for these 2 programs to XP. I want to programmically pull data for a custom program. I'm starting with Excel VBA but will move to C# once the connection bugs are worked out.

    Here is the Code:
    Sub Main()
    ChannelNumber = Application.DDEInitiate("QLink", "Bars")
    returnlist = Application.DDERequestChannelNumber, "MR08H,30,100,DTOHLCV")
    End Sub

    The returnList is an Array of data. I get the Date & Time, but the Open, High, Low, Close, Volume all return 0 for each row (100 rows in this example).

    Sometimes I get an Error 2023. What is the best way to retrieve data for a custom program. Qlink might not be the best answer.

    Thanks.
Working...
X