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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
18 0 0 0

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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonpricing
icon clock
10 |1500

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

Upvotes
Accepted
18 0 0 0

@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 5.0 MiB each and 10.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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea