Excel VBA

PaulaNavarroLSEG
edited May 13 in Eikon COM

Client like to use the command code "RtGet("IDN","LCOc1","LAST") in Excel VBA. Is that possible please?

Answers

  • @PaulaNavarroLSEG Thanks for your question - yes you have 2 options here. The latest version of Workspace (1.26) allows RtGet functions to be run in VBA - as follows:

    myVal = Application.Run("RtGet", "IDN", "LCOc1", "LAST")
    

    Only single instrument value can be returned.

    We also have a new library called LSEG COM Library for Workspace which is designed to operate natively in VBA - this has a number of functions that can be used to replicate RtGet functionality - even better with support for multiple RICs and Fields. Full details and examples are available on the page above.

    image.png

    I hope this can help. Let us know how you get on.