How to retrieve trace data using Eikon API

karleng.teo

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

Find more posts tagged with

eikon

trace

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

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/

All comments

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.

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/

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

EXPLORE OUR SITES