Eikon Excel COM Not Streaming Price Updates Properly

Hello,

Eikon Excel COM Addin is not updating prices in real time as it should be. Not all prices are updated on time. Sometimes, I have to manually click on "Refresh All Workbooks" to get the latest prices data. Shouldn't Eikon be streaming price updates to Excel automatically without human intervention?

Thank you!

Find more posts tagged with

eikon

pricing

eikon-com-api

streaming-prices

Accepted answers

jason.ramchandani01

@sinan_islam just to get some more details about the behaviour? Are you running 32bit excel? Are you using the COM APIs with VBA (ie AdxRT.dll) or with .NET? Is the sheet set to automatic calculation or manual calculation?

Also can you try to see if streaming is working in the sheet using an Eikon worksheet function such as an RTGet or RData?

On a more general note these are quite old APIs now and we have much newer easier to use APIs that you could look at here. In terms of realtime they provide a streaming websocket connection and an ease of use library in python and also in .NET (currently in alpha release) - you are able to use the streaming part with an Eikon App Key - generated from the APPKEY generator. You can see a realtime sample here. In fact if you use a product like xlwings you can easily remove the reliance on VBA (if thats what you are using) entirely and have a much more modern and robust workflow. Please see our recorded webinar here.

All comments

jason.ramchandani01

Also can you try to see if streaming is working in the sheet using an Eikon worksheet function such as an RTGet or RData?

sinan_islam

@jason.ramchandani thanks alot for your highly informative reply. I have to agree that exporting data from Eikon Excel COM to another external application is inefficient.

I dont use Excel neither VBA. I have developed my trading systems in Python and I wish to feed it with real time data. I am interested in your new Eikon Data API (Python). But if I am not mistaken, to use the API, I have to purchase the whole Refinitiv Data Platform for $1,100 a month.

I am a day trader who uses trading systems. The tools of Refinitiv Data Platform are intended for the use of fundamental traders, like Warren Buffet. So I will pay for a platform that I will never use. That's why I am stuck with your old excel COM. All what I need is the data feed. Only two companies provide data for the market I trade, Refinitiv and eSignal (and perhaps Bloomberg).

I am currently accessing Eikon through MetaStock subscription. So the generated APPKEY wont work with Eikon Data API.

Now back to your questions. I am using COM API with VBA macros, not .NET. The sheet is set to Automatic Calculation. The function I am using is @RHistory.

EXPLORE OUR SITES