R code to get starmine data

suzanne_persson
suzanne_persson
in Eikon Data APIs

I have written a prototype using the Eikon Excel Plug in to retrieve 2 Starmine data fields for the latest date for portfolio list into Excel. I would rather use an API so I can build a more automated, robust solution that can be run on a daily basis. Are all of the API options able to retrieve the following:

=TR("LIST(PortfolioName)","TR.EQCountryListRank; TR.ARM100Region","CH=Fd RH=IN",A2)

Would the R or .NET API be able to give me the data I need? Is there any sample code for this?

(And yes, we have talked to our rep about licensing restrictions and understand the data will only be available to the people who have an Eikon license)

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    Yes, as suggested by @Zhenya Kovalyov you can use Eikon API Proxy, which can be downloaded from this portal, and open source eikonapir package from Github to make this call. Load eikonapir package into R. Then

    set_app_id('Use Eikon API Proxy to obtain app ID and put it here')
    get_data(list('LIST(YourListName)'), list('TR.EQCountryListRank', 'TR.ARM100Region'))

Answers

  • Zhenya Kovalyov
    Zhenya Kovalyov

    This is quite possible with the scripting proxy API in Python:

    tr.get_data(instruments=['LIST(Blah)'], fields=['TR.EQCountryListRank','TR.ARM100Region'])

    image

    I suspect you can do something similar in the community supported R API .

Categories