How to get close price in USD eikon data api ?

ravi_ranjan · October 2019

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

chavalit-jintamalit · October 2019

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

pimchaya.wongrukun01 · October 2019

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.

Best Answer