How do I access data in my Jupyter Notebook for which there is no field in Data Item Browser?

In the Eikon Desktop I can see the following UK RNS Announcements data in Ownership -> UK RNS Announcements:

But these data fields do not appear in the Data Item Browser and thus I do not know how I can pull it from the API. Please would someone give me the code that will allow me to get this data in my Jupyter Notebook?

Thanks

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @bill39

Usually for content fields related question, please follow @Gurpreet suggestion to raise the query to Refinitiv Content Helpdesk.

For this specific question, I think you can use this sample code:

df, e = ek.get_data(['AEFS.L'],
                    [
                        'TR.RNSFilerName',
                        'TR.RNSAnnouncedDate',
                        'TR.RNSTransactionType',
                        'TR.RNSARNumShrsTransacted',
                        'TR.RNSARPctOSTransacted',
                        'TR.RNSARTransactionPrice',
                        'TR.RNSARMktValTransaction',
                        'TR.RNSARTotShrsPostTrans',
                        'TR.RNSARPctOSPostTrans'
                    ])
df.head()

This is sample output:

All comments

Gurpreet

Hi @bill39

This forum is for technical API related queries.

For content-type questions, please raise a Content query from MyRefinitiv which will allow you direct communication with a Content expert.

Select 'I need help understanding content within the product' and appropriate product e.g. 'Eikon'.

chavalit-jintamalit

Hi @bill39

Usually for content fields related question, please follow @Gurpreet suggestion to raise the query to Refinitiv Content Helpdesk.

For this specific question, I think you can use this sample code:

df, e = ek.get_data(['AEFS.L'],
                    [
                        'TR.RNSFilerName',
                        'TR.RNSAnnouncedDate',
                        'TR.RNSTransactionType',
                        'TR.RNSARNumShrsTransacted',
                        'TR.RNSARPctOSTransacted',
                        'TR.RNSARTransactionPrice',
                        'TR.RNSARMktValTransaction',
                        'TR.RNSARTotShrsPostTrans',
                        'TR.RNSARPctOSPostTrans'
                    ])
df.head()

This is sample output:

bill39

What changes do I need to make to the code so that:

a) the request is for a list of c.400 stocks that I have created in Eikon

b) the request pulls data for the time period today to 1 year previous on a trailing basis (i.e. if I repeat the request in one week the period will have shifted one week forward)

Thanks

Gurpreet

Accepting the answer, since the original question was answered.

EXPLORE OUR SITES