I am using this python code to get power and gas hist prices Basically I created 3 dictionaries with all the RICs for Power DE, Power Fr and TTF price for all the monthly and quarterly and cal products. I create a simple function that for each key of the dict, download the price series. Then I change the column names with…
Is there a comprehensive list of all the potential country/region codes (across the global universe) in TR.BGS.GeoTotalRevenue.SegmentCode or an easy way to pull that together with the corresponding name?
Hi Team. I understand ek.get_timeseries method on Eikon CodeBook/API always return timestamp in GMT/UTC(based on https://community.developers.refinitiv.com/questions/72784/eikon-data-api-time-series-timezone.html) but how come rd.get_history is returning GMT-1 Here is the sample formula: For ek df =…
Hello, I am currently working on a project which involves finding and matching firm financial data to an excel-sheet dataset (called resulttable100.xlsx) containing a list of firms, their number of patents and respective filing-application years. Not all these firms are public so I ran a query on Eikon API to find those…
hi, is it possible to get tick data through API for FGBL (bund futures), FGBX (BUXL futures), FGBM (BOBL futures) and EURIBOR futures. ( Eikon premium user) If so what are the limitations, is there an article available explaining the steps, use case. Thanks.
Hi team, I encountered a question regarding eikon api retrieving news. The news body contains too many special characters, hyper links as well delimiters. Is there any way to clean them up and only keep the raw text? I've attached my code below and the original news from workspace. Thanks for the help.
...ta API I am trying to retrieve implied volatility data of Indian stock options by inputting the ISIN CODE. My end goal is to create a data frame with company, date and implied volatility. As you can see, I'm not being able to retrieve anything. Can you please guide me as to how I can go about it? Thank you!
Hi team, we are trying to get the historical tick for WTCLc1 in Eikon API but its showing NA ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY') data = ek.get_timeseries("WTCLc1", fields = ['BID'], start_date='2023-11-22T00:00:00', end_date='2023-11-22T23:59:59', interval = 'tick') print(data) I checked in Eikon excel if we have…
I wish to filter for U.S. companies with accessible CO2 emissions data. I have implemented this in the screener by establishing filters for, for instance, 5 and 10 years (filtering for GHG Scope 1 emissions > 0). Is there a method to filter for companies that possess emission data spanning the last 10 years (including…
Hi, I have around 6000 RICS and i want to fetch the earnings data for those RICS on daily basis. I'm using eikon. But continuously I'm getting backend error and internal server error. and even if I ran it on the for all 6000 RICS I'm getting the data for only in between 3 to 3.5K. I'm tried giving the time sleep of 2 sec…
It looks like you're new here. Sign in or register to get started.