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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonexchanges
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

Upvotes
Accepted
7.4k 10 6 8

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