-
How to pull monthly financial data from January 2010 to December 2023 for approximately 8,000 ISINs
We aim to collect monthly financial data from January 2010 to December 2023 for approximately 8,000 ISINs for the following three variables: Total Number of Shares Outstanding Price-to-EBITDA per Share Price-to-Book per Share
-
Pull financial data by PermID
I can retrieve historical financial statement data with refinitive.data.get_history funciton by specifying universe with oa_org_permid from DataScope bankloan database. However, for a public company like Alphabet, using the parent company's PermId returns nothing, while using GOOG.O can retrieve all the financial data. The…
-
How do you pull data for entire balance sheet and the financial statements for a stock
Case 15264025 How do you pull financial statement, balance sheet data for individual companies, i.e. stocks. So, if I pick a random company like Google. How do you pull data for their balance sheet, I want to be able to pull the balance sheet data, in python Just need an example, so I can pull the entire balance sheet and…
-
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!
