Identify family firms in time

I am trying to identify the family firms among listed firms in time dimension (since ownership changes), using Excel Eikon.

I try this code for Walmart company:

=@TR("WMT.N","TR.MnAIsTarFamilyOwned; TR.MnAIsTarFamilyOwned.Date","CH=Fd RH=IN",B6)

I got only one "TRUE" response for one date:

walmart-screenshot.jpg

Does that mean that Walmart was family firm only at that time and then ownership change? I bit strange to be family firm for 1 year.

Which other field I can use to get the dynamic identifier of the family firm?

Thanks in advance,

Alex

Best Answer

  • raksina.samasiri
    Answer ✓

    Hi @eikon19 ,

    Thank you for posting the question in
    this forum. However, this forum is dedicated to an API usage question hence,
    the moderators on this forum do not have deep expertise in every type of
    content available through Refinitiv products, including the Eikon Excel and clarifying the content. Such expertise is available
    through Refinitiv Helpdesk, which can be reached via MyRefinitiv. To be of help, ticket number 13240957 was raised on your
    behalf and the support team is going to contact you directly to assist with
    this.

    Hope this helps and please let me
    know in case you have any further questions.

Answers