How to connect R with reuters eikon?

Options

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @mohd.tariq.azim

    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)

Answers

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG

    @mohd.tariq.azim take a look at this

    https://github.com/ahmedmohamedali/eikonapir

  • mohd.tariq.azim
    mohd.tariq.azim Newcomer
    https://community.developers.refinitiv.com/discussion/comment/37776#Comment_37776

    This code is not supporting and the link which is taking me to API has guidance on Python not R.

    Please help!

    Thanks!

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    https://community.developers.refinitiv.com/discussion/comment/37812#Comment_37812

    @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.

  • mohd.tariq.azim
    mohd.tariq.azim Newcomer

    install_github("ahmedmohamedali/eikonapir")

    The above code is not working.

    Please help!

  • mohd.tariq.azim
    mohd.tariq.azim Newcomer

    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)

  • jason.ramchandani01
    jason.ramchandani01 admin
    https://community.developers.refinitiv.com/discussion/comment/37850#Comment_37850

    @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.

  • mohd.tariq.azim
    mohd.tariq.azim Newcomer

    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 INSTALL
  • jason.ramchandani01
    jason.ramchandani01 admin

    @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.

  • cameron2028
    cameron2028 Newcomer

    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

  • e1.admin
    e1.admin Newcomer

    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)

  • studentuser
    studentuser Newcomer

    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)

  • studentuser
    studentuser Newcomer
    https://community.developers.refinitiv.com/discussion/comment/58057#Comment_58057

    > 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

  • asantos2
    asantos2 Newcomer

    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!

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    https://community.developers.refinitiv.com/discussion/comment/63728#Comment_63728

    @asantos2

    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')

Categories