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
18 1 2 1

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

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apipricing
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
Accepted
18 1 2 1

@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


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
3.8k 4 4 6

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