I am trying to reproduce the new Refinitiv R library as in the following link
After successfully installing the R package, I was able to run the following command successfully
Data <- EikonGetData(EikonObject = Eikon, rics = c("MMM", "III.L"), = c("TR.PE(Sdate=0D)/*P/E (LTM) - Diluted Excl*/", "TR.CompanyName"))
However, when I am trying to reproduce time series command using the following command:
Timeseries <- EikonGetTimeseries( EikonObject = Eikon, rics = c("MMM", "III.L"), , start_date = "2020-01-01T01:00:00", , end_date = paste0(Sys.Date(), "T01:00:00"))
I am getting the following error:
EikonGetTimeseries request returned with length 4 Error in data.table::rbindlist(TimeSeriesList, use.names = TRUE, fill = TRUE) : Column 2 of item 1 is length 2 inconsistent with column 1 which is length 905. Only length-1 columns are recycled. In addition: Warning messages: 1: In FUN(X[[i]], ...) : is.na() applied to non-(list or vector) of type 'environment' 2: In FUN(X[[i]], ...) : is.na() applied to non-(list or vector) of type 'environment' 3: In cbind(Date = c(FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, : number of rows of result is not a multiple of vector length (arg 2)
I am the author of this package.
I have made yesterday and today a number of commitments to:
- To be able to work with the latest Eikon Python api version 1.1.6.post2
- Take out the dependency on python pandas, which caused the issue you mentioned. As the default version of pandas is now 1 in stead of 0.2.5. Pandas now requires additional information which I can not provide by the r interface.
- A new parsing engine, to do the conversion from nested list from the api to a R data.frame.
- if verbose = TRUE you can notice the new download manager who tries to retrieve requests multiple times in order to prevent/overcome 400 and 408 errors as much as possible.
- Many more unit tests to better deal with nested lists. (over 110)
I therefore suggest to download the latest version from github.
I guess that @jirapongse.phuriphanvichai was using an older version of the python api and the R RefinitivR package. Therefore his requests turned out ok without issue. You were I guess using an intermediate version. I therefore suggest to regularly download the latest version from Github to ensure you are running the latest version.