-
How to download adjusted close prices?
Hi!, I'm currently working on a portfolio optimization assignment in R and need to download the historical data for 10 stocks, including the adjusted close price to calculate the returns. However, when I downloaded the historical Excel data from Refinitiv Eikon, I noticed that it had it didn't have any column for adjusted…
-
How to connect the R Script to the latest version of Eikon API?
Raising this on behalf of an external client. I would like to use this language to access the Eikon API and I see there is a Python package, but looking for an R package.
-
Replacement for Rhistory and Dex2 for migration from Eikon to Workspace
Hi, I am currently using RhistoryAPI.dll and Dex2.dll in my VBA code with Refinitiv Eikon. Apparently these APIs are under COM APIs for use in Microsoft Office and aren't supported in Refinitiv Workspace. What are the replacements that I can use?
-
Is it possible to get the dataframe list of powerplants from POWOUT app into Codebook?
Hi Team, Is it possible to get the dataframe list of powerplants from POWOUT app into Codebook? Kindly advise. Thank you in advance.
-
Convert python code to ‘import eikon as ek’
Hi Team, Can you help me to use eikon api and use the command ‘import eikon as ek’ to import the code below? import refinitiv.data as rd rd.open_session() rd.get_history( universe='CBF24^2', fields=["SETTLE"], count=1, ) Could you please provide the code that can be used through eikon package? For some reason, seems…
-
Eikon customer unable to synchronize Power BI via Python.
Can't synchronize with Power BI via Python. Below is a simple example of the correct Python coding settings on my computer to synchronize with Power BI. "import pandas as pd data = [['Alex',10],['Bob',12],['Clarke',13]] df = pd.DataFrame(data,columns=['Name','Age']) print (df)" However, when I try to synchronize the code…
-
WTCLc1 historical tick data in Eikon API
Hi team, we are trying to get the historical tick for WTCLc1 in Eikon API but its showing NA ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY') data = ek.get_timeseries("WTCLc1", fields = ['BID'], start_date='2023-11-22T00:00:00', end_date='2023-11-22T23:59:59', interval = 'tick') print(data) I checked in Eikon excel if we have…
-
How to automatically download a list of domestic investment trusts using VBA
Hi,I want to automatically download a list of domestic investment trusts list everyday using task scheduler. I think if I could write Excel VBA(32bit) by setting the Thomson Reuters .dll as a reference. Which dll and library should I use? and where do I find how to write code(ex:tutorial or documentation) Thank you.
-
Backend Login to Eikon Desktop Integration
Hello everyone, I'm currently working on a project and I need to implement a feature that involves logging into Eikon Desktop using my backend code. I'm using Java for the backend and calling python API to get data. I've been researching this, but I'm not sure about the exact steps or libraries I should use to achieve…
-
TR.EnvironmentPillarScore only returns NULL value I Same request 2 days ago worked fine
Dear Community, I am trying to retreive ESG data with the TR.EnvironmentPillarScore function through the Excel Add-On API. However the same function which worked two days ago now returns a NULL value for all inputs. =@TR(AA4;"TR.EnvironmentPillarScore";"SDate=#1";AK2;F4) AA4 = BNPP.PA AK2=Output Cell F9= 03.07.2016 Double…
-
How does the TR.IR.RatingRank compare to the Moodys Rating
Dear Community, by using the TR.IR.RatingRank function in the Eikon API the output contains a certain number (e.g. 1, 2, 3, ...) representing a harmonized credit rating score of an issuer. Can somebody tell me what each rank would translate to in Moodys Credit Rating Scale (Aaa, Aa1, ....). Thank you in advance!
-
Dex2 Unable to collect data error
Hello, Eikon C++ COM API, Dex2. Randomly, we receive "Unable to collect data for all requested fields" error as a response. Sometimes it's a legit error when no data exist for all requested RICs. But sometimes it's an incorrect answer. Today we get this error on the following request: Instruments:…
-
Consult the Interval field corresponding with the RIC code
I have some RIC codes of commodity prices, but I am not sure about the update frequency of these price releases. Could you please help me confirm their Inteval field information? e.g. GNT-RJK-SAUC,GNT-RJK-BAUC,CVO-SYB-IT,SOYB-ROS-BCR,LARD-LSE-CHG.
-
How to get a list of historical rating data with the specified cusip?
I am using the Data platfrom API with python, and I want to get the list of historical rating data of a municipal bond with cusip "613340Q27" I can see the list in the desktop application window (right hand side of the screenshoot), but i don't know how to get it from python API, please help me
-
Cash flows are not able to retrieve in Eikon API excel sheet. File has Macros. ERROR: Invalid Index
File is too large. Attaching screenshotMacros.jpg
-
COM API. Initialization fails
Hello, We are experiencing the same issue again and again. At some random times, the program cannot create Dex2Mgr or RSearchMgr. The methods are (from eikondesktopdataapi.tlh): virtual HRESULT __stdcall CreateRSearchMgr ( /*[out,retval]*/ IUnknown * * instance ) = 0; virtual HRESULT __stdcall CreateDex2Mgr (…
-
Python Kernel not connecting on MacBook with Ventura 13.0.1
I am unable to initialise Python kernel in CodeBook on my Mac with Ventura OS. However, when I use my old MacBook with Catalina OS, then Python kernel using Codebook works. Any advice as to why this is the case? Many thanks.
-
Download limit number
Hello, I got a query from client. How many bonds extracted by conditional search can be downloaded at once? No limit? In case of EIKON, download limit number is 10000.
-
Default proxy port #9000 failed
Timeout access Eikon API from Phyton API status works from web browser (http://localhost:9000/ping?all and http://localhost:9060/api/status) Running sample code returns timeout error. Code: import eikon as ek ek.set_log_level(1) ek.set_app_key('<app key here>') df,e = ek.get_data('REUTERS','TR.RIC') Output: [2022-10-27…
-
ESG Scores - quarterly/monthly/weekly/daily/hourly
Hello, I would like to know if it is possible to retrieve either quarterly/monthly or weekly/daily ESG scores. I am studying the effect of M&A transaction on the acquirer's ESG score and want to capture the fixed effect of the deal on the acquirer's ESG score. Using annual scores might not be very authentic for my…
-
how to run the API examples
Hi, im a new user trying out the API examples here: https://developers.refinitiv.com/en/api-catalog/eikon/-net-apis-for-use-in-custom-applications/download I get it to build fine in VisualStudio. upon run I get a console window then a message ..."you'll need an app to open this reuters" do I really need the Refinitiv Eikon…
-
Get RIC or ISIN from company name
Using EIKON with Excel, i want to retrieve either RICs or ideally ISINs for a large number of companies. Now, what I could do is using the "build formula" tool to get the codes manually by typing in the companies' name and selecting the right one from the search suggestions, usually the top hit. I would like to automate…
-
web alternative to COM API ?
We are currently using Eikon COM API to retrieve the following data : * RIC * debt instruments (bonds, loans) with full related informations * historical data : yields, issuance information, credit rating information * currency and industry curves What would be an alternative API to avoid installing Eikon on the computer ?…
-
CUSIP/ISIN to RIC
ezyzip-2.zip Hello, Could you please tell me how to convert a list of 140,000+ CUSIPs/ISINs to RIC through RD library? I would appreciate if you could provide me a sample code. Attached are the list of CUSIPs/ISINs that I want to convert to RIC
-
Migration of .NET Application to 64 and COM Exceptions with calling EikonDesktopDataAPI
Hi, Our Desktop application written in .NET has Eikon integration for many years. Recently we recompiled the application to x64 and since then the integration has been broken. When attempted to execute this line of code, I'm seeing COM exception. try { _eikonDDA = new EikonDesktopDataAPI.EikonDesktopDataAPI(); // we here…
-
Excel COM Add-in
Hi all, hope someone have had the same problem and managed to solve it I have set the COM add in to load at start up as following: File --> Options --> Add-ins --> Manage COM add-ins --> GO --> checked the box for the relevant Add-in --> Load Behaviour --> At Startup. So far so good. I can close Excel, reopen it and the…
-
MS Excel (Pro 2013) Addon for Eikon - Question for upgrading existing complex template
Hi, I tried to upload my MS Excel Eikon based template which contains three (3) worksheets but I'm keep getting this discussion board's uploading feature's error message that file is too big to be uploaded. I tried to delete two worksheets and have file uploaded with only one worksheet to reduce the file size but it's…
-
Is there a Refinitiv Workspace COM API for Excel VBA?
Hi team, I am using Refinitiv Workspace now and I have used Eikon before. On Refinitiv Workspace, the traditional Excel formulas such as =RHistory() works well. However, COM API cannot work. For example, the older "RHistoryAPI.xlsm" tutorial program (publicly downloadable under Eikon COM API section of this website) cannot…
-
When user run internal app (Time Series: Daily Interval Demo) and enter a normal RIC (i.e. EUR=) the
App was built by Updata Analytics from the supplied ApiDemo for the EikonDesktopAPI – TimeSeriesDailyIntervalDemo. When user run internal app (Time Series: Daily Interval Demo) and enter a normal RIC (i.e. EUR=) then the application appears running/thinking but nothing pops up. The window remains empty. The result of the…
-
COM APIs in Office 64bits
Hello Team, My configuration is: Windows 10 64bits Office 365 64bits I tried running the ALL_COM_APIs.xlsm tutorials file and I performed the following fixes: -Added PtrSafe keyword where missing -Remapped the rtx.dll reference path Tutorials 1 to 5 and 9keep failing with error "Runtime error '91' Object Variable or With…
-
Migration to Windows 64 Bits for .COM API
Hi team, One of my client has developped its own applications within Microsoft Access, leveraging our .COM libraries to pull out a wide range of data type and functionalities: * AdfinX Real Time * Dex 2 * Research * AdfinX Analytics * EikonDesktopDataAPI They are currently working on Windows 8 - 32 Bits and office 32 Bits…
-
Eikon software registration key
We are performing a security check and Cyber Security is asking if the Eikon software .exe binary file is generic or contains embedded registration key specifically for our company. Can you help me with that ?
-
EikonRefreshWorkbook giving previous request results
Hi, I'm having trouble with automation of EikonRefreshWorkbook. I'm trying to loop through a set of companies to save some summary results. As i do the loop, I watch the data get populated for the company I request, and then a few seconds later the data refreshes to the previous company without me changing the company ID…
-
Historical insititutional ownership
Hello, I want to calclulate historical insititutional ownership for S&P500 companies using the Eikon Formula Builder. To get the amount of shares owned by institutional investors I use: @TR(C1;"TR.InvestorType;TR.SharesHeld";VERKETTEN("SDate=";TEXT(A1;"jjjj-MM-tt");" CH=Fd Transpose=Y");D1). To retrieve the amount of…
-
$$ER: E100,INVALID CODE OR EXPRESSION ENTERED
Hi, I am trying to download data using the excel addins. I used the request table for my L#001 list which contains 2,000 companies, I want to extract daily data of stock price but then it shows $$ER: E100,INVALID CODE OR EXPRESSION ENTERED. However, I managed to get stock prices around 1970 stocks. I am wondering if anyone…
-
dex2 response contains duplicated RIC
C++ Com API, using dex2. Requested fields: TR.ISIN, TR.SEDOL, TR.RICCode, TR.AssetCategoryCode for RIC: PUCOBRE..SN. The response has 2 records : 'CL0002483510','BGPFS63','PUCOBRE.SN','ORD' NULL,'BGPFS63',NULL,NULL This is the only symbol from the whole Chile, Mexico, and Colombia RIC universe Why? Thanks
-
What is the daily limit of hit (couple field * instrument) of the API in excel ?
What is the daily limit of hit (couple field * instrument) of the API in excel ?
-
Cannot login to Eikon. Configuration Download Error
As the title says, cannot log in to EIkon from any machine. Before you send me to Help Desk Support. I cannot create new ticket there : This is very critical.
-
Access Chunk records in MATLAB
May I ask how to read the the following data in MATLAB? timeSeriesRequestSetup = timeSeries.SetupDataRequest('ATGOV1YZ=R'); timeSeriesRequestSetup.WithView('DISC_FACTR'); timeSeriesRequestSetup.WithInterval(ThomsonReuters.Desktop.SDK.DataAccess.TimeSeries.CommonInterval.Daily);…
-
EikonDesktopDataApi::Initialize() does not trigger OnStatusChanged
We use the EikonDesktopDataApi in a C++-COM-Environment. The program uses EikonDesktopDataApi::Initialize() to connect to Eikon. 1) Working scenario: If we start and login into Eikon separately using the official Desktop-Eikon-Client prior to starting our application everything works fine. After…