-
Cannot download file from filings endpoint
For some files I get the following error when trying to download certain file urls, e.g. for emea1-apps.platform.refinitiv.com/Apps/AdvFilings/FRS_GET?DocumentId=78170311&ContentFormat=pdf): Document request failed, Exception is Could not find file…
-
How to extract DV01 from 10 year US Treasury Yield curve using Eikon API? The data is on a page of R
-
Finding Investments in IT infrastructures
Hello Team, could you please help me on finding investments in IT infrastructures or similar about a company in the datastream navigator?
-
Sectoral FDI data for BRICS
Can we get the historical Data on FDI for different sectors in BRICS countries?
-
Is something happening with RIC 'PMNT.K'?
I am looking for very simple annual TR.CompanyMarketCapitalization data but I am encountering issues with PMNT.K, my Refinitiv desktop app freezes and the Refinitiv data python api throws an error code 416. Yet, the company seems to be regularly traded, and I cannot reproduce the same problem with any other RIC I am…
-
Not same fields available from .Net vs Python for get_history
Hello, It seems that we cannot query the same fields for historical prices from Python and .Net. We would like to query TR.TotalReturn in the .Net C# API as such : var response = Summaries.Definition(new List<string>() {"0001.HK"}) .Fields(new List<string>() {"TR.TotalReturn"}) .Interval(Summaries.Interval.P1D) .GetData();…
-
The problem if I don’t start python as an admin thet eikon redirects me to cfauth.com when authentif
When we don’t start python as an admin then eikon redirects me to cfauth.com when authentificating and not to localhost:9060 [2024-07-17 15:00:41,878;s] - [INFO] - [log] - Send GET request to http://127.0.0.1:9060/api/status to detect API Proxy... [2024-07-17 15:00:41,879;s] - [DEBUG] - [log] - Request to…
-
What are correct parameters to fetch historical data for provided fields in Ownership Summary data?
location=rd.get_data( universe=["GE"], fields=['TR.InstrStatLocationId.date', 'TR.InstrStatLocationId', 'TR.InstrStatLocation', 'TR.CategoryInvestorCount', 'TR.CategoryOwnershipPct', 'TR.InstrStatCatSharesHeld', 'TR.InstrStatCatShrsHldVal(Scale=6)'], parameters={'StatType': 3, 'SDate': "2024-05-01", 'EDate': "2024-07-01"}…
-
What are correct parameters to fetch historical data for provided fields?
Hi, I want to fetch the historical data for below fields. What is the correct way to fetch the historical data for a specified Date from history? Please find below the fields and code to replicate the results- fields =…
-
When will ESG scores for FY 2023 be available ?
Hey, my study is focus on the Germany companies who are in the range of MDAX, DAX, TecDAX index. But now the updated ESG score data are for FY 2022. Do you know when will ESG scores for FY 2023 be available ? Thousand thanks. Shirely
-
Tracking Error
I am trying to get the tracking error item ("TR.FundTrackingError1Year") taken from the data item browser over an extended period The code below just gives me the last available value for item "TR.FundTrackingError1Year". * Is there a way to obtain the time series? I think "TR.FundTrackingError1Year" is just a static…
-
What is PE PDP?
What is PE PDP in refinitiv terms pls explain with a simple example
-
I am trying to fetch the Current Month FX Rates from the Refinitiv using API's.
Hi, I am new to refinitiv. Currently i am using Datascope Select to fetch the daily FX Rates using Instrumental List and Scheduler. Now i am struggling to fetch the FX Rates based on the current month average price. Eg - If the current date is 2-Jun then it should send me 2 days average OR FX Rates of two days(average i…
-
Where can I find JSON file structure generated from TR chat through CFS
I'm importing TR chat/Refinitiv Chat and messages. I understand there is a shift from xml file to API through CFS. where can I find the expected JSON structure that will be generated?
-
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.
-
Time unit for news in the EIKON news monitor
I am searching for news in the EIKON news monitor, and I am in the Netherlands, I would like to ask what is the time zone displayed in the EIKON news monitor? I searched this forum and find the time zone by default is GMT when using EIKON data API, however, I am not sure the time zone by default displayed in the news…
-
Extract ESG scores based on ISIN codes
I am using Refinitiv Eikon Datastream in Excel. I want to extract the ESG scores of several companies I have collected in a sample, I have the ISIN codes belonging to those companies. How can I insert those ISIN codes in Datastream to extract the ESG scores belonging to those companies?
-
Migration from Raw Websocket to Refinitiv Data Python
I have been using Refinitv Enterprise infrastructure to consume data using the raw websocket interface The Login message I use in websocket interface is {'ID': 2, 'Domain': 'Login', 'Key': { 'Name': MY_APP_ID USER, 'Elements': { 'ApplicationId': MY_APP_ID USER, 'Position': MY_IP} } } As I am migrating to Refinitv Data…
-
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…
-
Executive compensation and performance data
Hi, can someone let me know where I can find the data regarding executive officer compensation and their performance matrix on Refinitiv workspace?
-
How to get the total returns (per actual week) of former constituents of the Belgian all Shares?
Hi, I'm working on a thesis about the Belgian stock market and for this thesis I need the total returns of all the former constituents of the Belgian all share index (all the way back to 2002 or 2004). I know where the find the list of leavers and joiners but I do not know where to find a time series of actual weekly total…
-
Retrieve historical bond yields for various maturities and governments
Hello, I am trying to retrieve the bond yields for various maturities per country (Germany, Switzerland, Netherlands). I am using the Eikon API in Python, Windows. Essentially, I want to derive the monthly Yield-to-maturity (YTM) for various maturities (1 month, 3 month, 6 month, 1 year, 2 year, 10 year, and 30 year) from…
-
I am being throttled by the usage limits for the Eikon Data API when I have played fairly
I am using the Eikon API with Python on Windows (with a desktop session). I am instantiating a historic_pricing.Definition class and calling .get_data() to retrieve a time series of hourly prices per RIC. query_definition = historical_pricing.summaries.Definition( universe=refined_rics, interval=interval,…
-
DPRM issues with Refintiiv Workspace product for Customer Managed sites
I would like to know on how to enable DPRM in Refintiiv Workspace product for Customer Managed sites. Unlike Eikon it appears in Workspace DRPM is not enabled by default.
-
Retrieve bond data from rd.discovery.search()
Hi! I am trying to download bond data by Refinitiv data API. Learnt from this post retrieve bond ISIN issued by a list of firm RICs - Forum | Refinitiv Developer Community, I write the code, which works well in the chat window in Notebook. However, I do not know how to export the results to excel. How I need to modify my…
-
python syntax to get changed RIC
Hello everyone, I recently faced the RIC changed issue, some companies changed their ticker symbol which leads my data retrieval and maintenance get in trouble. I'm seeking assistance in obtaining a list of RIC changes, such as FB.OQ --> META.OQ on June 9, 2022 KERN.OQ --> GRYP.OQ on Feb 2024 SASI.OQ --> NTRP.OQ on 13 MAR…
-
Code is to extract implied volatility data for multiple stocks/indices from Equity Volatility Surfac
Hi, Below code is to extract implied volatility data for SP500 index. However, I want to pull data for multiple stocks and indices for multiple time horizon using single run. How can I amend the code to do that? import refinitiv.data as rd from refinitiv.data.content.ipa import surfaces import pandas as pd import…
-
Verification for the data for these RICs.
Hi, I treid to get the data for these RICs with 2 different functions. However, when i get them with get_data() function it says 2021-06-21 So, I just wanted to check if it is correct and if it is not, which function do i need to use to get correct data? RICs : MPB-DEBRE-TOT , MZN-DEBRE-TOT Functions : get_data(),…
-
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…
-
constituent bonds of a certain CDS
How to retrieve the constituent bonds of a certain CDS through python API?
-
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…
-
Refinitiv.data proper fields names
Greetings, I am currently involved in a project aimed at retrieving the closing price for companies that have been delisted due to bankruptcy, specifically the day following their bankruptcy announcement. The primary methodology I employ involves checking whether 'TR.MnAHasBankruptcy' is true. If this condition is met, we…
-
"TR.PPBankruptcyFilingDate" data field.
Greetings, I am currently involved in a project that necessitates the retrieval of data pertinent to delistings. For this purpose, I am utilizing the 'TR.MnAHasBankruptcy' and 'TR.PPBankruptcyFilingDate' fields to ascertain whether a company has filed for bankruptcy. However, I have encountered an issue wherein the…
-
Get all bonds from one issuer
Hi, is it possible to get all the bonds from one issuer please? I found out that for getting Issuer name from ISIN this code is working `ek.get_data(['XS2552369469'],['TR.FIIssuerName'])` but I cannot manage to make it other way around. Any help will be appreciated! Thanks!
-
Backend error. 500 Internal Server Error 2024-03-21 19:04:04,440 P[10260] [MainThread 16960] HTTP re
Good afternoon, how are you? I am writing because I am using the get_timeseries() function with the following parameters: df = ek.get_timeseries(["PAM"], start_date="2024-03-19", end_date="2024-03-20", interval = "tick") At certain times of the day it works for me, and at many other times I get a 500 error. 2024-03-21…
-
using screenr with rd api
when I use the code below I get this errors: raise RDError(-1, except_msg) refinitiv.data._errors.RDError: Error code -1 | Unable to resolve all requested identifiers in ['SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), BETWEEN(TR.MnAAnnDate,20200101,20200108)/*dt:Date*/, CURN=USD)']. #start_date start_date="20200101" #end_date…
-
is it possible, using the API that the database provides, to Download the Documents & Notes related
I am fairly confident in downloading data related to green bonds, but I can't figure out if there is a way to also be able to download other data related to other areas of the bond interface to the database. I can't find any tickers or indicators that I can plug into python. I need to know if, in this case, downloading…
-
Workspace is all blank (both App and Web ver.)
I have encountered an issue with the Workspace today; neither the app nor the web version seems to be working (please refer to the attachments). Is there any scheduled system maintenance for today? or any one face the same problem?
-
AttributeError: 'NoneType' object has no attribute 'head'
Running scripts 2024-03-13 16:44:55,998 P[33204] [MainThread 648] Init a Desktop session with new app_key 2024-03-13 16:44:55,999 P[33204] [MainThread 648] entity: DataGrid_StandardAsync 2024-03-13 16:44:55,999 P[33204] [MainThread 648] payload: {'requests': [{'instruments': ['0#.SPX'], 'fields': [{'name':…
-
I would like to know the type of APi in Eikon
I am currently working on an application that uses chatGPT and Eikon's API to retrieve and summarize news. However, when I try to retrieve news from Eikon, I get an error and cannot retrieve the news. I have also heard that an API to retrieve news could solve the problem, as there are limitations to retrieving news,…