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
sayan.bhattacharjee avatar image
1 ●2 ●1 ●3

Getting historical timeseries FX Rate

I want to get FXRate for a currency to USD for a list of dates. I want the output as a time-series. I can get it currently for a single date using something like this ek.get_data(["GBP="], ['CF_DATE','CF_CLOSE'])

How to convert this into a date range.

Thanks.

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apiforex
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.

2 Answers

· Write an Answer
Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

You need to use ek.get_timeseries for that such as described here

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.

sayan.bhattacharjee avatar image sayan.bhattacharjee

get_timeseries doesn't return any data, I have tried it several times, it works at times and at times it doesn't not sure why, is there any way using the get_data function?

nick.zincone avatar image nick.zincone sayan.bhattacharjee

Hi @sayan.bhattacharjee,

Can you be more specific as to the command you are using?

Upvote
nick.zincone avatar image
19k ●85 ●39 ●63

Hi @sayan.bhattacharjee,

Using the get_timeseries(), this is what I tried:


eikonscripting.png (19.3 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.