How to retrieve trace data using Eikon API

karleng.teo

I would like to retrieve trace data using API, how can I do so?

chavalit-jintamalit

Hi @karleng.teo

You can try this code:

df = ek.get_timeseries('88160RAD3=FINR', start_date='2021-04-01', end_date='2021-04-21', interval = 'tas', raw_output=True)
df

Then convert the json to dataframe:

df2 = pd.DataFrame(df['timeseriesData'][0]['dataPoints'])
df2

I could not find the "Conditions" information.

I think the FILTER_CODE2 is used to categorize the Buy/Sell.

But you should clarify the information with Refinitiv Content Helpdesk.

The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/

chavalit-jintamalit

Hi @karleng.teo

I would like to clarify what the trace data is.

Please provide some screenshots, thanks.

jonathan.legrand

Hi @karleng.teo,

By TRACE, do you mean Trade Reporting and Compliance Engine data?
In which case, you can use out Data Item Browser (DIB) to find fields of interests such as "GN_TX20_1", "GEN_TEXT16", "GN_TXT16_2", "GEN_VAL2", "GV1_TEXT", "ROW80_8", "LONGLINK1", "SPREADREF2", "EMAIL_ADRS", "OPTION_XD2", "TOT_ISSUES", "OPTION_XID", "GV5_TEXT", "DSPLY_NME2", "ISSUES_ADV", "ISSUES_DEC", "NEW_HIGHS", "NEW_LOWS", "TRDVOL_1", "ISSUES_UNC", ...

All numbers above can be changed at your convenience.

As an e.g.:

karleng.teo

Thanks @chavalit.jintamalit @jonathan.legrand

I am looking at bonds, this is the TRACE data that I am referring to.

karleng.teo

Hi @chavalit.jintamalit, thanks for this.

I've encountered another 404 error when I tried to input the Eikon login details. Could you also share what is the process to link to the Eikon login when trying to retrieve data using API?

chavalit-jintamalit

Hi @karleng.teo

Please follow this quick start guide.

https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/quick-start

karleng.teo

Thanks @chavalit.jintamalit

I realised the issue was because I was not using Python. Are there any REST APIs available, or is there any way I can use Java to get the data via API?

Otherwise, please let me know if there's a helpdesk I can call to get more assistance. Thank you.