-
How to efficiently and briskly retrieve datapoints for all SNP 500 RICs
Hi everyone, I am trying to retrieve some Fundamental and Reference data for all of the SNP 500 stocks. These datapoints include values such as Income before Extraordinary Items, EBIT, Capital, etc. Now, I am trying to asynchronously retrieve all of this data. At first, I tried to loop ethrough the list of the RICs of the…
-
Corporate Bonds: Retrieving Dates of Coupons paid this year, and other bond data
Hi everyone, I have 2 questions regarding the retrieval of Corporate Bond data with the Refinitiv Data Library in Python. I am currently trying to retrieve the coupon rate, next payment date, and coupon payment frequency, with the following formulae: 'TR.CouponRate','TR.FiNextPayDate','TR.FiCouponFrequency' I checked that…
-
Certain Refinitiv Data requests work individually, but not concurrently (Python)
Hi everyone, I have an issue regarding concurrency with functions using get_data(). My workflow is as such where I have multiple requests of get_data() and get_history() in different asyncrhonous functions that I am executing concurrently using Python's `asyncio` library. Now, the issue is, when these functions are…
-
How to get company name, GICS Industry Group Name, 260 day volatility, and market cap of Russell 300
Hi team. I have a client who needs to pull company name, GICS Industry Group Name, 260 day volatility, and market cap of Russell 3000 constituents using API. I tried to pull this data using Codebook and was successful. Please see screenshot below. However, when client tried it using Python in Jupyter Notebook, he got an…
-
Trying to Access Refinitiv API through JupyterNotebook, get "Port number not identified" error
I am trying to access the Refinitiv API through Python, using JupyterNotebook. However, when I try to do so, I get the error message "Port number was not identified". I followed the instructions in this link: https://developers.lseg.com/en/article-catalog/article/eikon-data-api-python-troubleshooting-refinitiv When I get…
-
Besides CodeCreator, is there an overview of all kinds of different data that can be accessed using
I'm a complete beginner in programming and I'm generally still struggling with Python and the programming environment, but I've been able to pull some data using the Get started guide. However, I still lack a complete overview of all possible data that I can query via Eikon. The CodeCreator in the Refinitiv Workspace is…
-
Problems and disagreements when extracting data in Jupyter outside the Codebook environment.
Hi! I notice a problem when I pull data in my Jupyter notebook, and when I pull the same data with the same way on the CodeBook environment, this problem does not appear. However, for more flexibility in my work, I need to get these data outside the CodeBook environent. Below you can see two prints that ilustrate the…
-
cannot find etf ticker in codebk
I am attempting to download the historical prices for the following assets: GDAXIEX.DE, IBTLl.DAp^G21, LP68048431. I am using the usual command: rd.get_history(universe=asset_name, fields="BID", interval="1D", start=start_date, end=end_date) However, I am encountering an issue. It seems that the asset names I need to use…
-
Extracting and Matching Data from an Excel file with Eikon API
I have an excel file containing a companies/employee names, their patent applications and year of filing. However, now I need the financial information for these firms for the given year (from eikon), as listed in the excel sheet. The main problem i have is that the names in the excel sheet are not an exact match with…
-
ReadTimeout on simple requests
I'm just getting started with the Refinitiv Data Library and trying to go through some of the examples contained here: https://github.com/LSEG-API-Samples/Example.DataLibrary.Python/blob/main/Examples/2-Content/2.04-ESG/EX-2.04.01-ESG.ipynb However, I get stuck on even the most basic ones like: response =…
-
Error: 'NoneType' object has no attribute 'jason'
Hi Team, I'm running the following script in Codebook and works fine: ----- import refinitiv.dataplatform as rdp import plotly.graph_objects as go import pandas as pd import numpy as np from datetime import datetime from dateutil.relativedelta import relativedelta…
-
Pricing a bond with a modified yield curve
Hello, I have downloaded the yield curve of a bond benchmark using the following import refinitiv.data.eikon as ek curve = ek.get_data('0#ITXZ=R',['MATUR_DATE','PRIMACT_1']) Then I modify the yield curve by applying a parallel shift of 25bp via: curve['Shifted_Rate'] = curve['PRIMACT_1ì] + 0.25 Now I want to reprice a bond…
-
Eikon API Error 403 Error code 403 | Client Error:
Hi All, I'v just set up my new Eikon Global Equities. Unfortunately, I got an error Message when trying to request Data my local installed Jupyter Notbooks: The code i was running is: import eikon as ek ek.set_app_key('6441----------------f77') data = ek.get_timeseries('.BRTI', # the RIC for Apple, Inc. fields='*', # all…
-
How to screen for companies that do not have an ESG score?
How can I adjust my screener search: screener = f"SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.RegCountryCode,{country}), TR.TRESGScore(Period=FY{i})>0, CURN=USD" which screens for companies that have an ESG score for a screen only returning companies that do not have an ESG score? I have tried:…
-
How to call pandas from the Eikon Code-book, as references to "pd." do not work?
This should be easy, I am using the Jupyter codebook in Eikon desktop. This works fine, but why can't I refer to pd when wanting to use a method from pandas? Normally one would expect a line like import pandas as pd at the top of a script, but it is missing. Do I still need to add that line?
-
Is it possible to install Datastream API through Jupyter notebook?
Hello, is it possible to install Datastream API through Jupyter notebook? or can we install it without using the anaconda prompt? Thank you
-
How do we correct this syntax?
SCREEN.express.universe(Equity(active=True, public=True, primary=True)).conditions(IN('TR.CoRTradingCountryCode', 'US'), 'TR.CompanyMarketCap(Scale=9)',>=10).currency('USD').query SCREEN.express.universe(Equity(active=True, public=True, primary=True)).conditions(IN('TR.CoRTradingCountryCode', 'US'),…
-
"This account is not entitled to all requested identifier types"
Hi, I'm using Jupyter Notebook trying to run a simple lookup using this Symbology API endpoint, https://api.refinitiv.com/discovery/symbology/v1/lookup, and I get the message below. I tried this same code in CODEBOOK and I get the same error. The AppKey I used to run the query in Jupyter is generated using my RDP login.…
-
Latest Eikon API dependencies
Hi all! I am trying to install Eikon via conda, however every time I reach an impasse because I get backtracking issues. I am trying to find the latest module dependencies for all the modules and copied the ones in the Quick Start guide: "Successfully installed appdirs-1.4.3 certifi-2018.1.18 chardet-3.0.4 datetime-4.2…
-
How To Share A Notebook In CodeBook ?
Hello, is there a way to send - like as a forward message - a notebook made in CodeBook to a colleague that has as well Refinitiv Eikon/Datastream ?
-
Unable to Open RDP Platform Session
I used to access RDP platform on Jupyter notebook but is not working anymore not sure what is wrong session is not opening
-
Not able to connect eikon API through jupyter notebook.
-
rdp not defined
Hello, tried a basic query as below and get an error saying rdp not defined. Please can you guide?
-
Eikon API Streaming error
I followed tutorial as below on Jupyter Notebook. https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/tutorials#streaming-api-how-to-retrieve-real-time-streaming-prices streaming_prices = ek.StreamingPrices( instruments = ['GBP=','JPY=', 'CAD='], fields = ['CF_BID','CF_ASK','OPEN_PRC', 'CF_HIGH','CF_LOW',…
-
Retrieve time-series form the cloud
Hello, I have a Jupyter Notebook running on the cloud. The Eikon API works only locally , and I would like to ask if there is an equivalent way to retrieve time-series and prices through web authentication (REST API or similar) .
-
Notebook api error 503
Hi, I'm having this error, please could you help me? It is running in a Windows 10 with a Proxy (do I need to open any por diferent from 80 and 443?). For example if I try to run: import eikon as ek #Eikon DATA API ek.set_app_key("My key") symbology = ek.get_timeseries(['US4642872422']) I'm getting: 2020-11-30 17:13:11,275…
-
Jupyter Notebook not connecting to Eikon Data API
Hi, I recently got a new computer and re-set up my dev environment. However, when I try to run any of my existing jupyter notebooks, I get the error... ERROR: no proxy address identified. I don't know how to solve this problem. If anyone could help would be great. best, Milan
-
Eikon API proxy not found when running Eikon from Jupyter Notebook - works on local IDE
I can run Eikon queries from my usual IDE (Pyzo) but when I try to connect to the Eikon API from Jupyter Notebook I get the following error: 2020-09-25 13:09:03,867 P[16856] [MainThread 19368] Error: no proxy address identified. Check if Eikon Desktop or Eikon API Proxy is running. 2020-09-25 13:09:03,871 P[16856]…
-
EikonError: Error code -1 | Port number was not identified.
I am trying to run the python eikon toolbox for the first time. I have set up the app_key and defined it as a variable in the jupyter notebook but I am getting an error. EikonError: Error code -1 | Port number was not identified. Check if Eikon Desktop or Eikon API Proxy is running. I have the Ikon desktop version running…
-
EikonError Port # was not identified
Hi Team, I am raising this query on behalf of a client. Please see the client's query below: I need to run the jupyter notebook/ python environment from my firm's AWS Linux server environment. I cannot install it locally. I am getting this error. Is there a way to work around this port checking because the machine running…
-
Importing specialized Eikon data into Jupyter Notebook
Hi there, There are many charts I have personally set on my Eikon. For example, a spread between the US 10YT and Japanese 10YT, a correlation between USDJPY and the US 10YT and so on. Can I import these specialized Eikon data into Jupyter Notebook by API? Thanks,
-
Importing eikon module on Jupyter notebook
Hi I have tried to import eikon module on Jupyter, but not going well and got an error message that there is no module named 'eikon'. Of course I have already installed eikon packages by pip on commando prompt. could anyone please tell me how to solve this problem. Thanks, install-eikon-by-pip.png eikon-packages.png
-
eikon news sentiment tutorial-do not get plot for sentiment
I got horizontal line for sentiment plot which is different from the result in video https://github.com/yhilpisch/eikondataapi/blob/master/notebooks/11_tpq_eikon_news_sentiment.ipynb
-
Eikon Api and Jupyter Notebook in Miniconda
Hi - I am trying to set up the eikon api and jupyter notebook in miniconda - is there someone who could help?