For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

How to query following excel function from eikon data api in python

=TR("MSFT.O","TR.BGS.GeoTotalRevenue"," Period=FQ0 CH=Fd;segmentName;fperiod RH=IN") gives the regional revenue breakdown

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
13k 32 12 18

Hi @hovadop416,

You can try something like this:

>> ek.get_data('MSFT.O', ['TR.BGS.GeoTotalRevenue', 'TR.BGS.GeoTotalRevenue.segmentName'], parameters={'Period': 'FQ0'})

(  Instrument  Geographic Total Revenues (Calculated)        Segment Name
0     MSFT.O                             17428000000       United States
1     MSFT.O                             17593000000     Other countries
2     MSFT.O                             35021000000       Segment Total
3     MSFT.O                             35021000000  Consolidated Total, None)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
9.7k 49 38 60

Hi @hovadop416,

Please see this answer.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea