get_data to fetch history of fx values

Hi there,

I am trying to use get_data from the eikon library for python in order to retrieve some historical values for fx pairs.

This is my code:

rics=['AUDCAD=','AUDCHF=']
fields=['TR.AMERICACLOSEBIDPRICE.date','TR.AMERICACLOSEBIDPRICE','OPEN_PRC','CF_HIGH','CF_LOW','CF_VOLUME']
df, err = ek.get_data(rics, fields, {'SDate': '2020-01-20', 'EDate': '2020-01-24', 'FRQ': 'D'})

The problem is, while AMERICACLOSEBIDPRICE returns the history as expected, the rest of the fields (open/high/low/volume) return only the latest available price, instead of historical.

I know for a fact that historical values are available, because via Excel API formula I can retrieve them using the below...

=RHistory($C$2:$C$3,"NDA_RAW.Nda_date;"&"NDA_RAW.Nda_open;"&"NDA_RAW.Nda_bid_close_america;"&"NDA_RAW.Nda_high;"&"NDA_RAW.Nda_low;"&"NDA_RAW.Nda_volume","START:20-Jan-2020:01:00 INTERVAL:1D",,"CH:In;Fd")

I am struggling finding the fields that would return as the same values as Excel does.

Could you help pls?

Thanks!

Find more posts tagged with

python

eikon

historical

forex

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

nick.zincone

Hi @lef_k,

If you pull up the DIB (Data Item Browser) within Eikon, and choose just to look at historical fields, you will see the list of available historical fields, i.e.

Not all are available but if you try using the get_timeseries() call, this should provide the fields (open/high/low/volume), i..e

All comments

nick.zincone

Hi @lef_k,

If you pull up the DIB (Data Item Browser) within Eikon, and choose just to look at historical fields, you will see the list of available historical fields, i.e.

Not all are available but if you try using the get_timeseries() call, this should provide the fields (open/high/low/volume), i..e

EXPLORE OUR SITES