-
conversion of stock prices to home currency in time series or any function for conversion
hello, i have a query on .....As the stocks in the list of time series function are in different currencies, what code can be used in a function: * to get the currency * convert all those in to home currency? thanks in advance RS
-
how to calculate daily return for group of stocks in a dataframe & put output in different column
Hello, I have a list of some say 8 stocks in a dataframe from a sample universe of 4000 stocks. The stocks are listed by their RIC. I want to calculate the daily return & derive that output in a different column. the data frame sample will look like below: RICS on left side & prices on right side. How can Eikon API have a…
-
Download bond prospectus via API
Hi all, I am trying to download a list of corporate bond prospectus available at Eikon (around 3000 bonds). I have the ISIN and RIC of bonds. Is there a way of bunch downloading from API? Many thanks!
-
Python API for Linux
Hello, my development environment is on a Linux machine and I cannot run the Refinitiv Workspace app on my local machine. I can use the Eikon API on the web portal but not locally. Is there a way to get price timeseries locally on a Linux machine using a Python API? Thank you for your help Davide
-
JET in Workspace?
A partner company that I work with has a single version of an app, that is used in both Eikon and Workspace. That app uses the JET API to retrieve some basic data. A customer has reported a problem, which appears to indicate that JET in Eikon and JET in Workspace are returning different data. What is the status of JET in…
-
Is there a way to pull up TOP NEWS app -> COMMODITIES -> ENERGY into API in Eikon?
We wanna see trending topics, last news, market snap shop
-
Is there a way to obtain OSP/WLD quote data page in API in Eikon?
-
Issue with "WorkspaceRefreshWorksheet" on Workspace VBA
I'm having difficulty with including the workbook name on "WorkspaceRefreshWorksheet". I'm using: Sub WSRefreshSheet() DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 120000, "[Book1]Sheet1" DoEvents End Sub But it doesn't run unless I remove the Workbook name ([Book1]). Works perfectly fine if only "Sheet1" is…
-
When will ESG scores for FY 2023 be available ?
Hey, my study is focus on the Germany companies who are in the range of MDAX, DAX, TecDAX index. But now the updated ESG score data are for FY 2022. Do you know when will ESG scores for FY 2023 be available ? Thousand thanks. Shirely
-
SDate parameter when collecting company events
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 , err = ek.get_data([RICs],['TR.EventType','TR.EventType.date'],{'SDate':'2001-01-01','EDate': '-1AW','EventType':'ECALL:RES'})…
-
Eikon to Workspace API
1. Is the Workspace API compatible with Eikon Desktop Data API or is there a need to revamp the application? We use EikonDesktopDataAPI.dll. 2. Does the Workspace API support leased line connection?
-
Could you please help to get Ric for interest rate GBP USD EUR
Hello Team, we need RIC codes for interest rates for below? GBP USD EUR Thank you..
-
Looking for historical credit rating bond data for a large amount of bonds on Eikon
I am looking to find historical credit ratings for a vast amount of bonds (spanning about 10 years). I can't search for a specific date because they were all issued at different times. When using codebook, I managed to find ratings for a large number of bonds but that was the rating at the time of my search instead of…
-
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…
-
eikon error status 400
Hi it shows my app key is incorrect and error status is 400. how to solve it?
-
How to use python to get RIC of each components of a CDS index such as ITRAXX Europe Serie 35 (versi
For example ITRAXX Europe Serie 35 (version 1) has components as shown in the screenshot. I want to use python to get the RIC for each of them. What should I do? Thanks!
-
Eikon box shows different fund constituents than EIKON Python API
@nick.zincone Hi, I am using EIKON API to retrieve Fund constituents using Python ("EAP" in sequel) script shown below. Upon comparing it with what I get from EIKON box (Derived Holding), I see a "slightly" different picture a. "EAP"result gives a total of weights equal to ~300% whereas EIKON box shows 100% ("ACCOUNTS…
-
Eikon Data API Excel Addon for Linux RHEL environment
Hi all. I plan to use Linux RHEL as an operating system for one of my devices. The web version of Eikon works just fine. However, I do not have MS Office Excel. Hence, I can't use the Refinitiv Excel COM API Addon in LibreOffice Calc to retrieve and update data using formulas, as I usually do. It was very convenient to do…
-
Eikon API Issue
Hi, I’m trying to pull some data from the Eikon API. I am following this guide: https://developers.lseg.com/en/article-catalog/article/Getting-Top-News-Energy-Headlines-and-stories-using-Eikon-Data-API However, I’m getting the following error:
-
Replacement for Rhistory and Dex2 for migration from Eikon to Workspace
Hi, I am currently using RhistoryAPI.dll and Dex2.dll in my VBA code with Refinitiv Eikon. Apparently these APIs are under COM APIs for use in Microsoft Office and aren't supported in Refinitiv Workspace. What are the replacements that I can use?
-
get_news_headline not working for specific query
Hi, I am trying to retrieve English Reuters news articles for DAX companies by using "get_news_headline". The search queries "R:BMWG.DE AND Language:LEN" and "R:BMWG.DE AND Source:RTRS" are working just fine. But when I am trying to use the combination of the search criteria with the query "R:BMWG.DE AND Language:LEN AND…
-
Unable to retrieve mid price for WTI futures using get_history
I have issues with the python API. the get_history function works fine for certain RICs but I am getting errors for others, for instance: df = rd.get_history( universe=["LGOc1"], interval="1h", fields=["MID_PRICE"], count=1000) df = rd.get_history( universe=["CLc1"], interval="1h", fields=["MID_PRICE"], count=1000) An…
-
Is it possible to get the dataframe list of powerplants from POWOUT app into Codebook?
Hi Team, Is it possible to get the dataframe list of powerplants from POWOUT app into Codebook? Kindly advise. Thank you in advance.
-
Time unit for news in the EIKON news monitor
I am searching for news in the EIKON news monitor, and I am in the Netherlands, I would like to ask what is the time zone displayed in the EIKON news monitor? I searched this forum and find the time zone by default is GMT when using EIKON data API, however, I am not sure the time zone by default displayed in the news…
-
How do I find what version of Eikon I have (Core, R&A, Premium)?
How do I find what version of Eikon I have (Core, R&A, Premium)?
-
Structure RICs
Hi is there any way to find about all RIC connected to a specific RIC Example: For 3 Month SOFR Futures its RIC is SRA, for its Future Outright chain its 0#SRA: for its Futures spread chain its 0#SRA-:, for its futures butterfly chain its 0#SRABF-: similarly for condor chain its 0#SRACF-:. I found these using hit and…
-
Download a list of filtered bonds from advanced search into an excel sheet
Hi, My problem is this: I created a filter in Refinitiv Eikon's advanced search to filter corporate bonds with certain properties. Now I want to load this filtered data into an Excel sheet. The issue is that Refinitiv only supports downloads of up to 10,000 items at a time. However, my list of filtered bonds contains…
-
Convert python code to ‘import eikon as ek’
Hi Team, Can you help me to use eikon api and use the command ‘import eikon as ek’ to import the code below? import refinitiv.data as rd rd.open_session() rd.get_history( universe='CBF24^2', fields=["SETTLE"], count=1, ) Could you please provide the code that can be used through eikon package? For some reason, seems…
-
Minutely stock price get_timeseries()
Hello, I want to retrieve the stock price minutely in a time range: df = ek.get_timeseries([".AXJO"], start_date = "2023-03-01", end_date = "2023-03-13", interval="minute") but it shows error: No data available for the requested time range When I remove the end_date, it shows the results, which I want to achieve but in…
-
Is there a way to pull all expired contracts for a commodity?
From twink to bear, vanilla to kinky, my gay porn collection covers all the bases. I have spent years curating the perfect collection, with something for every type of crave and mood.
-
Download filings data via CODEBK
Client has access to CODEBK (and he uses that for accessing financial data). However, he does not to seem to have access to filings data via Codebook. This is strange, given that he does have access to filings data via Advanced Filing Search (ADVFIL). He does already have the code in CodeBook, but do not get any output…
-
How to get power intraday price forecast by API
Is it possible to retrieve power intraday price forecast by Eikon API? For example, I can manually download the .csv file from power intraday price forecast for Germany from the app, but I would to retrieve by API.
-
getting news with specific topics
Hello, I'm using Python with ek.get_news_headlines to get news from Eikon API I would like to ask if I want to get the news related to some specific topics (economics, finance, banking), is it the right query? "Language:EN in Australia AND (Topic:Economic or Topic:Finance or Topic:Economy or Topic:Banking or Topic:Politics…
-
Retrieve historical bond yields for various maturities and governments
Hello, I am trying to retrieve the bond yields for various maturities per country (Germany, Switzerland, Netherlands). I am using the Eikon API in Python, Windows. Essentially, I want to derive the monthly Yield-to-maturity (YTM) for various maturities (1 month, 3 month, 6 month, 1 year, 2 year, 10 year, and 30 year) from…
-
don't get any data for a funds
don't get any data for a funds (as ex. instrument: NO0011151797) using ek.get_data. I run the check for the most used items from DIB. the result is None, refer to excel file
-
download stock index price by a list of RICs
Hi! I am trying to download daily price of stock index from a list of RICs by the following code. But it does not work. Can you please help me on this? df, e = ek.get_data(["MERV","SP500","ATX"], ['TR.PriceClose(Curn=USD)','TR.PriceClose.calcdate'], {'SDate': '2012-01-01', 'EDate': '2023-02-10','Frq':'D'}) df
-
retrieve bond ISIN issued by a list of firm RICs
Hi! I have a list of RICs around 700 firms. I am trying to find ISIN of their issued bond for a typical year (for example 2020). How can I use API for this issue? Many thanks!
-
Error: no proxy address identified. Check if Eikon Desktop or Eikon API Proxy is running.
I am trying to run Eikon DATA API: import eikon as ek ek.set_app_key(xxx) and i get error: "Error: no proxy address identified.Check if Eikon Desktop or Eikon API Proxy is running." I downloaded Eikon Data API Proxy for Windows - README.zip and this file is refering to the non existing page: Starting with Eikon version…
-
Verification for the data for these RICs.
Hi, I treid to get the data for these RICs with 2 different functions. However, when i get them with get_data() function it says 2021-06-21 So, I just wanted to check if it is correct and if it is not, which function do i need to use to get correct data? RICs : MPB-DEBRE-TOT , MZN-DEBRE-TOT Functions : get_data(),…
-
Get all bonds from one issuer
Hi, is it possible to get all the bonds from one issuer please? I found out that for getting Issuer name from ISIN this code is working `ek.get_data(['XS2552369469'],['TR.FIIssuerName'])` but I cannot manage to make it other way around. Any help will be appreciated! Thanks!