How to connect R with reuters eikon?
Best Answer
-
For windows operating system please type in the following code, line by line in R interpreter. This will install the eikonapir package and I have also included a simple test get_symbology call to see if it is working for you. You need to generate an App Key for Eikon Data API using the APPKEY Generator app in Eikon (type APPKEY into Eikon searchbar). If you are using the Mac OS Eikon Standalone proxy - use port 36036 (include the L suffix). I hope this can help you.
install.packages("devtools")
library(devtools)
install_github("ahmedmohamedali/eikonapir")
library(eikonapir)
eikonapir::set_proxy_port(9000L)
eikonapir::set_app_id('Your App Key Here')
result <- get_symbology(list("MSFT.O", "GOOG.O", "IBM.N"),"RIC",list("ISIN"),raw_ouput = FALSE,debug=FALSE)
print(result)0
Answers
-
@mohd.tariq.azim take a look at this
0 -
This code is not supporting and the link which is taking me to API has guidance on Python not R.
Please help!
Thanks!
0 -
@mohd.tariq.azim I am not too sure I understand what you mean. EikonApiR is a community developed package for the Eikon Data API, and the above link has installation instructions and usage examples.
0 -
install_github("ahmedmohamedali/eikonapir")
The above code is not working.
Please help!
0 -
Hi
After running the install.packages code (snap is copied below). I am getting an error - 'lib' is unspecified.
Please help.
Thanks!
R> install.packages("Z:/Tariq/Text analytics/eikonapir-master.zip", repos = NULL, type = "win.binary")
Installing package into ‘C:/SWDTOOLS/Rtools/win-library/3.5’
(as ‘lib’ is unspecified)0 -
@mohd.tariq.azim The type of file will be "source" not "win.binary". You might also try to specify the destination location library (using lib parameter) and ensure you have write permissions etc. Please see the R install.packages documentation here. I hope this can help.
0 -
I have tried to change the type = "source">>> Still the error is coming.
Please see the error
install.packages("Z:/Tariq/Text analytics/eikonapir-master.zip", repos = NULL, type = "source")
Installing package into ‘C:/SWDTOOLS/Rtools/win-library/3.5’
(as ‘lib’ is unspecified)
In R CMD INSTALL0 -
@mohd.tariq.azim Are you sure it is not installing - sometimes a warning is thrown but it might still go through. As I said before you could try specifying a location using the lib= option (providing a location you can write to) It sounds like you might not have write permissions - you could try running as administrator or please see some potential solutions / discussions here . I hope this can help you.
0 -
I don't have an error installing, but when i ran the following codes,
eikonapir::set_proxy_port(9000L)
eikonapir::set_app_id('xxxxxxx')
result <- get_symbology(list("MSFT.O", "GOOG.O", "IBM.N"),"RIC",list("ISIN"),raw_ouput = FALSE,debug=FALSE)
the "get_symbology" lines ran a long time. I waited 30mins then had to manually stop it. when i stopped it, i get this error.
Error in curl::curl_fetch_memory(url, handle = handle) :
Operation was aborted by an application callback
any idea why?
Thanks
0 -
MAC OS:
Eikon Data API Proxy Beta 1.0.102 - MacOS
from
05/20/2019 03:02
the port of the proxy is the same as for WIndows OS (9000L), and needs no specification, since it is the default , so you can outcomment the line
eikonapir::set_proxy_port(9000L)
0 -
What's wrong with this?
install.packages("ahmedmohamedali/eikonapir")
Installing package into ‘C:/Users/Felhasználó/Documents/R/win-library/3.5’
(as ‘lib’ is unspecified)
Warning in install.packages :
package ‘ahmedmohamedali/eikonapir’ is not available (for R version 3.5.3)
0 -
> install_github("ahmedmohamedali/eikonapir")
Downloading GitHub repo ahmedmohamedali/eikonapir@master
√ checking for file 'C:\Users\Felhasználó\AppData\Local\Temp\Rtmpcz1x0F\remotes73cc5a2fb26\ahmedmohamedali-eikonapir-4eabcd3/DESCRIPTION' ...
- preparing 'eikonapir':
√ checking DESCRIPTION meta-information ...
- checking for LF line-endings in source and make files and shell scripts
- checking for empty or unneeded directories
- building 'eikonapir_0.1.0.tar.gz'
Installing package into ‘C:/Users/Felhasználó/Documents/R/win-library/3.5’
(as ‘lib’ is unspecified)
* installing *source* package 'eikonapir' ...
Error in file(file, if (append) "a" else "w") :
(converted from warning) cannot open file 'C:/Users/Felhasznals/Documents/R/win-library/3.5/eikonapir/DESCRIPTION': No such file or directory
ERROR: installing package DESCRIPTION failed for package 'eikonapir'
* removing 'C:/Users/Felhasználó/Documents/R/win-library/3.5/eikonapir'
In R CMD INSTALL
Error: Failed to install 'eikonapir' from GitHub:
(converted from warning) installation of package ‘C:/Users/FELHAS~1/AppData/Local/Temp/Rtmpcz1x0F/file73cc580f5196/eikonapir_0.1.0.tar.gz’ had non-zero exit status
0 -
Hello, this is not related to installation but how to download data in R. if you want to make a reference to list of identifiers in a dataframe, how would you do it? For instance, in seeking RICs by company names, the syntax in Python would be:
names=["MICROSOFT","VODAFONE"]
syntax = 'SCREEN(U(IN(Equity(active,public,primary))),Contains(TR.CommonName,' + names[1]') OR Contains(TR.CommonName,' + names[2] + '), CURN=USD)'
df,e=ek.get_data(syntax,'TR.CommonName')
What would be the reference in R equivalent to '+names[1]' in the syntax above?
Many thanks!
0 -
When you ask a new question, always start a new thread. Old threads with accepted answers are not monitored by forum moderators.
Here's the equivalent code in R using eikonapir library.
names <- list('MICROSOFT','VODAFONE')
screener_exp = paste('SCREEN(U(IN(Equity(active,public,primary))),Contains(TR.CommonName,\'', names[1], '\') OR Contains(TR.CommonName,\'', names[2], '\'), CURN=USD)', sep='')
df <- get_data(screener_exp,'TR.CommonName')0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛