Hi, Can you please let me know how to change the date to trading date in Excel? I have searched everywhere now and would really appreciate the direct help. The formula below gives me 262 days.…
Hi, I am using the following script to download tresury yields. TESOROS = ['US2YT=RR','US3YT=RR','US5YT=RR','US7YT=RR','US10YT=RR','US30YT=RR'] start_date = "2000-12-12" end_date = "2024-12-31" ts_tes…
Hi, I am trying to download headlines data with the ek.get_news_headlines function. Yet, I am running into the error: ValueError: Parser must be a string or character stream, not Timestamp when passin…
Unfortunately, as a research assistant, I don't have access to the helpdesk, so I hope that someone here can answer my question: I want to carry out an event study and need the date on which an ESG sc…
My goal is to get company event data for a universe of firms. I am using Eikon API version 1.1.18. I am using the following python code to access the Earnings Call and Earnings Release Events data , e…
I am trying to retrieve the filing dates of annual reports and ESG reports using a search query similar to https://community.developers.refinitiv.com/questions/95582/eikon-api-retrieve-annual-report-p…
rics = 'ABB.ST' start = '2020-01-01' end = '2024-02-15' rd.get_history(universe = rics, fields = "TR.CompanyMarketCap", start = start, end = end)' I am running the code above and the returned data is …
I use eikon api to get dxy data, such as TR.CLOSEPRICE TR.CLOSEPRICE.date but data I got is not the same as I found on some fin websites. I think the problem is due to TR.CLOSEPRICE.date is not the sa…
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=-1…
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 …
I want to get the fund issue date via Eikon API, but it returns empty, kindly help check if the field "ISSUE_DATE" is correct or not? Thanks. data, err = ek.get_data(instruments=['LP68728214'], fields…
I am trying to do queries for dividends in C# using the Eikon Data API. I notice that if I supply exact dates, such as today through the end of the year: sdate: 2023-05-27 edate: 2023-12-31 I get back…
Hi, I am trying to get the date, time and URL of certain news controversy categories. I used the "CODECR" app/ Formula Builder in Eikon to formulate the code. However, the results do not deliver the r…
I'm doing a research on Taiwan market and retrieved earning surprise data from DataStream. for example, I collected quarterly earing surprise announcement dates (EPSISURDTE) and quarterly EPS surprise…
We use Refinitiv RTO data for global strategies, so we need last trade and quote times in UTC. The SALTIM and QUOTIM fields are in UTC, but unfortunately, the TRADE_DATE and QUOTE_DATE fields are not …
