-
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 gi...
...ven time ...how can i do that 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…
-
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…
-
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?
-
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
-
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…
