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
sandel avatar image
18 ●0 ●0 ●1

Missing datatypes moving from Excel to Python

Hi,
I'm trying to translate an Excel request table in a Python download procedure.
I can't find the exact match for some static datatypes:

Excel fieldDescriptionPythonISINISINTR.ISINSECDSedolTR.SEDOLA4NAMEESG Company NameTR.CommonNameNAMEDatastream Security NameSECUR_NAME (no values returned)A4CURESG CurrencyCF_CURRA4STATUSDatastream Security Status

A4YEARESG Latest Fiscal Year

CLPACTYEARESG Actual Fiscal Year

CLPYEARENDESG Fiscal Year End DateTR.CompanyFYearEndENERDP124CO2 Estimation MethodTR.CO2EstimationMethodSOCODP066List of Critical Countries

CGBSDP019Board Structure TypeTR.BoardStructureTypeCGBSDP53Board Member Membership LimitsTR.BoardMembershipLimitsCGVSDP033CSR Sustainability External Auditor NameCSRReportingExternalAuditName


Using "Data Item Browser" I wasn't able to find out any correspondance for the empty cells.
Any hint will be appreciated.

python apifieldsdatastream
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.

zoya faberov avatar image   zoya faberov
Hello @sandel ,

It may be helpful to include the instrument you are working with, so the community can look at the same.

Thanks

sandel avatar image sandel

for example:
ISIN : US0718131099 (SECD: 2085102)

Jirapongse avatar image   Jirapongse

@sandel

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

2 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@sandel

Thanks for reaching out to us.

I found the following fields for the list of critical countries.

1663056425857.png

However, this forum is dedicated to software developers using Refinitiv APIs. The moderators on this forum do not have deep expertise in every bit of content available through Refinitiv products, which is required to answer content questions such as this one.

The best resource for content questions is the Eikon support team, which can be reached by submitting queries through MyRefinitv. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

I hope this will help.


1663056425857.png (105.9 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.

sandel avatar image sandel
It helped. Thank you!
Upvotes
sandel avatar image
18 ●0 ●0 ●1

untitled.png

sorry, here is the table. Hopefully clearer


untitled.png (77.0 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.

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.