-
RDP.DateCalcPeriod with API
We use the below formulae to get the maturity of the RIC code using LSEG excel plug in. We would also like to understand how this could be downloaded via the API? =RDP.DateCalcPeriod($”29/07/2025),MID(USD3MD=,4,2),,LEFT(USD3MD=,3),"ENDDATE")
-
Issuer with Calendar services
Dear Developers community i'm facing an issue with calendar service (https://api.refinitiv.com/data/quantitative-analytics-dates-and-calendars/v1/calendars). Indeed, when i extract the calendars List available, i get 'USER_CLDR_1' in the list returned using API.
-
Exchange Holidays
May I ask what’s the main difference between lseg and Refinitiv api ? When should I use one over the other ? Can you provide me the calendars code for the following markets: Hong Kong, India, Taiwan, Malaysia, Pakistan, Philippines, New Zealand, Vietnam, Japan, Indonesia, Australia, Korea, Thailand, Singapore, China,…
-
Earnings calendar in Excel using the Eikon API
Greetings, I am looking to create an earnings calendar on Excel for S&P 500, Nasdaq and Stoxx 600 data through API Data. I tried with CodeCreator to obtain data for Tesla and Apple as a test: But Tesla expected earnings date seems to be wrong? Also, is it possible to add multiple RIC to the CreatorCode? Thanks,
-
How to get only trading days in Datastream data?
Hi, When I try to get data for the instrument <DOLc1> it is returning data for non-trading days. I tried using Python Datastream module: ds.get_data(tickers='<DOLc1>', fields=['PS'], freq='D', start='2021-01-01") This will return, e.g., data for 2021-01-25, which was a holiday in Sao Paulo and the exchange was closed. My…
-
How to get calendar years instead of "FY-t"?
New to Eikon, hope this is the right Forum: I am extracting a Series of Data (ESG figure) in Web Access Eikon using the Screener App. However, I need the calender years, as I understand that "FY0" is not necessarily the current calender year, but could be the last year in which the relevant data is available? Is there a…
-
How to get the USD/GBP/JPY/EUR/CHF/SGD/HKD calendar data from real time?
May I know how to get the USD/GBP/JPY/EUR/CHF/SGD/HKD calendar data from real time service via EMA? I would like to know the banking holidays of each currencies. We have this in Eikon Excel using =@DfAddPeriod Function.
-
I what to know how can I get the Earning Season-like filter on the Eikon API.
I what to know how can I get the Earning Season-like filter on the Eikon API. I want to have the name of the company's that are releasing the earning on a given day.
-
Trading Calendar For An Exchange
Hi, is there a python method to return a dataframe of all trading dates for an stock exchange, using get_data() ?
-
ek.get_data("AAPL.O", "TR.TRESGScore", {'Period': "CY2016"}) : At which point in time do data get...
... pulled ? Here the monitor displays the period-end-date of 2015 and 2016 as 26-09-2015 and 24-09-2016, respectively. Does this mean the formula above lets data be pulled out at any point in time from 27-09-2015 to 24-09-2016? Besides, is my understanding correct that the calendar year 2016 is from 27-09-2015 to…
-
How to get market holidays or calculate business day conventions in App Studio
Hi, I'm looking for APIs to get market holidays calendar or calculate business day conventions.. I found Holiday structure definition in ThomsonReuters.Desktop.SDK.DataAccess.TimeSeries.MetaData but I didn't find any other clue. Which should I use API to solve above or is there any other related APIs like 'day count…