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
YanHan avatar image
1 ●0 ●1 ●1

get exchange rate on a certain time

Hi,

May I ask how to get the traded exchange rate of EUR/USD on 5:00 P.M. by ek.get_timeseries?

Thank you

eikoneikon-data-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-apiexchanges
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.

1 Answer

· Write an Answer
Upvotes
Accepted
jason.ramchandani01 avatar image
10.3k ●18 ●6 ●9

@YanHan Please try the following - I hope this can help

df1 = ek.get_timeseries('EUR=','CLOSE',interval='hour')
df1['hour'] = df1.index.hour
df1[df1['hour']== 17]

1624289436995.png



1624289436995.png (66.8 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.