-
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…
-
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…
-
How can I tell which fields are available for the given RICs using the Eikon API to pull timeseries
Hello API Experts, We have a client asking how can he tell which fields are available for a given RIC using the Eikon API to pull timeseries data. Client said he is using the eikonapir package in R. Please see the attached sample code that the client sent. Thank you and looking forward to your feedback on this. Regards,…
-
Refinitiv Eikon API in R - Issues with extracting paneldata/time series
I am using the Refinitiv Eikon API in R, using this https://github.com/ahmedmohamedali/eikonapir. I am trying to extract values for each month the last 10 years with 30 or so different variables defined. However, the code does not run when trying to loop over several time periods. I am using the get_data function, as I…
-
R Support Available?
Hi team, can we pull company earning dates in R but dont see any R support. Is R supported? Can you point me to resources/pass some sample code? Thanks, Regards, Shivu S B
-
Issue with Production Market Data Service (using EIKON/EMA jar version 3.6.3.1)
Asking on behalf of the client. We (Chelmer/Hobson Wealth details below) had an issue with our Production Market Data Service (using EIKON/EMA jar version 3.6.3.1) where we received an unsolicited and malformed depth message for AIR.NZ (which we have no record having requested) and we were not able to read the summary data…
-
Generate historical adjusted closing prices in R
Hi, I am using the R package to pull data and would like to pull historical data fields for specified dates like adjusted closing prices and volumes. I have tried: get_timeseries(list("MSFT.O","VOD.L","IBM.N"),list("*"),"2016-01-01T15:04:05","2016-01-10T15:04:05","daily") and included the TR.PriceClose field but it fails.…
-
Accessing historical lipper data from R
Hello, I have been using the get_timeseries function and the get_data function in r but have not seemed to be able to pull Lipper historical data. Any ideas?
-
Error in print.default("HTTP Error, code= ", response$status_code, sep = "") : invalid printing d
Hi, I am getting the below error when I try to connect Eikon API using R. Error in print.default("HTTP Error, code= ", response$status_code, sep = "") : invalid printing digits 503 Can someone please help me? Thanks, Sree
-
Data limit reached?
I downloaded a rather large amount of data via the Eikon API for R. After requesting two data points for ~5000 companies, the code stopped working and now returns "Error in print.default("HTTP Error, code= ", response$status_code, sep = "") : invalid printing digits 407" I suspect, that a limit has been reached.…
-
API for R: extract price of stocks at some point in time
Hi. I need to match a large number of events to stock prices (different stocks, different points in time). I understand I can use Time and Sales template. However Im working with R but I couldn't find API for R on Refinitiv's API website. Could I check if there's any way to implement the price extraction in R? Many Thanks.
-
Eikon API(R) connection is not working with Eikon desktop running in my PC
HI, I',m trying to download historical data with the eikonapir library. I'm using Windows 10 and the latest version of Eikon. Eikon is running and, when I try to download the historical price of AAPL, I have the next error message: Error in curl::curl_fetch_memory(url, handle = handle) : Failed to connect to localhost port…
-
Eikon API R NOT WORKING
get_timeseries(rics = ricsH, fields = list("TIMESTAMP", "CLOSE"), start_date = paste(SoyaFC$Date[nrow(SoyaFC)] + 1, "T00:00:00", sep = ""), end_date = paste((today() - 1), "T00:00:00", sep = ""), interval = "daily", normalize = TRUE, raw_output = TRUE) Two weeks back I was able to run this code with no issue. Now it is…
-
R API not working after update to Eikon 4.0.54062
I use a basic R Script to gather Data from Eikon, but after the Upgrade to Eikon 4.0.54062 the script is not working. I had the same issues with a previous update, which I than solved by rolling back to Eikon 4.0.51085. Error message from R (debug mode): [1] "Request *************************************"…
-
What are the possible Status Code Values from get_timeseries() - Eikon API R
So far I found that the function can return a StatusCode value of either "Normal" or "Error". I want to know if the function can possibly return any other values? I want to use it as sort of an error check to see if the function returned any valid data.
-
Extracting Historic Timeseries Data for 0#SOY: | Johannesburg Stock Exchange Soybean Commodity Futur
I'm trying to use the Eikon API for R to extract the historic timeseries data for: 0#SOY: | Johannesburg Stock Exchange Soybean Commodity Future Chain | Johannesburg Stock Exchange | South Africa | ZAR I'm not having any luck. I'm using the get_timeseries() function. First off, I'm not sure if I'm using the correct naming…
-
Null result on GDP API R Timeseries request
Hi all! I'm trying to pull some GDP time series data (RIC: aIDCGDPPD/A) in R using the eikonapir package. However, my request is returning null values (see below). I have a feeling this is because something in my request is incorrect, but I can't figure out what. Can The 'ECONOMIC.Timestamp' and 'ECONOMIC.Value' fields are…
-
Institutional Ownership Data to R
Dear community, I am wondering whether it is possible to retrieve institutional ownership data into R, like in this example for python: https://community.developers.refinitiv.com/questions/74994/historical-institutional-ownership-thomson-reuters.html I tried to do it with get_data("IBM", fields='TR.CategoryOwnershipPct'),…
-
variable parameter values for a list of instrument in R/Python API
Hi folks, I currently come up with the following syntax in R, which requests the revenue in the fiscal year 2014 for a list of instruments. My intention is to request the revenues at different fiscal years for each instrument (e.g., 'GE' revenue at 2015, 'AAPL.O' revenue at 2016, and 'CSCO.O' revenue at 2017 ). While I can…
-
Eikon 404 error:
Hi, I'm trying to get data from the Eikon api. I've set my Eikon App key as follows: ek.set_app_key('xxxxxxxx') and then I try to retrieve data with: df,e = ek.get_data('REUTERS','TR.RIC') I get the following error Client Error: <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Error</title> </head>…
-
Does API in R share the same data downloading limitation as python?
Does API in R share the same data downloading limitation as python? Do we have any official resources for EIKON API in R?
-
Getting an error while try to fetch FID details for more than 30K rics ( Erro msg= Error in print.de
-
Eikon R API install error
Hi all, could I ask for some help on the following please. I am trying to install the R API. I installed Rtools and Devtools. If I run install_github("ahmedmohamedali/eikonapir") I get the following error message Downloading GitHub repo ahmedmohamedali/eikonapir@HEAD Error in utils::download.file(url, path, method =…
-
Help with Order Book in Eikon API
Hello team, could you please help us get the Order Book with Eikon API - preferred in Python or R We have an important demo for a significant client and we wish to advance with this request. This is what I got so far import refinitiv.dataplatform as rdp import eikon as ek import pandas as pd import plotly.express as px…
-
How to find the appropriate fields for US1YT=RR ?
I am using eikon API (both for R and python) but I can not manage to get a time series of yields for US1YT=RR (one year US yield). Any idea on where can I find the appropriate 'field'? In excel, it works using 'B_YLD_1' but that does not work in the eikon API. More generally, how do I find all the available 'fileds' for a…
-
Inconsistency b/w ek.get_data() and ek.get_timeseries()
Hi, While trying to retrieve the historical data for some convertibles (RICs = ['JEdbc.TO^I20', 'JEdbd.TO^I20], I got inconsistent results from ek.get_timeseries() and ek.get_data(). Specifically, the former returns data while the latter returns NA. See detail below, df = ek.get_timeseries(rics,…
-
R eikonapir: returns data.frame with NA only
Hi, I am using R eikonapir to download data. I can access the data using Excel so I am convinced that the chosen fields and rics are correct. However, get_timeseries() returns a data.frame with NA's only. This is my code: get_timeseries( rics = list( "EURCHF1YP=" ), fields = list( "FCAST_MED.Timestamp", "FCAST_MED.Value"…
-
Refinitiv Eikon retriving bond historical prices.
Dear fellow developers I am a pretty new person for the Eikon API code session. I here to ask a simple (may stupid) question for my recent work on data collections using Eikon API codes with R. I need to retrieve the historical price information of over 100 bonds for my study. Typically, I am interested in the ask price,…
-
eikonapir: how to get dates returned from get_data()
Hi, I wonder how to get dates returned from get_data() of the "philaris/eikonapir" package. I'd like to download SPY's market cap over a period. Using eikon package in Python, I can get this done easily with ek.get_data() as follows: df, err = ek.get_data('SPY',['TR.CompanyMarketCap', 'TR.CompanymarketCap.Date'],…
-
How to fetch historical "Market Open Interest" using eikon R API?
Hi, I need to know how one can fetch the Market Open Interest using eikon R API. I have no idea about its fields name. I know how to collect Open Interest using eikon R API. Below is an example get_data(list("LCOc1"),fields = list('TR.OPENINTEREST.Date', 'TR.OPENINTEREST', '2000-01-01', '2020-05-25')) but I want to know…
-
eikonapir package error
Hi, can you fix the following error when installing eikonapir package: devtools::install_github("philaris/eikonapir") Error in read.dcf(path) : Found continuation line starting ' Panagiotis Cheilar ...' at begin of record.
-
"API Proxy is not available"
Hello, I'm unable to use the R API since the beginning of this week. I'm getting below error message. I have used it before and I am able to use it on a company desktop computer. It stopped working on my company notebook however. - Reinstalled Eikon and R Packages - Tried with/without VPN - Checked Eikon running, logged in…
-
Error: Error in 1:nrow(input_data_frame) : argument of length 0 while using get_timeseries
Hi, I am getting the above addressed error while running the get_timeseries. It is not a consistent error, sometimes it appear and sometimes it does not NCLData <- get_timeseries(list(paste0(CFTCRICS[i],"NLNG")),start_date = paste(floor_date(Sys.Date() - years(14), "year"),"T00:00:00",sep = ""),end_date =…
-
eikonapiR - Recv failure: Connection was reset
Hi, I am trying to run a activity on windows 2008 R2 server using EikonapiR. I am not sure why this error comes. "Error in curl::curl_fetch_memory(url, handle = handle) : Recv failure: Connection was reset" I followed other questions and had set up set_prox_port(900L). then i get error as "Error in…
-
Received invalid 'digits' argument when using EIKON API R to pull data
Was using the Eikon API R to run a loop to pull data for various securities. When I returned to my computer and RStudio, I received this error: Error in print.default("HTTP Error, code= ", response$status_code, sep = "") : invalid 'digits' argument Was unsure what was the problem as it was abrupt. Here is the traceback:…
-
Error when accessing Eikon data via API using R
Hi, I'm trying to access Eikon data via R using the API. I have installed "eikonapir" package and set my Eikon ID (+ have Eikon running on the back), but when trying to access data via "get_data" I get the following error message: Error in curl::curl_fetch_memory(url, handle = handle) : Failed to connect to localhost port…
-
How to get historical Open Interest using eikon R api?
Hi, To fetch parameters like Open Interest, I use get_data function in R but it only returns the latest value. How can I pull historical open interest in Eikon R?
-
eikonapir - error 502
I am new in eikon api for R. When I try to get data I have this error: > get_data("MSFT.O","TR.ISIN", debug=TRUE) [1] "Request *************************************" {"Entity":{"E":["DataGrid"],"W":{"instruments":[["MSFT.O"]],"fields":[{"name":["TR.ISIN"]}]}}} [1] "Response *************************************" [1]…
-
eikonapir function get_symbology() to SEDOL returns "no best match available"
I am using the updated version: https://github.com/philaris/eikonapir WORKS: get_symbology("MSFT.O", from_symbol_type="RIC", to_symbol_type="ISIN") get_symbology("MSFT.O", from_symbol_type="RIC", to_symbol_type="CUSIP") get_symbology("US5949181045", from_symbol_type="ISIN", to_symbol_type="RIC")…
-
Bloomberg R user switching to Eikon/eikonapir - sample R scripts/field mappings
R, eikonapir I switched from many years as Bloomberg R user to Eikon, installed the R eikonapir library and used get_timeseries() to retrieve historical data mainly equity related. My problem: Mapping of Bloomberg fields to Eikon. I use the Eikon Excel formula builder, but these fields don't seem to work. Example, in Excel…