Client like to use the command code "RtGet("IDN","LCOc1","LAST") in Excel VBA. Is that possible please?
@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.
I hope this can help. Let us know how you get on.