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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
6 1 2 3

How to get close price in USD eikon data api ?

I am extracting futures data from different exchanges and would want the Prices to be in USD for all of them.

I am using the following code. How do I ensure that the prices are in USD.

df = ek.get_timeseries(['YAPc1'],['Open','Close','High','Low'],start_date = "2006-01-01", interval = 'daily', calendar = 'tradingdays')

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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
18k 21 12 20

Hi @ravi_ranjan

Here is the sample:

The first API call is using get_timeseries

The second API call is using get_data with identical data point.

The third API call is using get_data and convert data point to USD



ahs.png (70.6 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.

Upvotes
9.5k 10 5 7

Hello @ravi_ranjan

get_timeseries method does not support currency field. However, you can use get_data to get prices in USD. Please see the answer in the similar question, Requested field values from get_timeseries into different currencies

Hope this help.

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