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?
@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.