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
3 2 3 4

How to i retrieve Bid and Ask price in Time Series with ek.get_timeseries for EUR= and GBP=

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

@avishen.bablee

Thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

@avishen.bablee

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

Upvotes
Accepted
39.4k 77 11 27

@avishen.bablee

If I understand correctly, you'd like to retrieve intraday price history for BID and ASK quotes for FX spot RICs. If this is the case, you can do it using RDP Library. See an example on this previous thread.

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
79.1k 250 52 74

@avishen.bablee

The ek.get_timeseries method can't get Bid and Ask price for EUR= and GBP=. You need to use the ek.get_data method instead, as shown below.

df, err = ek.get_data(["EUR=",'GBP='],
                      ["TR.BIDPRICE.Date","TR.BIDPRICE", "TR.ASKPRICE"], 
                      {"SDate":"0","EDate":"-10"})
                       
df  


1621576065244.png (28.2 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.

@jirapongse.phuriphanvichai How do I set date and time to retrieve todays date at specific time. i am not able to retrieve data for MUR=MAUB. How do i add a calculated field. Say BID + ASK

Thanks

Upvotes
24.7k 54 17 14

Hello @avishen.bablee

Sorry for the late reply. I do not think you can query data at a specific time. I suggest you use the Eikon/Workspace Data Item Browser app to verify if the instrument, your interested fields, and interval are available or not.
Please see this post for more detail.

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.