-
Why is data not flowing in API while available in Excel for active funds?
Hi Team, We have use Code like this one: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['LP68702800','LP68611492'], fields = ['TR.ISIN', 'TR.FundName','TR.FundObjective','TR.FundRIESGEnviron','TR.FundRIESGGov','TR.FundRIESGSoc'], ) display(df) These fund RICs are active so we are curious why it…
-
Different execution result between codebook and python API
Good morning, I'm using the refintiv.data api to query some bond data. In the codebook I'm running rd.discovery.search( filter = f"RIC eq '458140BP4=RRPS'", select = "MaturityDate" ) this runs without issues and gives me the maturity date. However when i copy paste the same thing in my code editor, i get ValueError…
-
RDError: Error code 403 |
While trying to fetch data from Refintiv API this week, I am currently facing below error. Cna you please check why this below error occured, This was working fine last week, but started facing issue from this week. Please check RDError: Error code 403 | <html> <head> <title>Forbidden</title> <style type="text/css"> body {…
-
Running Concurrent Asynchronous Requests Efficiently using Refinitiv's Data Platform APIs
This question is kind of me seeking advice on this process based off of my knowledge. What I am doing right now, is that I am trying to pull data asyncrhonously using Refinitiv (financial Platform from the London Stock Exchange Group)'s APIs. There are about 5 tasks I am trying to run asynchronously using Python's Async IO…
-
modulenotfounderror: no module named 'refinitiv.data'; 'refinitiv' is not a package
use "pip install refinitiv-data" installed package, the py file only have 1 line "import refinitiv.data as rd" . got folllowing error: "ModuleNotFoundError: No module named 'refinitiv.data'; 'refinitiv' is not a package"
-
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
-
Help on SEDOL to RIC Conversion
API - EIkon Language - Python Environment - Windows I converted some 5000 stocks SEDOLS into RIC. I got all the RIC. Named it RIC1 ric1=pd.DataFrame(ek.get_symbology(sedols1, from_symbol_type='SEDOL', to_symbol_type=['RIC'])) Than I converted all the RIC into string by the function…….…
-
How to retrieve monthly institutional shareholding data for over 200 firms from 2003 to 2023 using E
Hi everyone, I am relatively new using Eikon API and I am also relatively unfamiliar with the code. I want to retrieve the monthly institutional shareholding data for about 200 firms from 2003 to 2023 without having to download the shareholder report for every company one by one. Specifically, taking one company's…
-
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?
-
Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('')
Error:ek.set_app_key('') 2024-08-27 12:35:48,279 P[39232] [MainThread 43996] Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('') 2024-08-27 12:35:48,280 P[39232] [MainThread 43996] Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('') 2024-08-27 12:35:48,282 P[39232]…
-
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…
-
how to get multi-language company name by eikon api
how to get multi-language company name by eikon api
-
download news
I need your help to download news from Chinese IA companies from 2023/05/11 to 2024/07/31. I have a .csv with Storyid and the text of the title of the 25,000 articles but need the complete articles (not only the title), maybe in json format or other . I created an API and tried to access using Jupyter notebook but was not…
-
Extremely slow and inconsistent API
rd.get_data(batch,["TR.RIC","TR.ISIN","TR.PriceClose(SDate=0M,Curn=INR)","TR.CLOSEPRICE(SDate=0M,FILL=PREVIOUS,Adjusted=0,Curn=INR)","TR.SharesOutstanding(SDate=0M)",'TR.GICSSector','TR.GICSIndustry','TR.GICSSubIndustry','TR.AssetCategory']) I have a variable ric_list which contains approx 2k RICs. In the above code, I try…
-
Async retrieval of Quarterly and Period Data
Hi everyone, I have a question regarding data retrieval by periods. Over here, is the equivalent of what I am trying to do, just that it is using get_data() instead of get_data_async(). This is an example that I can't make asynchronous: quarterly_revenue = rd.get_history( universe=[f"{ticker}"], fields=["TR.Revenue"],…
-
The reasons why ReadTimeouts Occur Ocassionally when pulling data in Python
Hi everyone, I have a question regarding ReadTimeout errors that occur when pulling data with the Refinitiv Data Platform in Python. Sometimes, I face a read timeout, and then the next time I run my code, the data comes relatively quickly. I would like to know why exactly this happens in the first place, is it because of…
-
Obtaining Years alongside retrieval of Fundamental Data Asynchronously
Hi everyone, I have a question regarding the Date column not coming with get_data_async function calls. When I am making calls like so: roa_datapoints = await content.fundamental_and_reference.Definition(universe=[f'{ric}'],fields=["TR.F.IncBefDiscOpsExordItems","TR.F.TotCurrAssets","TR.CommonName"],parameters={"SDate":…
-
Pulling PERATIO from get_data_async
Hi everyone, I have a question regarding asynchronously pulling the PERATIO value. Here, I am following the notation as I found it in the Data Item Builder. However, when I try to pull data asynchronously with Python, it doesn't work. data = await content.fundamental_and_reference.Definition(universe='AAPL.O',…
-
Obtain Closing Price of stock on set series of dates and return NULL if there is not data for that d
Hi All, How can I obtain the daily closing price for a stock for specified dates, returning NULL on any specific dates that do not have data? I'd like to obtain the daily price of several stocks over a set period of time. Ideally my output will look like this: Where a day that the latest closing price is not available…
-
Python API for Linux
Hello, my development environment is on a Linux machine and I cannot run the Refinitiv Workspace app on my local machine. I can use the Eikon API on the web portal but not locally. Is there a way to get price timeseries locally on a Linux machine using a Python API? Thank you for your help Davide
-
Python news sample jupyter notebook 'Missing scopes: {'trapi.data.news.read'}'
Hi, I am trying to use the python news sample jupyter notebook, but after connecting I getting this error 'Missing scopes: {'trapi.data.news.read'}' Can you tell me how to add the scope so the sample works please? thanks, Adrian
-
How to Efficiently Retrieve TR.PrimaryInstrument for Delisted Equities?
Hello everyone, I'm currently working on a project where I retrieve RICs and PrimaryRICs for a set of ordinary shares from various global markets using the Refinitiv Research API (EQUITY_QUOTES) through codebook. Then I use the PrimaryRICs to gather fundamental data for these companies. However, I've encountered a problem…
-
Unmatched financial statements reference dates with date index and EPS Report Date?
I am analysing Apple financial statements and noticed that the displayed date does not match with the reference date, the stock's fiscal year ends in September. aapl = ds.get_data(tickers = 'US0378331005', fields = ['WC01001A', "WC05901", "WC05902", "WC05903", "WC05904", 'W05350A'], start = '2020-12-31', kind=1, freq =…
-
Python Refinitiv Data IPA Financial Contract IR Swap intra-day pricing with datetime
I'm trying to price a SOFR swap at intra-day time periods. The documentation implies that a datetime can be provided, however, responses from the service show no valuation differences if a different time is used. See below for example code and outputs. response = rdf.Definitions( universe=[swap.Definition(…
-
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…
-
websocket connection error
Hello team, When I try to open a new websocket connection to RDP, I get the following error: Any idea where that can come from?
-
How do I get the Eikon equivalent of calcdate in dsws API?
How do I get the Eikon equivalent of calcdate in dsws API? The Eikon API call is: =@TR('ASX300 List'!J3:J500,"TR.RecMean.calcdate;TR.NumOfRecommendations;TR.NumOfStrongSell;TR.NumOfSell;TR.NumOfHold;TR.NumOfBuy;TR.NumOfStrongBuy;TR.PriceTargetMean;TR.RecMedian;TR.RecMedianLabel","SDate=1D CH=Fd RH=IN",$AB$1) DSWS API call:…
-
Error code -1 | timed out
Hi, im trying to create a request using this code: ek.set_app_key(refinitiv_key) rd.open_session() start_date = "2023-1-1" end_date = (date.today() - BDay(1)).strftime("%Y-%m-%d") tickers = pd.read_excel(ruta_insumos+"\Diccionario_Eikon.xlsx",sheet_name='Mercado')["Ticker"].to_numpy() tickers = tickers.tolist()…
-
[WinError 10061] No connection could be made because the target machine actively refused it
I had this weird issue from the new Python API for workspaces. Error using get_history_func>get_history (line 206) Python Error: RDError: Error code -1 | [WinError 10061] No connection could be made because the target machine actively refused it It doesn't happen all the time but frequently and last for 2-3 days (maybe…
-
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…
-
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…
-
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…
-
Failed return when pass the parameters to get_data
Hello, I'm new to the TR API and have been using Python to perform API queries. My script has been running smoothly for about two years. However, when I attempted to run it this week, I encountered various errors. After reviewing the code in my backup (codebk), it appears that the function get_data([list], 'Instrument')…
-
Eikon API - Extracting Ownership Information at the Quarter Level
I am using the Eikon API to pull firm ownership information in Python. I only need the resulting df to contain four variables: the firm's ticker, the date for the shares held, the number of shares held, and the investor type. My issue is that it is pulling the information for each specific investor, whereas I would like…
-
Python | Refinitiv Data | stream.recorder | TypeError: 'NoneType' object does not support item assig
I am intermittently seeing the below error. What could be a possible reason for this issue to occur? This error pops up when looping through an array of streams (each stream contains a list of RICs to perform: stream.recorder.record(frequency='tick') Error: Exception in thread Msg-Proc-ThreadOMMSTREAMING_PRICING_0.0: ...…
-
"Too many requests" when trying to download historic bond yields
Hello - I need to download historic yields for bonds -- and the size of the download would be too big for Excel. When I increase the size of the download, I get errors, usually this one: "RDError: Error code 429 | Too many requests, please try again later." I've also just had timeouts or it returns empty data frames. Below…
-
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…
-
Setting start date for fxforward and is it possible to get the data of multiple tenors and fx forwar
fwd_contract = cross.Definition(fx_cross_code='GBPCNY', fx_cross_type='FxForward', legs = [cross.LegDefinition(start_date='2024-06-30T00:00:00Z', tenor='3M')]) response = fc.get_cross_analytics(fwd_contract, fields = ['StartDate', 'EndDate', 'FxSwapsCcy1Ccy2', 'FxOutrightCcy1Ccy2']) print(response.data.df) I read the…
-
Batch Retrieval and Parallel Requests for Fundamentals and Historical Pricing Data
Hello, I am trying to utilize the following RDP API endpoints by utilizing Python requests library: * Company Fundamentals:* data/company-fundamentals/v1/financial-statements/global/balance-sheet * Historical Pricing:* v1/views/interday-summaries/ I need to retrieve data in parallel and as batches, if possible. I need to…
-
Client wanted to get the TREE Structure for Multiple Companies via Codebook
Already provided import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['HSBA.L'], fields = [ 'TR.RelatedOrgId', 'TR.RelatedOrgName', 'TR.RelatedOrgType' ] ) display(df) However its only for single companies, not really sure how to do this on Codebook then, appreciate your help in advance.