Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
chong.xu avatar image
11 ●6 ●4 ●7

RHistory to Python ---- RIC DRYC-NTLKHH-COA

Hi,

I am trying to convert the following Excel formula to Python version.

Excel formula:

=RHistory("DRYC-NTLKHH-COA","NDA_RAW.Nda_date;NDA_RAW.Nda_last","START:01-Jan-2017 END:15-Feb-2018 INTERVAL:1D",,"CH:Fd",B2)

My Python code:

df = ek.get_timeseries( [ 'DRYC-NTLKHH-COA' ], fields='NDA_RAW.Nda_last', start_date = dt.datetime(2017, 1, 1, 0, 0, 0, 0 ), end_date = dt.datetime(2018, 2, 15, 0, 0, 0, 0 ), interval='daily', count = None, calendar = None, corax = None, normalize = False, raw_output = False, debug = False)

However, the code returns no value. Could you please help? Thanks very much.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-com-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvote
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

Remove the fields parameter from your request. Try
ek.get_timeseries( [ 'DRYC-NTLKHH-COA' ], start_date = dt.datetime(2017, 1, 1), end_date = dt.datetime(2018, 2, 15))

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

chong.xu avatar image chong.xu

Thanks very much Alex. Working perfectly now.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.