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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
hans-hermann.kiessig avatar image
1 ●0 ●0 ●3

Eikon via Python Unable to Collect Data For Some Fields

Hi,

we are trying to retrieve Corporate Event data via the Python Eikon module and its get_data() function. Normally this works just fine. However, today we submitted a query which was answered successfully. After that we submitted the same query which received a partial answer. Some fields were empty and the following information was provided:

[{'code': 415, 'col': 1, 'message': 'Unable to collect data for some field(s).', 'row': 0}, {'code': 415, 'col': 2, 'message': 'Unable to collect data for some field(s).', 'row': 0}, {'code': 415, 'col': 11, 'message': 'Unable to collect data for some field(s).', 'row': 0}]


Example RIC : 'BLK.DE'


1634113478074.png


Can you please explain why that happens and how to resolve this issue?

Best regards,

Hans





eikoneikon-data-apipython
1634113478074.png (13.7 KiB)
icon clock
10 |1500

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

4 Answers

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@hans-hermann.kiessig

I have removed the TR.CACorpEventType field and changed the value of the SDate parameter.

l = ['BLK.DE']

fields = [ 'TR.CACorpActEventType', 'TR.CACorpActDate', 'TR.EventType', 
          'TR.EventTitle', 'TR.EventStartDate', 'TR.EventStartTime', 
          'TR.EventEndTime', 'TR.EventStatus', 'TR.EventCountry', 
          'TR.EventLastUpdate', 'TR.DivEventStatus','EXDIVDATE', 
          'DIVPAYDATE', 'CF_YIELD', 'CF_CURR', 'TR.ISIN']

vals = {'SDate': '-1Y', 'EDate': '0AY'}

df_out, info = ek.get_data( l, fields, vals )

df_out


I got the following response.

1634792929631.png


I think this field TR.CACorpEventType is invalid.


1634792929631.png (25.0 KiB)
icon clock
10 |1500

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

Upvotes
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

@hans-hermann.kiessig Sorry to hear this please could you paste the API call code so we can try to replicate. thanks.

icon clock
10 |1500

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

hans-hermann.kiessig avatar image hans-hermann.kiessig
Hi, have you seen my reply below?
Upvotes
hans-hermann.kiessig avatar image
1 ●0 ●0 ●3

Hi,

here is our API call:


import eikon as ek


l = ['BLK.DE']

fields = ['TR.CACorpEventType', 'TR.CACorpActEventType', 'TR.CACorpActDate', 'TR.EventType', 'TR.EventTitle', 'TR.EventStartDate', 'TR.EventStartTime', 'TR.EventEndTime', 'TR.EventStatus', 'TR.EventCountry', 'TR.EventLastUpdate', 'TR.DivEventStatus', 'EXDIVDATE', 'DIVPAYDATE', 'CF_YIELD', 'CF_CURR', 'TR.ISIN']

vals = {'SDate': '1AW', 'EDate': '0AY'}


df_out, info = ek.get_data( l, fields, vals )


Best,

Hans


icon clock
10 |1500

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

hans-hermann.kiessig avatar image hans-hermann.kiessig

We have eikon version 1.1.12 and Python (Windows) version 3.8.3

Upvotes
wasin.w avatar image
11.5k ●16 ●7 ●10

Hello @hans-hermann.kiessig

I did a quick check with the Data Item Browser app ("DIB" in Eikon/Workspace) based on @Jirapongse answer, I cannot find the field TR.CACorpEventType too.

data-item-browser.png

You can use the Data Item Browser app to verify the available fields of that item.


data-item-browser.png (66.0 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea