Hello,
I have a list of about 1500 Organization IDs which are all Eikon-generated in a previous step of my analysis, using "TR.OrganizationID" (on a very large list of some fixed income instrument CUSIP numbers).
When using said list with the Eikon API (Python), I only get output for a small fraction of these 1500 IDs.
I manually checked for the existence of the IDs and found that in the Data Item Browser they do have the variables I am interested in.
The underlying python function for the API:
def Eikon_Function(ID_List,k,m,field_inputs,date_param, add_param1 = None, add_param2 = None):
panda_df , err= ek.get_data(ID_List[k:m], fields=field_inputs, parameters={'SDate': date_param, add_param1: add_param2})
I only use a maximum of 500 IDs per request (see k:m).
I only request one field per request.
I did not include any additional parameters.
Some simple variables I was checking:
field_inputs = TR.HeadquartersCountry
field_inputs = TR.TRBCBusinessSector
field_inputs = TR.CoRPrimaryCountry
The following random list:
[4296016896, 4296020480, 4296020992, 4296022016, 4296025600]
gives the following results:
- All 5 yield the headquarters country
- Items 2,3,5 yield the Business Sector
- Item 3 yields the country of primary risk
(however, overall the HQ variable also has missing output for about 10%)
In short: How can I fix this issue?
Best,
Markuss