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.

sandel avatar image sandel

for example:
ISIN : US0718131099 (SECD: 2085102)

2 Answers

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

@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.