Transition from Eikon excel add in to Refinitiv WorkSpace excel add in

Dave_L
Dave_L Newcomer
edited February 18 in Eikon COM

Hi,

I'm transition from using the Eikon Excel add-in to Refinitiv WorkSpace excel add-in, but unfortunately the real time retrieval from Reuters stopped working.

Function Reuters_IDN(Sec As String, Field As String)

Dim res As Variant
res = "Retrieving..."

While res = "Retrieving..."
res = Application.Run("RtGet", "IDN", Sec, Field, "")
DoEvents
Application.RTD.RefreshData
Wend

Reuters_IDN = res

End Function

Sec=RIC and Field=Price type CF_LAST, CF_CLOSE

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Dave_L

    Thank you for reaching out to us.

    The RtGet should be a part or the legacy Eikon COM which is not available in the LSEG Workspace.

    Please check the Migrating COM API calls to Python article. Then, you can use the Xlwings to generate Excel files. For more information, please refer to the following articles.

  • Dave_L
    Dave_L Newcomer

    Hi Dave,

    In order to call on the CreateAdxRtList(), what COM DLL would have to be installed? Is the DLL (Lib) included in the installation of Refinitiv WorkSpace? Please concretely specify the prerequisites in order to run the function below:

    Function Reuters_IDN(Sec As String, Field As String)

    'Dim res As Variant
    'res = "Retrieving..."
    '
    'While res = "Retrieving..."
    ' res = Application.Run("RtGet", "IDN", Sec, Field, "")
    ' DoEvents
    ' Application.RTD.RefreshData
    'Wend
    '
    'Reuters_IDN = res

    Dim strRICs As String ' Can have one or more items
    Dim varFIDs As Variant ' Field can be numeric as well as a string, e.g. BID is field 22

    ActiveCell.Select

    If Not myRtGet Is Nothing Then Set myRtGet = Nothing
    Set myRtGet = CreateAdxRtList()
    With myRtGet
    .ErrorMode = DialogBox
    .Source = [Source].Value

    strRICs = [RIC].Value
    varFIDs = [FID].Value

    .RegisterItems strRICs, varFIDs

    .StartUpdates RT_MODE_IMAGE ' 4

    End With ' For the With myRtGet

    End Function

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Dave_L

    The CreateAdxRtList method is a part of COM APIs for use in Microsoft Office which is not available in the LSEG Workspace.