-
How can I obtain the Debtor Domicile from fixed-income funds using the Refinitiv Data API?
In the workspace, there is a section with the summary holding > debtor domicile, for fixed income funds, like TIP, it shows country and the allocation in percentage. How can I retrieve this data? I couldn't find any data item that links to this specific information: ```python df = rd.get_data( universe=['TIP'], fields=[ #…
-
Index constituents items in Data Item Browser (DIB)
Hello, I am trying to get some index constituents details of some indices using Eikon data API. I can get some basic data using "TR.IndexConstituentxxxx" items like the query below. However, I cannot find these fields using DIB in my Workspace. There is no item if I search using "TR.IndexConstituent". If I type…
-
Computstat Item Names in Refinitiv
Hello, is there any list of what the Compustat items are called in Refinitiv? I need the items Investments and Advances (32) and Debt in Current Liabilities (34). Thank you and best regards
-
Can't retrieve fields visible in DIB using Eikon Data API
For some instruments such as LU1649332886, the DIB shows that the TR.NETASSETVALUE field has data, but when using a get_data request on both the Lipper RIC and the ISIN, the series isn't retrieved for either. I've experienced similar issues with other instruments. Is there a reason this is occurring? Thanks in advance
-
Data Item Code for "US GDP Final*"
I want to extract data on "US GDP Final*" using the eikon Data API. How can I find the corresponding instruments, fields and parameters? I tried with Data Item Browser, but I didn't know how to search.
-
Can python to download TR.YieldtoCallDateAnalytics & TR.DiscountMarginAnalytics?
Hi team, Can python to download TR.YieldtoCallDateAnalytics & TR.DiscountMarginAnalytics? If so, could provide sample code. If no, is it any workaround it codebook? thanks. Regards, Sunny
-
How to find data fields for python api? Data Item Browser and Formula Builder are incomplete.
The api docs direct us to either the Data Item Browser (DIB) or the Excel add in to discover the fields and parameters available for use in the api (specifically the get_data method). However take for example the field "TR.IndexConstituentRIC" which frequently appears on this forum, I cannot find this field in either the…
-
data item browser cannot open (Mac)
Hi, My data item browser cannot open all the time like this. Could you help me to fix?
-
Data items to get historical prices using ISIN for multiple asset classes
Hi, I'm currently trying prices = ek.get_data(codes, ['AVAIL(TR.PRICECLOSE.date,TR.FIPRICE.date,TR.NETASSETVAL.date), AVAIL(TR.PRICECLOSE,TR.FIPRICE,TR.NETASSETVAL)'], {'SDate':'2020-10-01', 'EDate':'2020-10-05'}) to get historical prices for equities, bonds, etfs and funds. Above codes is an array of ISIN codes. All I get…
-
Data Item Browser is not working
Until recently, the data item browser from the Eikon API Proxy worked perfectly fine, however, today I am not able to retrieve any information of data fields with the data item browser because it starts loading but does not show anything. The connection is working because when I am searching for instruments the pop-up…
-
EIKON API Proxy on MacOS : DIB keeps loading
Hi, I have an issue since yesterday On my Eikon API Proxy on MacOS. The DIB keeps loading and I can't search for any data items Thanks for your help, .
-
How to get all Eikon Python API fields into an excel spreadsheet?
I am looking for a way to get all Data Item Codes (e.g. TR.VWAPVOLUME) into an Excel spreadsheet. I am aware that the Data Item Browser contains all Data Item Codes. I am looking for a way to consolidate all fields in an excel spreadsheet for programmatic use.
-
Further documentation on TRDPRC_1 and related formulas.
Hi, I would like to know where I can find a deeper description on TRDPRC_1. I'm aware, according to the Item Data Browser info, that related factors to TRDPRC_1 are SALTIM (which gives you time of such trade) and TRADE_DATE (which gives you the date of such trade, complementing the info of SALTIM). Do you have…
-
Extracting related securities from all quotes app
Hi all, Any ideas on how to get the related securities / primary RICs for equities using the api? It doesnt look like there is a DIB field either. Thanks, Danny
-
Individual estimates not matching series
Hello Eikon QA,I seem to have some consistency problems when im retriving data (TR.PtoEPSMeanEst and TR.FwdPtoEPSSmartEst) from the API individually, as a series or from the data item browser. For example: Retrieve all in a single call as a series: df = ek.get_data('AAPL.OQ', ['TR.PtoEPSMeanEst'],…
-
Eikon Data API timing out on every request this morning
Starting around 3 AM today the Eikon Data PI stopped returning us any data, giving the below timeouts instead. My Data Item Browser (e.g. MSFT.O DIB) this morning is also not retrieving any data. Eikon Data API is giving back timeouts for every request, even a simple one like: In [9]: ek.get_data('MSFT.O', 'TR.Ric')…
-
Returned values using PermID is different from using orgID
Hi all, I wanted to retrieve the employees of the company Claire's INC, when I type employees in the Data Item Browser it advises me to use the field 'TR.PCFullTimeEmployees'. But for my surprise if I use python to get the data and using the orgid as instrument I do not get anything. On the other hand, if I use permid I…
-
Why are there fields visible in data item browser that are not accessible via Eikon Data AP?
I am running Eikon API Proxy on Mac, version 1.0.102. For many fields I can see values on the data item browser (for bonds) like CF_BID, or TRADE_DATE, but anytime I query for these fields using Eikon Data API in Python, they never get retrieved, only returning None values. Why am I unable to retrieve these…
-
Would like to classify all funds the same ie: Exchange Traded Funds (ETFs) , Mutual funds etc. What
I would like to access a field which classifies the different types of funds into their 'Asset Type' such as Equity, Bond, Mixed - as depicted in column: GN_TX20_15 in the attached screenshot. Unfortunately it seems ETF's do not subscribe to this data point. Therefore I am enquiring about what data points can be used to…
-
Data Item returning NaN.
Hello, I am using the python eikon API, and the Data Item browser to get the code to do my queries, although when requesting the following TR I am getting NaN as a return, which is weird because I can see the value on the Data Item Browser but when making the request from python I get NaN. Example of my code (all the…
-
How to retrieve Minority Interest
hello there, Is there a way to retrieve the minority interest for a certain instrument? I can see TR.TotalEquityAndMinorityInterest but not minority interest on its own, does this data item exist? if so, what name does it have? Thank you for your time
-
TR.EBITDA vs TR.NormalizedEbitda vs TR.EBITDAActValue
Hello, Im checking for AAPL.O with the python API and i cant understand the difference between these 3 data item codes for EBITDA. They all report pretty much the same number, and the description is pretty much the same too, so what is the difference? TR.EBITDA and TR.NormalizedEbitda are exactly the same?…
-
Is it possible to get macroeconomic indicators with an API?
I'm trying to automate some of our queries, which are mostly on indicators like GDP growth. I can get this data in Excel, as well as the stand-alone Eikon App, but because I am most familiar with Python, I would like to download it with Python. I found these as instruments in Data Item Browser, but did not finde any Data…
-
Find field for SUE (Standardized Unanticipated Earnings) in Data Item Browser
In the Estimates Glossary, I noticed there is a field called SUE (Standardized Unanticpated Earnings). I am trying to find this field in the Eikon API Proxy - Data Item Browser, but I can't find it. What code should I use to download this data through the API?
-
Parameter value within the Eikon Proxy Data Item Browser doesn't load
Following tutorial 2 within the Eikon Scripting API, the tutorial suggests to find out more information within Data Item Browser. In doing so, I pulled up the specific function TR.IssuerRating that is referenced within the tutorial and noticed one of the parameters doesn't completely load. As a result, I am unable to…