What is the correct way of translating this historical excel query in to a ek_get_timeseries() or...

htan

... ek_get_data() Eikon Python API call?

=RHistory(C1,"LAST_QUOTE.Timestamp;LAST_QUOTE.Close","START:09-Oct-2000
INTERVAL:1MO",,"TSREPEAT:NO SORT:ASC CH:Fd",C3)

C1="NA-SAS-MFZ"

C3="Timestamp"

Every
approach so far pretty much fail along these lines.

(
Instrument LAST_QUOTE.Timestamp LAST_QUOTE.Close

#0 NA-SAS-MFZ NaN NaN, [{'code': 251658244, 'col': 1, 'message': "Error: Field 'LAST_QUOTE.Timestamp'

#was
not found in response for the instrument 'NA-SAS-MFZ'", 'row': 0},
{'code': 251658244, 'col': 2, 'message': "Error: Field

#'LAST_QUOTE.Close'
was not found in response for the instrument 'NA-SAS-MFZ'", 'row': 0}])

chavalit-jintamalit

Hi @htan

Please try this code which gives you the same result.