Eikon item TR.ShareholderApprovalStockCompPlan

c.xue
c.xue
in Eikon Data APIs

Hi,

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

for all US firms from 2000 to 2021?

Thanks

Tagged:

Best Answer

  • wasin.w
    wasin.w admin
    Answer ✓

    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("FUSALL7","ISIN;NAME","Latest Value","","","RowHeader=true;ColHeader=true;SuppressComments=true;DispSeriesDescription=true;DispDatatypeDescription=true","")

Answers

  • raksina.samasiri
    raksina.samasiri admin

    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.

Categories