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

hovadop416

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

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.