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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
jozuleta avatar image
5 ●1 ●0 ●1

Find Broker / Analysts Location ?

Dear TR community,


I retrieved Data via EIKON (excel add-in / formular builder / I/B/E/S) and would like to know if there is a function (or a different way) to include the locations (e.g. Country or country code) of the Broker and/or Analyst? having the following formular (table):

=TR("0#.GDAXI";"TR.AnalystCode;TR.AnalystUID;TR.AnalystPersonCode;TR.AnalystCtbID;TR.AnalystCreateDate;TR.AnalystEndDate;TR.AnalystLastName;TR.AnalystFirstName;TR.AnalystJobRole";"CH=Fd RH=IN")

thanks in advance!

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
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

@jozuleta I have not found a way (only Broker name through estimates =TR("AAPL.O","TR.EPSEstValue.BrokerName") ), but try you local Support Desk - they should help.

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
jozuleta avatar image
5 ●1 ●0 ●1

Thanks anyway @Zhenya Kovalyov

I have another question...
Is there a way to retrieve all the stock universe of a specific country? In my example above I retrieve data for all the DAX stocks ("0#.GDAXI"). But, I would like to retrieve Data for all the stocks in Germany. What would be the corresponding RIC ? And is there also a RICfor the complete (worldwide) Stock universe?

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.

Alex Putkov.1 avatar image Alex Putkov.1

The answer is on this thread.

Click below to post an Idea Post Idea