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

question

Upvotes
Accepted
Rebecca avatar image
3 ●0 ●1 ●1

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiquery-string
icon clock
10 |1500

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

2 Answers

· Write an Answer
Upvotes
Accepted
nick.zincone avatar image
17.7k ●82 ●39 ●63

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"}



ahs.png (14.0 KiB)
icon clock
10 |1500

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

Upvotes
Rebecca avatar image
3 ●0 ●1 ●1
Thank you, it works.
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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