-
Sectoral FDI data for BRICS
Can we get the historical Data on FDI for different sectors in BRICS countries?
-
rd.get_history and rd.get_data comparison
Greetings, I am in the process of developing an algorithm designed to extract specific dates and associated closing prices related to delistings, bankruptcies, or private transitions of publicly traded entities. Currently, I am encountering difficulties with the functionalities of rd.get_history and rd.get_data. Below, I…
-
What Happened to Efficiency Ratio?
Hello everyone, Does anyone know if there have been any changes related to the Efficiency Ratio? I can no longer find it in the fundamentals of companies, and when I search for it in the search areas by manually entering the column, it only provides me with the most recent data available and not the annual data. The same…
-
Issue to consume streaming price on DesktopSession mode using Refinitiv Data under C#.Net
Dear Developer community i share with an issue i'am facing since last week. Indeed when opening a Desktop session it tooks a very long time that usual, to finally a state response 'Opened'. But every request to stream data return 0 data. at log level, i got these warning messages: 2024-03-01…
-
PropertyNames for 'filter'
Hi! I was following a previous recommendation to utilize the Search API for my project. The integration has been successful, but I've encountered an obstacle with configuring the filters. Specifically, I am having difficulty identifying the appropriate PropertyNames to use within the "filter" parameter, as these were not…
-
Error for TR.DivAdjustedGross.
Hello! I have trouble getting values for "TR.DivAdjustedGross": I receive an error: Error code -1 | Output parameter 'date' is unrecognized. This could possibly happen because of mismatch between top level function expression and its usage in output. Make sure that you used exactly 1:1 identical expressions. Requested…
-
[ Codebook - Excel] How to dynamically link ".xlsx" or ".csv" file generated in Codebook to Excel
Hello, I have an issue concerning the retrieval of data to an excel file. 1. I use the Refinitiv Date Library API in Python using Codebook. 2. I am trying to obtain data about numerous financial instruments (equity, stocks,...) concerning their performance indicator ("TR.TotalReturn") over a period of 5 years (until now)…
-
refinitiv.data not able to retrieve RDP access token (Error code 401)
Hello, Recently I received Refinitiv Workspace and am using it instead of the old Eikon application. I am using the eikon and refinitiv.data API via Python. The eikon API works without any issue, however when I try to retrieve data using refinitiv.data I receive the error code 401 with the following message: When opening a…
-
rd.get_history does not respect SDate and EDate with mixed timeseries and data fields
I noticed today that if a gethistory request (both in CodeBook and Pycharm) is made of which the requested fields are a mixture of get_data and historical pricing fields. The described dates are not respected for the timeseries fields. As can be observed from below the dates for the get_data part are respected but not for…
-
HistoricalPricing events return incorrect data table column types using beta 5 library.
Since beta 5 of the RDP library for .net the resulting DataTable of HistoricalPricing.Events requests has no valid column types set. This was working in previous version. In the beta 5 all column types are set to "System.Object". I reproduced this using the example 2.1.02-HistoricalPricing-Events using "Workspace"…
-
different stuff coming back from eikon.get_data() vs. refinitiv.data.get_data() ... why oh why?
I'd really like to move on from eikon as it is very temperamental ... (400, 500 errors randomly). But, first thing i want to move away from, getting contents from portfolios, any which way i try, i cannot get the CF_CURR or CURRENCY back from refinitiv.data when downloading my portfolios (or watchlists). All packages up to…
-
Volatility surface build failed
Hi everyone, I'm using the curves-and-surfaces endpoint to get some FX volatility surfaces. Most of the time it works fine but for some currencies pairs it fails (ex: EURXAG). Do you have a solution? Thank you for your help Regards
-
Is there a way to pass a proxy as a parameter in refinitiv.data library (Python)?
Hi, Similar to this question from 2 years ago, I want to connect to the refinitiv.data library via a proxy server. This is because I need to run rd.get_data requests from an internal private server with, let's just say, highly strict network configurations. Right now, running rd.get_data() the regular way will return an…
-
The access to field(s) denied: rd.getdata - TR.RDNExchangeCode
Hi, I want to get exchange code from rics. using rd library , which direct to /data/datagrid/beta1 import refinitiv.data as rd rd.open_session() rd.get_data(universe=["MSFT.O","IBM","GOOG.O","AAPL.O","SPY"], fields=["TR.RDNExchangeCode"]) rd.close_session() It return these errors. Please suggest if I need any permission to…
-
Fetch all news for a given day via data/news/ API
I need to fetch all the news headlines and stories for a given day via data/news/v1 API. Since there's no such endpoint which can provide daily dump of news data, what I did was to first get all the headlines using headlines?dateFrom=....&dateTo=... endpoint (using next cursor) then iterate over the headlines to get the…
-
Not able to retrieve all chain constituents using RDP API
Hello, I am trying to retrieve all the RICs from a chain using RDP API. I have found the link Article.RDP.WebSocket.RetrieveUnderlyingRicsOfChain/rdp-api-underlying-rics-chain.ipynb at main · Refinitiv-API-Samples/Article.RDP.WebSocket.RetrieveUnderlyingRicsOfChain · GitHub and have copied the code as is. The code on…
-
Refinitiv API error with local jupyter notebook
When the following code is executed in CODEBK it works well, but in local jupyter notebook is running generating the variable dataframe = None. import refinitiv.dataplatform as rdp from refinitiv.dataplatform.content import ipa from refinitiv.dataplatform.content.ipa import option from…
-
Can I use Screener to get a data-frame of Revenue values for companies broken down by sector in Code
Can I use Screener to get a data-frame of Revenue values for companies broken down by sector in Codebook? I tried in Excel and it crashes, presumebly because of the large size of the request.
-
Snapping zero-values with the Python RD library
Hi devs, There is a critical bug in the newly released refinitiv-data Python library, where zero-values are snapped as pd.NA. The error is caused by the highlighted snippet in refinitiv\data\content\_universe_streams.py in the build_df method. data = ( (inst_name, *(values.pop(0) or pd.NA for values in…
-
Contributing with Python Data Library API
Hi, I'm trying to contribute data into the ATS, however i can't make it work: For info, getting prices though the same stream works well. Thanks for the help. Regards
-
Access right error with Python Datalibrary api
Hello, I'm getting this error while using the refinitiv datalibrary for Python: Price requests are working fine but not the search requests: Where this access right has to be assigned? For information, i'm connecting trough a deployed platform. Thank you
-
Unable to connect to Refinitiv using refinitiv-data module
Hello, I am using following code to connect to Refinitiv using refinitiv-data module. However, I am getting error while connecting. Code Snippet: import refinitiv.data as rd rd.session.platform.Definition( app_key = '9505**********************', grant = rd.session.platform.GrantPassword( username = 'lisa*****', password =…
-
what function is equivalent to refinitiv-dataplatform's rdp.open_platform_session in refinitiv-datap
Please can you let me know what is refinitiv.data equivalent for rdp.open_platform_session in refinitiv.dataplatform. More specifically, the equivalent function for below: rdp.open_platform_session( 'key******************************************', rdp.GrantPassword( 'username', 'Password' ) )
-
FXALL Integration /w TCPI Java SDK or API - Help
Hey guys. Upon inquiring about trading FX I received the TCPI (Trading Center Provider Interface) - SDK Guide but to my surprise without any of the accompanying libraries nor the Java SDK toolkit itself. Could somebody point me in the right direction as to where the class-libraries can be downloaded and are there examples…
-
Unable to login - Access Denied
I'm getting below error when trying to access api playground: I have created App Key from "https://emea1.apps.cp.thomsonreuters.com/apps/AppkeyGenerator" And trying to access the api through python environment python system version: '3.9.13 (main, Aug 25 2022, 18:29:29) \n[Clang 12.0.0 ]' rdp version 1.0.0a19 Let me know…
-
rd.get_data queeps sending back annoying errors for real time requests 'Failure sending request'
Hi, When using the code below, I keep getting 'Failure sending request with <class 'refinitiv.data._data.content.fundamental.fundamental_and_reference.Definition'>' error messages, even though I get the data that I'm after: rd.get_data( ['GBP=', 'EUR=', 'JPY='], ['BID', 'ASK']) The issue is that I have this in a loop, so…
-
Janome and wordcloud in Codebook
Hello, we noticed that the Janome and Wordcloud is not available in the codebook __Libraries&Extensions.md folder. Is it possible to add these libraries to codebook or plans to its addition?
-
Issue when retrieving history using the Access Layer or Content Layer in Python
Hi All, I recently noticed an issue when retrieving history data through the Access Layer or Content Layer functions of the Data Platform Libraries for a list of RICs. There seems to be an abnormally massive wait time (I stop the application from running after 5 minutes). I am forced to revert back to using the Eikon API…
-
rdp.get_data() returns N/A for Canadian symbols
Below get_data function works fine for LSEG and AAPL but returns <NA> for BMO.TO. I wonder if there are no "Revenue" and "GrossProfit" feeds for Canadian stocks. import refinitiv.dataplatform as rdp rdp.get_data( universe=["LSEG.L", "BMO.TO","AAPL.O"], fields=["TR.Revenue", "TR.GrossProfit"] )
-
download multiple bulk ESG files with python refinitiv.dataplatform
I can only retrieve download links from python refinitiv.dataplatform package, just like those in web based api playground, with following code, where fileid is a single file id endpoint_url = 'file-store/v1/files/'+fileid+'/stream' endpoint = rdp.Endpoint(session, endpoint_url) result =…
-
.get_data API gives different results in refinitiv.dataplatform versus deprecated `eikon` python pac
Confusingly, this only works when using the `eikon` package, and not when using the refinitiv-dataplatform package. What am I missing? I thought the latter was a successor of the deprecated `eikon` package? The below gives an empty dataframe, indicating no valid results were found. import refinitiv.dataplatform as rdp…
-
Refinitiv Data Platform API in Python - Unable to connect
I have just been migrated over to Refinitiv Workspace. I am primarily interested in data retrieval via the Refinitiv Data Platform API in Python. I have tried to get this running in Python (outside of Refinitiv Workspace) by following the examples in CodeBook, but I am getting an error saying “Check if Desktop is running.”…
-
Getting FX forward curves
Hi, I am trying to get the values for the FX forward rates with: GET https://api.refinitiv.com/user-framework/mobile/fx-service/v1/fx/forwards/rates/{ric} I have tried different RICs (0#EURF=, EURF=, 0#EURGBPF=, EUR1M=, etc.) unsuccessfully. Is it possible to use chain RICs? Then, I tried a similar link without RIC: GET…
-
Accessing HTML content of news using the RDP .NET API
Hello, What is the best way of accessing the HTML content part off a news story. The IStoryData part of the returned IStoryResponse contains only the text/plain content of the styory in the NewsStory field. Many thanks, Darko Roje Spreadex Ltd
-
Multiple sessions
Is it possible to open multiple sessions using the C# .NET RDP API? It looks like when opening another session (using Configuration.Sessions.GetSession() as per the example on Github) it overrides the first session, and closing the second session will close the first one as well. Many thanks, Darko Roje Spreadex Ltd