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
justo.conde avatar image
1 ●0 ●0 ●1

Obtain information of a set of instruments with Eikon Data API

I'm trying to obtain information of the set 0#CFI2. The elements are CFI2U3, CFI2V3, CFI2X3, etc.

With the function ek.get_timeseries('0#CFI2+', 'BID') I have a invalid RIC error. With the function ek.get_data('0#CFI2+', 'BID') I have a message "the record couldn't be found". For a single instrument (e.g. CFI2U3 it works properly).

I would like to know if there is a generic way to download information of the set. I want to avoid to list all the RICs because they change in rolling times.

Thank you in advance

api#contentpython 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.

2 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
80k ●257 ●52 ●75

@justo.conde

Thank you for reaching out to us.

It works with 0#CFI2:.

df, err = ek.get_data("0#CFI2:", fields =['BID','DSPLY_NAME'])
df

The output is:

1691651353190.png

Then, you can use RICs in the returned dataframe with the get_timeseries method.

ek.get_timeseries(df["Instrument"].tolist(),fields=['CLOSE'])

1691651617500.png

You can use the Eikon Quote APP to show RICs in 0#CFI2+. I don't have permission to access this RIC.


1691651353190.png (26.9 KiB)
1691651617500.png (27.3 KiB)
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.

Upvotes
justo.conde avatar image
1 ●0 ●0 ●1

Many thanks

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.

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.