How to get BID/ASK/Open Interest in TAS under Eikon Excel via Python (Eikon API) for Sample RIC ?

Question

Question by Xia.Liu · Feb 19, 2020 at 02:18 PM · eikon eikon-data-api workspace refinitiv-dataplatform-eikon workspace-data-api python pricing

How to get BID/ASK/Open Interest in TAS under Eikon Excel via Python (Eikon API) for Sample RIC ?

There is BID/ASK/Open interest data in TAS in Eikon Excel for sample RIC <SZNc3>, but client cannot retrieve via Eikon API (through Python).

Sample formula in Eikon Excel:

=RHistory("SZNc3","TRDPRC_1.Timestamp;"&"TRDPRC_1.Bid;"&"TRDPRC_1.Ask;"&"TRDPRC_1.Opint_1;"&"TRDPRC_1.Trdprc_1","INTERVAL:TAS",,"CH:Fd",B2)

Would you kindly advise why?

Thanks & Regards,

Xia

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 · 2020-02-27T04:41:00Z

REFINITIV

Best Answer

Answer by Xia.Liu · Feb 27, 2020 at 04:41 AM

@marcin.bunkowski Hello Marcin, very sorry for late response (I was not able to log in Develop community for many times.)

You advise helped client fix the issue.

Many thanks!

Best Regards,

Xia

@jirapongse.phuriphanvichai

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 2 · 2020-02-19T14:31:00Z

REFINITIV

Answer by marcin.bunkowski · Feb 19, 2020 at 02:31 PM

Hi @Xia.Liu

Try this

df = ek.get_timeseries('SZNc3',['Timestamp','BID','ASK','Opint_1','Trdprc_1'], start_date = "2020-02-18T06:00:00", end_date = "'2020-02-18T21:00:00", interval="tas")
df

ahs.jpg (116.0 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 get BID/ASK/Open Interest in TAS under Eikon Excel via Python (Eikon API) for Sample RIC ?

2 Replies

Watch this question

Related Questions