For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
suzanne_persson avatar image
1 ●0 ●0 ●1

R code to get starmine data

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)

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

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'))
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

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

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

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


screen-shot-2017-10-12-at-101430.png (96.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea