Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 1

How to retrieve trace data using Eikon API

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

eikoneikon-data-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-apitrace
icon clock
10 |1500

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

Upvote
Accepted
18.2k 21 13 21

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/




ahs.jpg (57.5 KiB)
icon clock
10 |1500

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

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?

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.

Upvotes
18.2k 21 13 21

Hi @karleng.teo

I would like to clarify what the trace data is.

Please provide some screenshots, thanks.

icon clock
10 |1500

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

Upvotes
5.5k 21 2 6

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.:



1618930025179.png (126.4 KiB)
icon clock
10 |1500

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

Upvotes
1 0 1 1

Thanks @chavalit.jintamalit @jonathan.legrand

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


refinitiv-trace.png (68.3 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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