...k. I was reading on line that that only refreshes TR equations, I was wondering what a refresh code for RHistory functions would be? If Application.Run "EikonRefreshWorkbook" works for RHistory just let me know. Call Sheet4.SpinButton1_SpinDown DoEvents Application.Run "EikonRefreshWorkbook" DoEvents Application.Run…
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!
Hi, I am using Eikon API on Python and i am doing a request for some boat location. My problem is that I am receiving data on a too small aggregation. For instance, i would like to have only one observation per week. Can you help me with that ? Below an example of my request: trial45 = ek.get_data("C}KL7309431343"…
Hello, I am trying to read price data from Eikon Excel to Python Pandas DataFrame during real time updates. The issue is that Eikon Excel does not save streaming data in real time, while Python can only read saved excel files. I tried to use an Excel macro to automatically save the file during real time updates, but…
File "Demand Forecast EU.xlsm" is customized version of "Power Gas Carbon Agriculture Research and Forecasts" where additional button is added to run VBA. About 2 weeks ago, the sheet-tabs started to not update when clicking on Refresh All Files. Thought the file was corrupted so created new file but it is the same issue…
Today we saw a peculiar message in a FID on a set of RICs. The message was "<Servvice name> Lost Conn". Wondering what could have contributed this to the RIC? Is this is a typical message that RtGet returns when the connection to the ATS service temporarily drops?
I use dex2 manager in COM API to request ISIN and SEDOL fields: Sample code: HRESULT l_hr = m_RData->put_InstrumentIDList(CComVariant(a_InstrumentIDList)); if (l_hr == S_OK) { l_hr = m_RData->put_FieldList(CComVariant(a_FieldList)); if (l_hr == S_OK) { l_hr = m_RData->put_RequestParam(CComVariant(a_RequestParam)); if (l_hr…
When I tried to get historic BID/ASK ticks of NQc1 and NQU0, strangely I got the following result: * with start 8:21 and end 14:52, none is returned. * with start 8:20 and end 08:21, 2491 ticks were returned. * with start 14:52 and end 14:53, 14441 ticks were returned. Here are the codes and screen capture for your…
Hello, After Eikon upgraded itself call CreateAdxRtList throws an exception. This happens only in Visual Studio in both debug and release mode. l_hr = m_EikonDesktopDataAPI->CreateAdxRtList((IUnknown**)&m_RtMgr); Exception thrown at 0x767D4192 in DataCollector.exe: Microsoft C++ exception: pixl::trep::core::Exception at…
How to get SIC code from ISIN codes in Eikon Excel?
It looks like you're new here. Sign in or register to get started.