Eikon item TR.ShareholderApprovalStockCompPlan

c.xue

Hi,

How can I download the data wih Eikon item TR.ShareholderApprovalStockCompPlan

for all US firms from 2000 to 2021?

Thanks

Find more posts tagged with

eikon-data-api

#content

#product

Accepted answers

wasin.w

Hello @c.xue

I found that case 11987018 is closed with the following resolution:

You can use the country of incorporation as the USA as well.

In case you have access to Datastream we have active and DEAD lists for each market. So, you could use these lists to fetch active and DEAD companies as well. Please use the data type ISIN to get the ISIN code. The Sample DFO formula is like below. Once have ISIN codes from Datastream you could use those to pull the Eikon field as well.

=@DSGRID(&quot;FUSALL7","ISIN;NAME","Latest Value","","","RowHeader=true;ColHeader=true;SuppressComments=true;DispSeriesDescription=true;DispDatatypeDescription=true","")

All comments

raksina.samasiri

Hi @c.xue ,

The moderators on this forum do not have deep expertise in
every type of content available through Refinitiv products. Such expertise is
available through Refinitiv Helpdesk. If the Helpdesk can show you how to
retrieve it using =@TR formula in Eikon Excel, then
the moderators on this forum can help you translate it into get_data method in Eikon Data API call. Refinitiv Helpdesk can
be reached via MyRefinitiv.

To be of help, I have opened a support case on your behalf, case 11987018, please expect
an Eikon support expert to reach out to you shortly, via the email address you
registered on the developers portal.

wasin.w

Hello @c.xue

I found that case 11987018 is closed with the following resolution:

You can use the country of incorporation as the USA as well.

In case you have access to Datastream we have active and DEAD lists for each market. So, you could use these lists to fetch active and DEAD companies as well. Please use the data type ISIN to get the ISIN code. The Sample DFO formula is like below. Once have ISIN codes from Datastream you could use those to pull the Eikon field as well.

=@DSGRID(&quot;FUSALL7","ISIN;NAME","Latest Value","","","RowHeader=true;ColHeader=true;SuppressComments=true;DispSeriesDescription=true;DispDatatypeDescription=true","")

EXPLORE OUR SITES