Can you please help in creating VBA code for the below:

Norland
Norland LSEG
edited May 21 in Eikon Data APIs

What I need is VBA code to:

  • Check whether Workspace COM add in is loaded, and load it if not
  • Check Workspace status (online, offline, refreshing, paused) and trigger log in and refreshes
  • Retrieve FX spot live, today’s high, today’s low as well as fixrates (WMRH etc) and the corresponding timestamps
    EIKON VBA code.txt
Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Norland

    Thank you for reaching out to us.

    Typically, this forum doesn't provide the coding service. Please check with the Workspace Excel Add-ins product team to find out which macros are available for use in VBA.

    Moreover, you can refer to the answer on this discussion.

Categories