Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
eikon19 avatar image
1 ●0 ●0 ●0

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

eikonworkspace#contentexcel
walmart-screenshot.jpg (160.2 KiB)
icon clock
10 |1500

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

raksina.samasiri avatar image   raksina.samasiri

<AHS>

Got this information from the support team,

For university students we have an agreement with the university to direct students to the university’s librarian/school administrator/professor for assistance on content and product related inquiries as the first level of support. We are happy to assist your school librarian/school administrator/professor when they open a new query on your behalf.

2 Answers

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

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.

icon clock
10 |1500

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

Upvotes
evawillms183 avatar image
1 ●0 ●0 ●0

My colleague has answered the same question here.

icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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