What is the correct way of translating this historical excel query in to a ek_get_timeseries() or ek_get_data() Eikon Python API call?

Question

question

htan

1 ●0 ●0 ●1

=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}])

Oct 09, 2019 at 12:44 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Answer 1 · 2019-10-10T07:02:48Z

chavalit-jintamalit

18k ●21 ●12 ●20

Please try this code which gives you the same result.

ahs.png (126.2 KiB)

Oct 10, 2019 at 07:02 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.