How to get Close price of '.DXY' using get_data()?

Cannot access '.DXY' (DXY US DOLLAR CURRENCY INDEX) using get_data but get_timeseries() seems to work. It would be helpful to get it using get_data().

get_data throws NA values

ek.get_data('.DXY',fields = ['TR.CLOSEPRICE.date','TR.CLOSEPRICE'],parameters={'SDate':'2000-01-01','EDate':'2020-10-19','Frq':'D','CH':'Fd'})

get_timeseries() seems to work

ek.get_timeseries('.DXY',fields='CLOSE')

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

Try field name TR.PriceClose instead of TR.CLOSEPRICE

ek.get_data('.DXY', ['TR.PriceClose.date','TR.PriceClose'], 
            {'SDate':'2000-01-01','EDate':'2020-10-19'})

All comments

Alex Putkov.1

Try field name TR.PriceClose instead of TR.CLOSEPRICE

ek.get_data('.DXY', ['TR.PriceClose.date','TR.PriceClose'], 
            {'SDate':'2000-01-01','EDate':'2020-10-19'})

BlackBird

ek.get_data(['.MERH0A0','.MERC0A0','.MERG0Q0','.MERER00','.MEREG00','.MERWLCI'],fields = ['TR.PriceClose.date','TR.PriceClose'])

For these tickers TR.PriceClose doesn't seem to work, but TR.CLOSEPRICE does. Is there any way to get all prices using one TR function.

EXPLORE OUR SITES