How to retrieve trace data using Eikon API

Question

Question by karleng.teo · Apr 19 at 09:45 AM · eikondataapi trace

How to retrieve trace data using Eikon API

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

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2021-04-21T05:00:56Z

REFINITIV

Best Answer

Answer by chavalit.jintamalit · Apr 21 at 05:00 AM

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)

1 Show 3 · Share

10 |1500 characters needed characters left characters exceeded

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

karleng.teo · May 04 at 09:39 AM 0

Share

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?

REFINITIV

chavalit.jintamalit ♦♦ karleng.teo · May 04 at 10:49 AM 0

Share

Hi @karleng.teo

Please follow this quick start guide.

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

karleng.teo chavalit.jintamalit ♦♦ · May 05 at 10:26 AM 0

Share

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.

Answer 2 · 2021-04-19T11:28:46Z

REFINITIV

Answer by chavalit.jintamalit · Apr 19 at 11:28 AM

Hi @karleng.teo

I would like to clarify what the trace data is.

Please provide some screenshots, thanks.

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 3 · 2021-04-20T14:52:59Z

REFINITIV

Answer by jonathan.legrand · Apr 20 at 02:52 PM

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)

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 4 · 2021-04-21T03:03:55Z

Answer by karleng.teo · Apr 21 at 03:03 AM

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)

0 · Share

10 |1500 characters needed characters left characters exceeded

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

How to retrieve trace data using Eikon API

4 Replies

Watch this question

Related Questions