The most recent content from our members.
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…
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…
...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
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…
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:
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.
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…
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…
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…
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…
It looks like you're new here. Sign in or register to get started.
