COT report using EIkon API

varun.divakar

Hi,

I am trying to access the commitment of traders report for a market. The code I have used is follows:

data, err = e.get_data(["SB"], ["TR.COTR"],

{'SDate':str(dt.datetime.now().date()-dt.timedelta(days=14)),'EDate':str(dt.datetime.now().date()) })

The Error message is as follows:

'message': 'The formula must contain at least one field or function.',

I tried changing the TR.COTR with COTR and got the following message:

'message': "Error: Field 'COTR' was not found in response for the instrument 'SB'",

Please let me know how this data can be accessed. Thank you.

chavalit-jintamalit

Hi @varun.divakar

COTR or TR.COTR fields are not a valid field for SB ric code.

You can use Data Item Browser (type in DIB on Eikon to launch this app) to explore what fields are available.

You can also contact the Refinitiv Content Helpdesk at https://my.refinitiv.com/ to get help on the content such as if this field is available? if so, what is the field name.