Eikon API: Get Data - Constituents as of a certain date

Question

question

Joris.Hoendervangers

166 ●10 ●17 ●21

Is it possible to get the constituents of an index at a given date?

In Excel we can use the following formula:

=TR("0#.AEX","TR.RIC","SDate=2016-12-31")

With the Eikon API, this works:

rics, err = eikon.get_data("0#.AEX","TR.RIC")
rics

But this doesn't work:

rics, err = eikon.get_data("0#.AEX","TR.RIC", "SDate=2016-12-31")
rics

It results in the following error:

JSONDecodeError: Expecting value: line 1 column 1 (char 0)

Thank you so much in advance for your help!

Aug 03, 2017 at 02:53 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.

Answer 1 · 2017-08-03T04:58:07Z

Jirapongse

38.1k ●71 ●35 ●53

It is similar to this question.

rics, err = ek.get_data(instruments="0#.AEX", fields=["TR.RIC"], parameters={'SDate':'2016-12-31'})

Aug 03, 2017 at 04:58 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.

Answer 2 · 2017-08-03T06:47:14Z

Joris.Hoendervangers

166 ●10 ●17 ●21

Or:

rics, err = eikon.get_data("0#.AEX(2016-12-31)","TR.RIC")

Aug 03, 2017 at 06:47 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.