-
Beta Expression in R via Datastream API
Hi, I am trying to run an expression in r using the DatasteamDSWS2R package. I have be able to get a more simple expression working, but for what ever reason the formula supplied is not generating any data. mydsws$timeSeriesRequest( instrument = 'A:BHPX' expression =…
-
Retrieving historical constituent data using R
Hi Team, we have a client that is trying to retrieve historical data using R with the following code: get_data('0#.KLSE(2018-01-01)', list('TR.InstrumentName', 'TR.CompanyMarketCap(ShType=OUT)')) but they are not able to retrieve it. Client said they were able to retrieve this previously with the below image similar…
-
check quota usage using R package DatastreamDSWS
hi, how can I check quota usage using R package DatastreamDSWS? I tried the following but I get NA mydsws <- dsws$new() myData <- mydsws$snapshotRequest(instrument = c("STATS"), datatype = c("DS.USERSTATS"), requestDate = "0D") thanks
-
List of stocks in an exchange via DSWS
Hi, how can I get a list of all stocks in an exchange (e.g. NYSE) via R DSWS API (even better if via R package DatastreamDSWS2R). What I am trying to get is the something analogous to what one would get via DFO's Navigator, pulling a list of stocks in an exchange, with a given set of filters (e.g. active, major, geographic…
-
Extracting data from Datastream R API using Sedol
Hi, I am using an R API call to extract historic returns from the datastream API from a dataframe of Sedols and Dates. The API call works perfectly for ISIN's however for this dataset I only have Sedols. I have noticed that the call only works on numeric Sedols and not alpha numeric Sedols. I don't have a country code so…
-
robfilter and visualization of smoothed curve
Hi everyone. I am using the robust filter with time series data. In my example I use the following time series data (boston): install.packages("fma")library(fma)install.packages("robfilter")library(robfilter)bank <- as.data.frame(boston)series1 <- bank$nyase series2 <- bank$bsebank.rf1 <-…
-
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.…
-
Error when trying to pull Datastream time series in R
@Shadab Hussain @chavalit_jintamalit Here's the code tkrs <- tkrTbl[which(tkrTbl$Field=="A12PE"),"RawTicker"] datatype <- c("A12PE") x.period <- "D" mydsws <- dsws$new() data <- mydsws$timeSeriesRequest(tkrs[1], datatype, startDate = DSStDate, endDate = eDate, frequency = x.period) Error snippet:
-
mapping from RIC to PermID.
I got two questions in order to get ESG combined scores by use a RIC code. 1. which filed I can use to mapping from RIC to PermID in the ESG Bulk Symbology and company reference data 2. if I have the PermID, whick filed I can query to get this company's combined ESG scores. Thanks
-
R compatibility with eikon api
How can I use eikonapir (or any other way) to retrieve data from eikon/refinitiv from my RStudio session that runs on a Unix server? Any help is appreciated
-
RDP asyncio.gather / HistoricalPricing.get_summaries_async / Dynamic tasks
Hello, It seems rdp.HistoricalPricing.get_summaries_async function supports single universe. I am looking for dynamically requesting multiple universes using it. Can I find sample code in Python?
-
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?
-
API REsolve Results working partially
Hi Team, Hi team, SEQ-case-investigate-resolve-results: Resolve results We use this request in order to resolve results but the API seems to work partially : - We perform 874 resolved and 33 of them have been not resolved - If we relaunch the API for one of the 33 results, the resolustion still not work. At your diposal to…
-
How can I access the Eikon API in R? I have read about the 'eikonapir' package but it seems rather d
How can I access the Eikon API in R? I have read about the 'eikonapir' package but it seems rather dated by now and it is not on CRAN either. Is that the only way?.
-
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
-
How can I get the RICs for a list of Tickers?
Hi, how can I get the RICs for a list of tickers, so that I can work with get_timeseries? I have seen this related post: https://community.developers.refinitiv.com/questions/19371/converting-a-list-of-tickers-to-rics.html What is the best practice today to find out the RICs? kind regards
-
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.…
-
I am trying to use the Datastream API in R (using the R package DatastreamDSWS2R), but it is giving
GAURAV.PNGI am trying to use the Datastream API in R (using the R package DatastreamDSWS2R), but it is giving me a 403 error. Below is the full text of the error message. Please could you help? Error in .self$.requestToken() : Error requesting access Token. HTTP message was: Client error : Forbidden : Client error: (403)…
-
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…
-
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.
-
DatastreamDSWS2R API, Excluding Investment Trusts and Unit Trusts
Dear, I am currently trying to exclude investment trusts and unit trusts when pulling the constituent list using the DatastreamDSWS2R API. I currently pull the constituent list from WSCOPEUK using the following code: mynames <- mydsws$listRequest(instrument = c("WSCOPEUK"), datatype = c("ISIN","WC07021"), requestDate =…
-
How avoid handle_read_frame error: websocketpp.transport:7 (End of File) error?
I have a script that connects to the Elektron feed via websocket. The code is based on the following https://github.com/Refinitiv/websocket-api/blob/master/Applications/Examples/R/market_price_batch_view.R Sometimes it works perfectly, sometimes I have an error message: send pong send pong [2021-05-04 15:05:02] [error]…
-
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 =…
-
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…
-
How to get list of ISIN's or MNEM within a TRBC activity code
Hello All, I would like to generate a list of company codes (ISIN or Mnemonics) that meet the criteria of being in a certain TRBC industry or activity group. I am using the DataStream API in R. For example, If I wanted a list of the securities that fall under the TRBC 2012 hierarchical ID of 59 (utilities) how would I…
-
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"…
-
How save the messages from the websocket server using R?
I am using following file to connect to the Elektron service websocketr (1).txt This file is based on the following link https://github.com/Refinitiv/websocket-api/blob/master/Applications/Examples/R/market_price_authentication.R I got a message (with bid and ask prices) with the output from the server like: > ws$connect()…
-
Establish a websocket connection and set headers?
Hello, I am using R software and struggling to make a websocket connection. The initial source for my websocket connection is here https://github.com/rstudio/websocket The codes, which I want to repicate ar here https://github.com/Refinitiv/websocket-api/blob/master/Applications/Examples/R/market_price_authentication.R…
-
Help in setting global variables for websocket API in R
Hello, I am struggling in setting my global environment variables to get data via websocket in Elektron. I tried Python code and it works fine, the connection gives access_token. However, using these variables in R does not give this token. Files can be downloaded here…
-
How get the data from ERT in Cloud using Websocket API in R
Recently I got trial to Elektron feed. In the welcome email was said that "You need to use the Websocket API not the REST API as you will be receiving the data from our streaming feed.". The link that was suggested to help was following:…
-
Trying to get forex forward curve historic, problems with NDA_RAW fields and Spot Date
Hi, I'm trying to get the EUR (for example) forward curve from yesterday and the day before. So, in Excel, I got: =@RHistory("EUR1M=";"NDA_RAW.Nda_date;NDA_RAW.Nda_ask;NDA_RAW.Nda_bid;NDA_RAW.Nda_days_maturity";"START:2020-10-07 END:2020-10-14 CODE:MULTI INTERVAL:1D";;"CH:IN;Fd";) This gives me the Date, Bid, Ask and Days…
-
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…
-
Cant reproduce new Refinitiv R package
I am trying to reproduce the new Refinitiv R library as in the following link https://rdrr.io/github/GreenGrassBlueOcean/RefinitivR/f/README.md After successfully installing the R package, I was able to run the following command successfully Data <- EikonGetData(EikonObject = Eikon, rics = c("MMM", "III.L"), =…
-
Is there a direct way to set up the Tick History REST API for R programming environment?
Is there a direct way to set up the Tick History REST API for R programming environment?
-
How can I set up API for R?
How can I set up API for R?
-
Response time too long, Error Handling in R
R code: library(eikonapir) eikonapir::set_app_id("my-key") time.start <- Sys.time() tickers <- c("BRGV5YUSAC=R", "AAHR5YEUAM=R", "ANZ5YUSAR=R", "BBVA5YEUAM=R", "SAN5YEUAM=R", "BAC5YUSAX=R", "BKCH5YUSAC=R", "BNS5YUSAX=MP", "BARC5YEUAM=R", "BNPP5YEUAM=R", "CNDA5YUSAC=R", "C5YUSAX=R", "CBKG5YEUAM=R", "CBA5YUSAR=R",…
-
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 =…
-
Eikon COM RSearch in R
I am trying to get Eikon COM Rsearch to work with R I have some rather old code that I am trying to revive as it was at least partially working I am using these libraries in R: require(RDCOMClient) require(audio) I have tried creating connection in two ways: eikon = COMCreate("EikonDesktopDataAPI.EikonDesktopDataAPI") (a…