-
Why is the fperiod not properly aligned with the values?
I'm having problem when downloading financial income data. For this example in the code below, the "Financial Period Absolute" (fperiod) is not properly aligned with the true financial data. We can see that on "TR.F.OperProflnOpCASR | XEBT", there are 2 values on FY2024Q4, but it should be one value for FY2024Q4 and…
-
Im having trouble with missingquarter data for several American companies, including AAPL.
data retrieved with: df_standard, err = ek.get_data( instruments = ['AAPL.O'], fields = ['TR.F.IncomeStatement.fieldname','TR.F.IncomeStatement','TR.F.IncomeStatement.date','TR.F.IncomeStatement.FCC'], parameters = {'Scale': 6, 'SDate': 0, 'EDate': -30,'Period':'FQ0', 'FRQ':…
-
Bond issuers income statement data download
Hello everyone, I am trying to download financial information regarding bond issuers, starting from a series of bond ISIN codes. The query I am using is the following: rd.get_data( universe = ISIN_list, fields = [ 'TR.RIC','TR.NACEClassification', "TR.DTSubjectName", "TR.FIIssuerName", 'TR.FiOrgID', "TR.F.TotRevenue",…
-
how to get balance sheet item value from financial-statements API in RDP
Given concept code, where can i find the item value of the concept code? please give an demo of a concept code.
-
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 =…
-
How can I get the information on the methodology used by Refinitiv for volatility calculation of ...
...stock price of companies? I went through the equity segment. I was looking for volatility time series of few companies. then I find it in the price and chart section. There are many volatility measures, like Volatility O-H-L-C, Historical Volatility, Volatility (Chaikin's) etc. I am going to use the data in my study,…
-
How to *exact match* on company name in Eikon/Python
I am using Spyder in Windows with Eikon API. I am trying to extract information on companies using their company name. My personal data of both inactive and active public and private companies, through which I'm trying to match company names, does *not* have RIC, PermID, or any other corresponding code. All it has is the…
-
Downloading Complete Financial Statements from the Main Market of a given EU stock exchange (prec...
...isley Polish Stock Exchange GPW w Warszawie Main Market PTCs) Hi, I am wondering whether I can and how can I download Annual Complete Basic Financial Statements (Annual: Balance Sheet, P&L/Income Statement , Statement of CF, Changes in Equity, if in refinitive ESG especially G data is available, then I'd like it too,…
-
Problem retrieving data for a RIC with Python eikon API
Hello, when i run the blow code it returns NA On the platform the ticker has the financials i am trying to download. Any reason why? df, err = ek.get_data( instruments = ['TNB^E12'] , fields = ['TR.TotalCurrentAssets.Periodenddate', 'TR.TotalCurrentAssets', 'TR.TotalCurrLiabilities', 'TR.TotalLongTermDebt',…
-
Downloading financials by industry
I would like to download the financials of companies in a certain industry, is there any automatic way of downloading them onto excel or should I manually download the financials of each and every company? I'm using refinitiv eikon.
-
How to download private firm financial data with Datastream?
How to download private firm financial data with Datastream?
-
Hi developers! could you kindly give a piece of advice? What is the correct way to build a reques...
Hi developers! could you kindly give a piece of advice? What is the correct way to build a request in DSWS in order to get the latest available published financial statements of companies? How should the fields "Start" and "End" be filled in? Thank you!
-
list of bankrupt companies & balance sheet/ income statements of a specific year
Hello, I must compare KPIs of companies which went bankrupt against companies which didn’t go bankrupt. The companies have to be listed on a stock exchange. I am able to retrieve a list of companies, which are listed on exchanges of a specific country as follows: exp = 'SCREEN(U(IN(Equity(active,public,primary))),…
-
Financial Data: Liabilities Source from Informal Lenders
Hi, I'm new to the forum and I'm asking to Datastream and Eikon Database. Is it possible to download Liabilities financial data, divided by Lenders? More specifically, I need to download Liabilities from "Family and Friends" for SME companies. Thanks in advance, Luca.
-
Refinitive API ConnectionError: HTTPConnectionPool(host='api.trkd.thomsonreuters.com', port=80):...
... Max retries exceeded with url: /api/Fundamentals/Fundamentals.svc/REST/Fundamentals_1/GetFinancialStatementsReports_1 Hi Refinitiv team, We are presently working to pull Response JSON from some Fundamental APIS. Where we are facing issues, Please find below issue :ConnectionError:…
