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

Rebecca

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

nick.zincone

Hi @Rebecca,

Try this:

df, err = ek.get_data('MSFT.O', ['TR.BGS.GeoTotalRevenue', 'TR.GBS.GeoTotalRevenue.segmentcode', 'TR.GBS.GeoTotalRevenue.fperiod'],  {"Period":"FQ0", "Frq":"FQ"}

Rebecca

Thank you, it works.