How to get close price in USD eikon data api ?

Question

question

ravi_ranjan

6 ●1 ●2 ●3

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')

Oct 14, 2019 at 11:41 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Answer 1 · 2019-10-14T13:34:09Z

chavalit-jintamalit

18k ●21 ●12 ●20

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)

Oct 14, 2019 at 01:34 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Answer 2 · 2019-10-14T12:41:16Z

pimchaya.wongrukun01

9.5k ●10 ●5 ●7

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.

Oct 14, 2019 at 12:41 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.