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","") 

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.