Find Broker / Analysts Location ?

jozuleta

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!

Zhenya Kovalyov

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

jozuleta

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?

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/33420#Comment_33420

The answer is on this thread.