Is there a comprehensive list of all the potential country/region codes (across the global universe) in TR.BGS.GeoTotalRevenue.SegmentCode or an easy way to pull that together with the corresponding name?
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
Is there a comprehensive list of all the potential country/region codes (across the global universe) in TR.BGS.GeoTotalRevenue.SegmentCode or an easy way to pull that together with the corresponding name?
Hi @Harlan.tufford ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thank you,
AHS
@Harlan.tufford Thanks for your question - so please see the following example which actually contains the country names - this uses the Refinitiv Company Fundamentals content set:
df1 = rd.get_data(['VOD.L'], fields=['TR.F.GEOTotRevBizActiv(Period=FY0).SegmGeoIncl', 'TR.F.GEOTotRevBizActiv(Period=FY0).segmentName','TR.F.GEOTotRevBizActiv(Period=FY0)']) df1.sort_values('Standardized Revenue - Geographic Segment', ascending=False, inplace=True) df1.reset_index(inplace=True) df1
Note: the first row is the Total for all segments. I hope this can help.
Kindest regards,