-
How to filter ownership data using the Eikon Formula Builder?
Hello, I am using the following formula to extract ownership data in Excel: =@RDP.Data(A2:A1000;"TR.InvestorFullName;TR.InvestorType;TR.InvInvmtOrientation;TR.PctOfSharesOutHeld;TR.OwnTrnverRating;TR.InvestorTotalAssets";"SDate=#1 CH=Fd RH=IN";E4;$D$1) However, as I am trying to analyze a large number of companies over…
-
How to use formula builder beta in Excel to retrieve previous day's settlement price?
Hi! I'm trying to import the previous date's settlement price for different commodities futures (I believe the data item is STL), but I don't see that on the data items list. Is there a way I can pull the previous day's settlement price into Excel? I'm able to retrieve the current day's settlement, and I want to be able to…
-
for US stocks i am trying to get the call and put option prices for at the money strike at any given
for US stocks i am trying to get the call and put option prices for at the money strike at any given time ...how can i do that
-
How to get ownership percentage panel data through formula builder?
I want to draw a variable on the percentage of shares held by the largest shareholder at FYE for a panel sample through the excel formula builder but I could not find a variable yet that gives me this information and that I can get the panel data for. So I wanted to ask whether such a variable exists and if so, what the…
-
How can I use python to get issued bonds of an issuer for a given issuer's Ticker?
For example, I want to get the bonds issued by BABA, I can use Advanced Search app or debt structure of BABA to see the results on eikon workspace, but how can I get those bonds by python eikon api? the results are just like the picture shows:
-
How can I build Excel formula to find financial data for specific firm
I need to collect financial data such as Total Revenue, ROE, etc..., for at least 15 years for only specific firms using Excel formulas like the table below.
-
Fetching "Time Series Data Items" - TR.NUMBEROFSHARESOWNEDBYFOREIGNINVESTORS
Hi guys, I have a question regarding the following Data Items: "TR.NUMBEROFSHARESOWNEDBYFOREIGNINVESTORS" "TR.FOREIGNTODOMESTICHOLDINGRATIO" which I want to fetch over the Eikon Data API. It seems that even in Excel I always get an empty response (NULL). Why is that? What do I have to specirfy? Does this data item behave…
-
Data download structure with Eikon's Build Formula VS Datastream in Excel
I would like to ask the following question. I am downloading data for the last 10 years for all companies that have ESG data. Using Eikon's "Build Formula" function, I have been able to download the ESG data and part of the economic-financial data. This download shows me the data as shown in the first image. I would like…
-
hi i would like to have the relative dates of each row
Dear community, I am trying to retrieve yearly data (fiscal year) using this Excel formula: =@TR(Tabelle1!$B$3:$B$318,"TR.TotalReturn........[other parameters]...","Period=FY-1 Frq=FY SDate=0 EDate=-10 Curn=USD CH=Fd RH=IN"). and this is the result Total Return ..... KEPL3.SA 70.7614344 ..... KEPL3.SA 32.5659314 KEPL3.SA…
-
ek.get_data correct date with multiple fields
Hi, I have the following call in excel: =@TR("IAG.AX","TR.IssueMarketCap(Scale=6 ShType=FFL), ((TR.FreeFloatPct)/100), TR.IssueSharesOutstanding(Scale=3), TR.CLOSEPRICE(Adjusted=0)","SDate=2020-10-27 EDate=2020-12-01 Curn=USD CH=Fd RH=calcdate") I repeat to make this same call in: ek.get_data However I want in the return…
-
How to get Bloomber ticker and address of any fund?
What's the Eikon formula (TR.) to get Bloomber ticker/id and address of any fund?
-
Stability issue using VBA to update Eikon formula
Hi all, I am having a stability issue in my excel when I use VBA to refresh Eikon formula. I often use one formula for 3000 companies at a time, such as '=TR($B$9:$B$3100,"TR.PriceClose","CH=Fd RH=IN",E8) For Price data, such as TR.PriceClose, using VBA to refresh it is very stable. But for financial statemant data, such…
-
Get RIC or ISIN from company name
Using EIKON with Excel, i want to retrieve either RICs or ideally ISINs for a large number of companies. Now, what I could do is using the "build formula" tool to get the codes manually by typing in the companies' name and selecting the right one from the search suggestions, usually the top hit. I would like to automate…
-
Data retrieval is not unique
Dear all, May I kindly ask for you help? I am using the following formula to retrieve equity assets of a single perm ID(5000030092): =TR($B$4,"TR.TotalEquityAssets","Curn=USD SDate=2021-12-31 CH=Fd",$C$3) The formula specifies the date, but the resulting output is a column of numbers, not a unique number.. Could you please…
-
Excel formula builder: only 1 data point retrieved
Hi, I am attempting to retrieve pricing data between 2016-2021 for all constituents of the Euro STOXX 600 index using Formula Builder in Excel. The formula appears to work but only returns one result. I have also tried retrieving pricing data for the same time period using one individual stock with the same issue…
-
How to download multiple funds data in excel (lipper code)
Hello, I'm currently using the "build formula" option with the refinitv excel addin because I'm trying to download data from different funds. Is there a method, having all the Lipper code, to download everything I need (Rolling performance) just in a single excel file from ALL the funds? My specific aim is to download the…
-
Refinitiv add-in excel (Mac) creates formula but does not give any result
Hi, When I create a formula on excel (Mac) with the formula builder, it creates the formula but I do not obtain any result (even while pressing enter or refreshing). Did it already happen to you ? how can I obtain results ? Thank you for your help
-
Return formula from day x to day y
Dear Friends, I am building an excel database, where I have the date of IPO of more than 1000+ companies and I am interested to find the return after 365 days from the initial public offering. Example what's the stock return of company x which has IPO on the 1st of january 2015 to january 2016. This is what I am building.…
-
what does the "include active only" in formula builders instrument advanced search mean?
When using formula builders advanced search for instruments, you can tick in a include active only box. What does this mean and what does it do?
-
What does NULL mean?
I'm trying to get specific funds monthly NAV values and tried getting the data by the TR.FundNAV function. I get some values, but mostly NULL values. What does this mean? What can I do about it? Should I use time-series or real-time and fundamental when I'm trying to get a hold of the monthly nav values?
-
Historical company guidance data
Hi, I have a few questions: 1) Does Eikon have historical earnings guidance data before 2003 available. I am asking because for many companies, the earliest guidance data you get is from 2003. If it does, since when is the data available and what is the best way to access it? No I have done TR searches for 'Company…
-
API Formula for Historical Holdings ETF.
"TR.IndexConstituentRIC" which can be used to get underlyings of index or ETF. It has parameter of as-of-date which can get history constituents for index or ETF. I used it for an ETF list with specified date but for some ETFs it gives empty result. Does it mean this item is not suitable for ETF underlyings or holdings?…
-
Primary Instrument/Quote/RIC question.
If TR.PrimaryInstrument tells you if a security/or a number of them is Primary and that TR.PrimaryQuote is all about the RIC that has the biggest Market Cap, then what does the outcome of TR.PrimaryRIC is all about? What differs the last one from all previous 3? Thanks in advance!
-
Confusion about primariness.
I want to check if a RIC is a primary instrument. For that, I usually use the formula TR.IsPrimaryInstrument (with a boolean output). Let's suppose I use this RIC: 00XJ.F, the outcome for this ticker and TR.IsPrimaryInstrument is 'true'. But, when I use TR.IsPrimaryInstrument for a similar RIC (00XJ.DE) I get back that it…
-
I have a list of excels in R with eikon formulas. I need to open and refresh them with Rstudio inste
I have a list of excels in R with eikon formulas. I need to open and refresh them with Rstudio instead of open each of them. How can I do it? thanks
-
Alternatives to TR.FundType
Are there any alternatives to TR.FundType? I alredy tried FUND_TYPE and it doesn't work for me. I also tried a comparison between TR.FundTypeID, seeing if we could have an unique match between the available tags in TR.FundType but judging from what I saw that's not possible. Any suggestion is highly appreciated!
-
Checking for general availability on TR Formulas.
Is there any way we can check the availability for some TR formulas? Let's say for something like TR.FundType. Is there a way to track the availability of that and other factors throughout history within Eikon? For example, if I request TR.PriceClose or returns I'm sure I'll get an almost entirely populated data request…
-
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…
-
TR.FRNFormula field does not return date through eikondataapi
I am not able to get date for the field TR.FRNFormula while it is returned through excel. I try different parameter set with RH:D but it has no impact on the result return. My C# code is the following: IEikon eikon = EikonDataAPI.Eikon.CreateDataAPI(); eikon.SetAppKey("xxxx"); Frame<int, string> frnformula =…
-
What parameters to use in ek.get to specify the date when using TR.FundNAV data item?
I was previously using the field TR.NETASSETVAL which stops population CRUD.L after the 3rd of May. In python API, the Formula I was using: ek.get_data(['CRUD.L','USO'],['TR.NETASSETVAL.Date','TR.NETASSETVAL', {'SDate':startDate.isoformat(), 'EDate':endDate.isoformat()})[0] I am now using the formula below but results are…
-
How to download private equity investment data to Excel?
I would like to retrieve the sums of private equity investment amounts up to a specific date for a large number of companies from Eikon to Excel. Is there a way to automatize this by using formula builder and companies´ RICs in Excel? Thank you!
-
How can I download price history data in 5 minutes intervals for several stocks from EIKON using the
How can I download price history data in 5 minutes intervals for several stocks from EIKON using the formula builder in Excel ? I can somehow only select daily data