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

Dave_L · 2025-02-18T10:10:13+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

eikon-com-api

#technology

#product

Accepted answers

All comments

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

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

@Dave_L

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

EXPLORE OUR SITES