-
APP key to use following the upgrade to LSEG
Could you kindly confirm if the link below is the correct one for generating the APP Key for the Desktop session following the upgrade to LSEG? https://developers.lseg.com/en/api-catalog/lseg-data-platform/lseg-data-library-for-python/quick-start/access-credentials We are unable to locate the LSEG API key via this link.…
-
Error when connecting to Eikon via Python
Hi, I am using Python to connect to Eikon using my windows 11 PC. When I tried to run the following code: import eikon eikon.set_app_key('app_key') The terminal returned with the following errors: 2024-09-11 14:26:31,219 P[8112] [MainThread 3920] Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('')…
-
Eikon API Connection Refused
I am having issues with connecting to API via the APP KEY - it sucessfully works initially however after some time or restarting my computer when I try connecting with the same appkey it then suddenly fails and trying http://127.0.0.1:9060/api/status I get connection refused. If I generate a new appkey and then use that it…
-
Intermittent errors using Refinitiv Data Library via Python
My customer is getting intermittent errors when using Refinitiv Data Library API via Python (They were not getting errors when they were on Eikon API) The error code they get more often than not is....raise RDError (-1 except_msg) refinitiv.data.errors.RDError: Error code -1 Backend error. 400 Bad Request Requested…
-
Can i get for Eikon api python, to generate a code for m&a deals screenin?
i need help for Eikon api python, to generate a code for m&a deals screening: worldwide deals, announcement date between 01.01.2010-31.07.2024, status completed, The deal value >$1 million, Both acquirer as target are Listed on a stock exchange, The acquirer holds <50% of the target’s publicly traded shares before the…
-
install the refinitiv library for python
I have just tried to install the refinitiv library for python on my computer. Unfortunately there are “unsolvable” version conflicts - see screenshot attached Apparently the library only supports outdated pandas (max 1.6.0) versions (I have installed 2.2.2), which are not compatible with the installed Python version…
-
Get "related instruments" using the refintiv.data API
Hi all, I'm looking into using the refintiv.data python API to calculate benchmarks for bonds. Right now the process is very manual and not scalable, I'm searching the bond in the workspace and looking at the "Related Instruments" tab, then creating my query and looking at the results. (see screenshot) I would like to use…
-
Refinitv API connection force log out my Workspace app and do not allow me to sign in
Hi, I am forced log out when I open_session with Refinitiv.data while having the Workspace app open, then the app asks me to sign in (screenshot below), after I hit 'Sign In', it shows 'Loading' then return to the first screenshot. In order to sign in, I have to force close the app on Task Manager and launch it again. Does…
-
How can I use the result of first code as universe for the second set of codes in python API?
For example =@TR(TR(TR(M20,"TR.FiIssuerOrganization","CODE:ISIN"),"TR.CreditRatioPD") This one retrieves first the issuer organization id from the ISIN of the bond Then after getting the organization ID, it gets the default probability. All in one go. So the formula has 2 layers, one for getting org id, then another for…
-
Refinitiv Python Connection Open session HTTTP Request id 0; get_date failed
Hello, I'm using Python and connecting to Refinitv.data. The script is run by Task Scheduler, after rd.open_session(), the get_data() function is failed to perform. It worked well when I'm using Jupyter. Below is the message. Would anyone be able to help me with the issue. Thank you for your help. Best, Tim
-
i use my own IDE Pycharm, any change on Python ?
i use my own IDE Pycharm not codebook, any change on Python API?
-
Dividend Yield of All ETFs
Is there a way to get dividend yield data for all US stocks and ETFs in bulk using a Python API?
-
Treasury futures level 2 historical nanosecond data access on-demand via Python API
Hello, I am looking trying to find the specification for pulling the level 2 data for treasury futures contracts, i.e. TYU24, for all best bid and best ask as well as each of the respective volumes for each of the levels. I would like to receive a response with the most granular intraday timing for a specified date (I…
-
Is there a way to get the options chain RIC from the underlying when using the API? For example how
Is there a way to get the options chain RIC from the underlying when using the API? For example how would you go from MAERSKb.CO to the associated options chain? you can use the ek.get_data() function in Python. however Is this available in any other APIs or only Python?
-
If there is a way to stop or postpone the API from automatically disconnecting
I am using Python to retrieve some data. But the API will be disconnected from time to time.
-
PYTHON SYNATX FOR ACCESING NEWS USING GENERAL KEYWORDS
am currently using your API key through Python code for my application and have a few questions regarding its usage. * How can I access news through Python? For example (shown below), in your guide, you use the code “MSFT.0”. How can I find the corresponding codes for all my suppliers (manually searching is difficult since…
-
Align ESG data with market data (in time).
I'm working with the EK API to get ESG data with market and fundamentals data for a company (e.g., AAPL.O). My goal is to pull fields related to price, market cap, ESG scores, and Scope 1 emissions (and other extra-financial data). I have problem aligning the dates. Here is the code I'm using: fields = [ 'TR.PriceClose',…
-
Company Events Data do not get downloaded in Python Workspace API
When using the Python Workspace API under Windows 10, Events data for companies are not getting downloaded, even if parameters (e.g. Start-End Dates or Event Types) are changed. For example, the following code:…
-
Python version of https://api.refinitiv.com/discovery/search/v1/lookup
Is there an example of how I can implement the functionality of https://api.refinitiv.com/discovery/search/v1/lookup using the Python module (e.g., import refinitiv.data as rdp)?
-
Download bond prospectus via API
Hi all, I am trying to download a list of corporate bond prospectus available at Eikon (around 3000 bonds). I have the ISIN and RIC of bonds. Is there a way of bunch downloading from API? Many thanks!
-
Unable to connect on VS Code Python
Hi there, Whilst I have been using CodeBook, I'd also like to code locally on my machine and use Visual Studio Code. However, the following script returns an error and as a result I am unable to connect: import refinitiv.data as rd from refinitiv.data.content import news from IPython.display import HTML import pandas as pd…
-
How to know the currency in which my data is collected ? (using Python Eikon Data API)
Dear network, I am currently collecting companies financial data for my master's thesis, using Python Eikon Data API. I want all my data in USD but some companies have different standardized currency (eg file attached). When I collect the data with Jupyter, I don't know the currency of the data, and then how to convert it…
-
Obtain list of all equity indices in a country
Hello, I'm working with Datastream and Eikon. I noticed that on the Datastream navigator we can get access to a list of equity indices for individual countries ("markets" as per the Datastream Navigator terminology)--see attached screenshot for reference.Capture.PNG To avoid manual work, I would like to use Python and my…
-
HTTP request failed: Invalid port: 'None'
We are not able to use Eikon API . When we run the python code, I get error " HTTP request failed: Invalid port: 'None' this is the sxs logs that we got
-
"SDate" and "Period" parameters of get_data function
Hi everyone, Thanks to the insights from another user's thread on this forum, I was able to create a function that retrieves the historical constituents of the SP1500 at a specific point in time (specifically, at the end of each year). My ultimate goal is to get a list of firms which where constantly part of the SP1500…
-
1ST TIME USER SETTING UP DEPLOYED_PLATFORM_HOST/USERNAME
Hi all, greetings. I am first time user. I am going to try the example codes (https://github.com/LSEG-API-Samples/Example.RDPLibrary.Python). It requires setting up certain fields for credentials(https://github.com/LSEG-API-Samples/Example.RDPLibrary.Python/blob/master/credentials.ipynb). I think the first 3 is just the…
-
Is Client_ID and Client_Secret the exact same thing as App Key in RDP?
I need to retrieve the Client Number, Client Secret, and App Key to be able to use an API in Python. I was recently referred to APPKEY with the steps below: Refer to the steps below to generate the App Key: 1. Type in APPKEY in the search bar 2. Select Eikon Data API checkbox for generating an AppKey. 3. Click the…
-
Python WebSocket Code on RTO - Would it work on RTMDS over WebSocket
We have a client that is currently using Python API to connect to RTO on AWS and generating json files as output for real-time data. They are now evaluating to move the workflow from AWS to on prem RTMDS setup where they have access to 2 ADS servers over private comms. The RTMDS setup is WebSocket enabled. Client wants…
-
1\. Are you allowed to access the Refinitiv Data Platform real-time services via websocket
1\. Are you allowed to access the Refinitiv Data Platform real-time services via websocket. 2\. If you are: what is the hostname and authHostName (the authentication hostname) , they could be the same. 3\. What is the current and relevant code example in either Python or C#. 4\. Is there updated documentation that we can…
-
Eikon Data API to fetch Tesla's current stock price into Google Sheets
I am trying to use the Eikon Data API to fetch Tesla's current stock price into Google Sheets, but I keep getting an error saying that the endpoint is incorrect. Where can I find the correct endpoint, or could you provide an example endpoint for me?
-
Is the Datascope API only available in C# ? Or is it also available in Python for example?
Is the Datascope API only available in C# ? Or is it also available in Python for example?
-
Advanced Filings on Eikon Python
I want to use the Advanced Filings tool on Refinitiv Eikon on Python Could you guide me with the required code to do so?
-
Issues with rd.open_session (python API)
hey guys, I'm trying to run the following lines: import refinitiv.data as rd rd.open_session() trading_instrument = 'ESc1' prices = rd.get_history( universe = trading_instrument, fields=['TRDPRC_1'], start = "1997-01-01", end = "2024-07-31", ) prices = prices.loc[:,~prices.columns.duplicated()] prices and now I'm getting…
-
Is there a way to pull up TOP NEWS app -> COMMODITIES -> ENERGY into API in Eikon?
We wanna see trending topics, last news, market snap shop
-
Is there a way to obtain OSP/WLD quote data page in API in Eikon?
-
Python for creating large databases
Good morning, I am needing to obtain a large amount of data for an institutional project at the University and I have not been able to do this, since the page collapses, as does the extension in Excel. They tell me that from Python there is a method to address this, I would appreciate any information about how I can use…
-
Power hourly prices for europe
Describe the technology What API are you using? refinitiv: I have a license What language are you using? python What environment are you in?Windows Describe what you've tried trying to download the hourly prices for power europe I don't know what i need to do, if i need to use refinitiv.data and get_data or get_history…
-
Workspace API Query
I am using refinitiv.data version 1.6.1 and Python version 3.12.4. My current subscription is for Refinitiv Workspace. I have the following questions: * Is there any option to use the Python API without getting kicked out of the workspace desktop session all the time? * What is the exact difference between eikon library,…
-
Python refinitiv.data Screener not working
I have the following screener code in python ... import refinitiv.data as rd rd.open_session() syntax = ( 'SCREEN(' 'U(IN(Equity(active,public,primary))),' 'TR.CompanyMarketCap(Scale=6)>=300,' 'TR.F.NetDebtToEBITDA(Period=FY0)<=3,' 'NOT_IN(TR.GICSIndustryGroupCode,4010,4020,4030),' 'IN(TR.RegCountryCode,IN),'…
-
how to use RefinitivData API in Django app
I want to use refinitiv.data api to get some data in Django app, when i open session An error occurred while requesting URL('http://localhost:9060/api/status'). ConnectError('[WinError 10061] No connection could be made because the target machine actively refused it') An error occurred while requesting…