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!

Best Answer

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

Answers

  • 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?

  • The answer is on this thread.