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

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Gurpreet

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)

All comments

Gurpreet

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)

nick.zincone

Hi @hovadop416,

Please see this answer.

EXPLORE OUR SITES