-
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.
-
Optimizing Eikon API Calls for Retrieving Fundamental Data
Hey everyone, I'm working on a project on a codebook workspace where I need to pull a lot of fundamental data(322 fields) for various companies using their RICs via the Refinitiv Eikon API. The problem I'm facing is that the process is taking way too long, and I'm frequently running into gateway timeouts (Error code 2504).…
-
Aggregating historical fundamental metrics by ETFs/Index through Refinitiv API
Hi guys, I would loke to know if there is a smart way to get time series for valuation/fundamental data at etfs/index level. The only way I found for now is to pull the historical weights and the fundamental/valuation data for each stock and then to aggregate manually, but this is - as you can imagine - not so clean, as…
-
Data Library for .NET not working for RDP API company fundamentals
The client is using the Data Library for .NET (or RD Library for .NET). Please advise on the below query they are facing when trying to access the Company Snapshot and Pricing Streaming using the Data Library for .NET. It includes the Refinitiv.Data.Content.Data.FundamentalAndReference request. However, using this request…
-
Missing data for SP500 using fundamental_and_reference.Definition get_data
Am looking to download the following fields (list below) for SP500 index constituents, from 1995 to yesterday, daily data. Am using the following import refinitiv.data as from refinitiv.data.content import fundamental_and_reference import datetime rd.open_session() growth_fields = ["TR.EPSMeanEstLastToNextYrGrowth",…
-
Download single contributor IBIS python api
Hello! I am working with the python API to get IBIS estimation of financial statements for some companies. In the codecreator, I can find information about the mean. However, I am interested in the distribution of forecast instead of one single indicator. For instance, I am interested in General Motors (GM) historical…
-
Issue to retrieve RICS list for a given bond using Refinitiv Data under C#
Dear Developer community. i'm facing an issue to retrieve Ric list for a given ISIN by using Refinitiv Data (version beta4) under C#. Indeed, i'm used to retieve this list using TR.RICS field with Excel and also Python (as shown below), but it doesn't work when using FundamentalAndReference module under .Net and i have no…
-
Income statement irregularities from data API
Hello - when running the following screen, through the refinitiv.data Python API a few anomylies come up, and I hope you could help me understand why these are happening. You can see my code down below that's giving rise to these questions. * The column for asset turnover is coming out blank. However, when I run this…
-
Is there a way to find listed pre-profit companies in any one index in Python?
Is there a way to find companies listed pre-profit (0 or negavite EBIT) in any one index in Python?
-
Discrepancies/Errors between Python API and Refinitiv Eikon Data (Daily Errors)
Please see "Discrepancies/Errors between Python API and Refinitiv Eikon data" for previous explanation of issue. This is an issue that I have been trying to resolve with the Reuters Customer Support and Development Community for over a month now. Here I am providing a compiled list of today's errors that I found. I see a…
-
How do I download Fund Shareholder's History report of a company ? The data we get when we go to "Ow
Kindly help me with this issue which I am facing for the past 2 days. Your help would be appreciated. I cannot find it on the EIKON tutorials as well. Thank you.
-
Point-in-time or look-ahead bias?
When I retrieve data through Python API by referring to fields such as TR.PriceToSalesPerShare or TR.F.ReturnAvgComEqPctTTM getting both date and value, is it point-in-time data? That is if the data is retrieved e.g. for 2019-12-31 does it take into account only the reported financial data (like sales, earnings or equity)…
-
Retrieve financial data of companies trading on other global exchanges
Can I retrieve financial data of companies using TRKD fundamental API "Get Financial Statements Reports"/ Example: NARI Technology Development is a Chinese company that trades on the Shanghai Index (SHA) - symbol is 6004060 Alrosa is a Russian company that trades on the Moscow Index (MCX) - symbol is ALRS How can I…
-
ROIC Data: DFO code vs. Eikon Code
Dear community, Historically when pulling ROIC data through Datastream we would use the code WC08376 for Worldscope Fundamentals. We were made aware that Worldscope is not available on the Eikon API. What is the best Eikon Code to get the standard definition of ROIC as described below: Return On Invested Capital All…
-
What is the difference between the fields "date" and "Calc date"
When requesting the data for Market Cap of some assets, I am seeing some differences between the two fields (date and Calc date). What exactly means each of the fields? The code I used is shown bellow: data = ek.get_data(assets, ['TR.CompanyMarketCap', 'TR.CompanyMarketCap.date', 'TR.CompanyMarketCap.calcdate'],…
-
how to get historic fundamental-financial data for more than 6 years using TRKD api
@wim.ooms, while searching answer for this question I came across query-7638. It says that "GetFinancialStatementsReports_1" provide the mentioned data. Could you please let me know how we can run this API on the webpage here.…
-
How to get quarterly fundamental-financial data in TRKD api
We want to retrieve company fundamental-financial data on quarterly basis. Current we are using "GetFinancialStatementsReports_Request_1" method of fundamental api but it provides data only for last 6 years on annual basis/ CATALOG --> FUNDAMENTALS --> GET FINANCIAL STATEMENTS REPORTS
-
parse RKD fundamental api data from json to pandas dataframe
Hello Team, I am facing problem in parsing RKD fundamental api data from json to pandas dataframe. Code: appid = "" token = "" # input_1 : appid and token # RKD api request message headers message_headers = { 'content-type': 'application/json;charset=utf-8' , 'X-Trkd-Auth-ApplicationID': appid, 'X-Trkd-Auth-Token' : token…
-
How to get Total Revenue with Dates?
I am trying to get the FY2019 Revenue data for the below list of stocks. I used the following code. data,er = ek.get_data(ric_code, ['TR.Revenue(SDate=2019-05-03,EDate=2020-02-07).Date', 'TR.Revenue'], {'SDate':'2019-05-01','EDate':'2020-08-04'}) I am getting NA values back. Can you also direct me to the docs/tutorials…
-
ROCE calculation for last 4 quarters
Return on invested capital is defined as ebit/(total current assets - total liabilities). TR.ROCEActValue(Period=FY0) yields for apple However the end date of this period is now almost one year ago. Apple's 3rd quarter results were presented on July 30th 2020. Meaning that this number is out of sync for 3 quarters now. If…
-
Is is possible to retrieve finacial data based on PermIDs via Eikon Data API ?
A client is asking wherever it is possible to retrieve fundamental data via Eikon Data API based on PermIDs instead of RICs as many privat companies don't have a RIC assigned? Here are some examples of where it didn't retrieve data (5069470958, 5040052832, 5000216411) Many thanks!
-
GetStandardFinancials_Request_1 Historical data (TRKD API)
Dear All, how are you? I´m trying to get the historical fundamental information using the GetStandardFinancials_Request_1 in postman, but i'm unable to get the results due to this error: { "Fault": { "Code": { "Value": "s:Sender", "Subcode": { "Value": "a:Gateway_Validation_RequestError" } }, "Reason": { "Text": { "lang":…
-
Get business summary operation (fundamentals service) with json body
Hi everyone! I have a problem with Fundamentals Service (TRKD Api) I need to consume GetBusinessSummary_1 service with json body. On TRKD site it just shows XML request, and I'd like to consume it with the json body. Does anyone know if this is possible? Please let me know if someone has already done that and what is the…
-
Historical fundamental data with EIkon Python API
I am looking to extract fundametnal data for a ferw companies. I am using the following code: start_date = '2015-01-01' end_date = '2019-01-01' field = ['TR.TotalRevenue','TR.TotalRevenue.date','TR.TotalRevenue.periodenddate','TR.BSOriginalAnnouncementDate'] ric = ['AAPL.O','MSFT.O','BA'] params = parameters={'SDate':…
-
How to retreive SIC codes via Eikon Data API?
So far I have searched for the data item via DIB and formula wizzard quite extensively. I have found NAICS, TRBCs and several else but no SICs. Have I missed it? How can I retrieve it via Eikon Data API?
-
How to get LTM value for item TR.TotalRevenue?
I am trying to retrieve data for the company Allianz (RIC: ALVG.DE). In Eikon i can easily find the latest reporting quarterly and semi-annualy and there is also a TTM value of 101.128 as you can see in the below image. I am trying to retrieve this value using the following command: ids = ['ALVG.DE'] fields =…
-
We are trying to extract fundamental fields from eikon API to come in a specific format per screensh
-
Reporting frequency for Fundamental Data
I am interesting to extract the reporting frequency of fundametal data. For example, for apple i would like to get the output Quarterly as the company reports quarterly data. How could I get this value?
-
How to extract quarterly fundamentals data
I would like to extract quarterly values for the field totalEquity for Apple usnig the Python eikon API. I currently have the following function: temp_data = ek.get_data('AAPL.O',['TR.ISOriginalAnnouncementDate','TR.TotalEquity.periodenddate','TR.TotalEquity'],parameters={'SDate': start_date, 'EDate': end_date}) But i only…
-
How to retrieve data about firms' major customers using the Eikon Python API?
I would need to get data about major customers of multiple firms. Is it possible via Python API? Would be also helpful if availability of major customers data can be used as a screener parameter. I only found from the data item browser a data field of TR.PECompanyCustomers but I assume that is not correct one. Here is an…
-
Annual Geographic by Segment in Millions of U.S. Dollars
HI, I would like to extract the information on segment breakdowns : Annual Geographic by Segment in Millions of U.S. Dollar. This is available and exportable from eikon to excel. Has anyone tried this ? Thanks, Takaya
-
optimal handling of DS_DE_NULL_ERROR
Sometimes when we get fundamental data via the Dex2 API, we get DS_DE_NULL_ERROR back, usually with either the text "Asynchronous Query library internal error" or "Server response is not valid." This happens seemingly at random, usually after at least a minute has passed-- possibly a timeout from upstream. Usually when we…
-
WorldScope Fundamental Dates
Hi, How can we request Worldscope data that is connected to companies' report dates or period end dates? When I make requests, I am getting data with dates that do not match the financial periods (see example below). Thanks. request: ds.get_data(tickers='<AAPL.O>, @FB', fields='WC01001A', start='-4Q', freq='Q') response:…
-
Get all RICs where fundamental data has been updated
Assume that I have a list of RIC identifiers. How would I go about finding all RICs within that list that had their fundamental data, i.e. TR.Revenue updated yesterday. Would you get TR.Revenue.periodenddate for all RICs in my list and then comparing them daily to the new set and extract the ones where…
-
Eikon API Income Statement Original Announcement Date and TIME
Hi I am trying to get the precise date-time of an Income Statement report via Eikon API. If export directly, I can see that the "Original Announcement Date" includes a time, but when retrieving via spreadsheet or python API via the "TR.ISOriginalAnnouncementDate", there is only a date without a time. Does anyone know how…
-
Retrieving detailed fundamental data from API
I am looking to download as detailed financial data as possible from the API. However, the terminal provides more details than the get_data() function. For instance, looking at the Income Statement in the “As reported” view in the terminal for Ericsson (Ticker: ERICb.ST) I get 4 items of Impairments (see attached file).…
-
Eikon Python API: most recent data are missing
I try to download common shares outstanding using the following code, and find data are not available for the most recent quarters, whereas they are available from EXCEL and Eikon Web App. tickers = ['GOOG.O'] start_date = dt.datetime(2000,1,1) end_date = dt.datetime(2017, 12, 29) date_format = '%Y-%m-%d' parameters =…
-
Python code Industry Classification TRKD
Hi Community, Does anyone have a sample python script to select INDUSTRY CLASSIFICATION from TRKD? Best, Andrew
-
Historical time series fundamental data in Eikon for stocks in a similar sector both dead and live
I am wondering how to get time series historical data on fundamentals (return on assets) for companies listed on the Johannesburg stock exchange and operating in the mining industry both active and dead stocks. I am using Eikon within excel and it would help if the data goes into one excel sheet.
-
Is it possible to pull history on non-price/volume fields such as TR.EPSActValue? get_timeseries API
Is it possible to pull history on non-price/volume fields such as TR.EPSActValue? get_timeseries API only seems to cater for price/volume data and the get_data API doesn't accept start and end dates.