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
kris.hilvano avatar image
1 ●0 ●0 ●2

How to retrieve data using page codes and parse specific data from a page Eikon API

Client using Eikon API Python and they have requested to retrieve list of Service Alerts from the RIC <ALERT>.

They wanted to know how they can generate the list of alerts? Also to create a column to identify the impacted market / region of the alert?

We have provided a sample syntax to retrieve how the page looks like on the Quote.

Attached screenshot of the sample syntax and output run in CodeBook.

We would like to ask if possible, to extract the impacted exchange out of the description column?

Also, the “Last Updated” column is in HH:MM DD format. Is it possible to add a column with Last Updated to follow a different format? e.g. YYYY-MM-DD HH:MM:SS?

Appreciate the assistance.codebook-alert-sample.png

eikon-data-api#contentpython apicodebook
codebook-alert-sample.png (190.6 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.

Jirapongse avatar image   Jirapongse

@kris.hilvano

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.4k ●253 ●52 ●74

@kris.hilvano

Thank you for reaching out to us.

The API will retrive each row as a string.

1691382361583.png

I think the Service and Description columns have not pattern. Therefore, it is quite hard to extract data from unpattern strings.

Regarding the Last Updated column, please contact the content support team direclty to verify if it is possible to change the time format. The APIs just get this data from the real-time service.

To parse the alerts data programatically, I think it is better to use the /service-insight/v1/ endpoints which are available on the Refinitiv Data Platform.

1691383192331.png

The client can contact the Refinitiv accout team or sales team to get more information about these endpoints.


1691382361583.png (86.3 KiB)
1691383192331.png (55.2 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.

kris.hilvano avatar image kris.hilvano

Hello Jirapongse,


Thank you so much for the inputs! Appreciate all the help!


Regards,

Kris Abby :)

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.