Field for currency in timeseries

Hi, I'm using Eikon to pull data into Python. This is the line I use to pull data:

ek.get_timeseries(sym,start_date='2016-03-03',end_date= sheet['B4'].value, interval = 'daily')['CLOSE']

where 'sym' is a variable for RIC that keeps changing. The RICs I'm using all have different currencies. I was wondering if there was a way to define the currency in which I want the data to be pulled within the timeseries function or if there was any other way to do this. Thanks!

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    get_timeseries method can only return price history in the currency in which the instrument is traded. If your instruments are stocks or indices you can use get_data method with TR.PriceClose field, which can return price history in the currency of your choice:

    ek.get_data('AAPL.O',['TR.PriceClose.date;TR.PriceClose'],
    {'SDate':'2019-05-01', 'EDate':'2019-07-01', 'CURN':'JPY'})

Answers