Is there a way to call on Geographic revenue via a Segment Code or Name?

C_T

I am using Excel and while I can call on a company's Geographical data as a whole using =TR($A$2,"TR.Revenue;TR.BGS.GeoTotalRevenue.currency;TR.BGS.GeoTotalRevenue.fperiod;TR.BGS.GeoTotalRevenue.segmentName;TR.BGS.GeoTotalRevenue;TR.BGS.GeoTotalRevenue.fperiod;TR.BGS.BusExternalRevenue.segmentName;TR.BGS.BusExternalRevenue;TR.BGS.BusExternalRevenu"&"e","CH=Fd RH=IN",B3)
I would like to create in a cell, where I can input a Segment Code (for example CHN for China) and call Only the external revenues associated with that particular Country code for the particular RIC list. Is this possible?

Jirapongse

@C_T

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs.

For the questions regarding the Eikon Excel, please contact the Eikon or Workspace Excel support directly via MyAccount and ask for the parameters in the TR.BGS.xxx fields that can filter the output by segment codes.

C_T

https://community.developers.refinitiv.com/discussion/comment/123989#Comment_123989

Is there a way I can do this Via the API? The exact same question as I am also looking to do it through the API also, I just thought it would be easier to ask in Excel language as I am new to coding etc. Is it possible to do this via the API using Python code?

jason.ramchandani01

@C_T So you can just bring in all the geographic sectors into excel and then filter them after for whichever region you are interested in - you can check the Data Item Browser app (type DIB into Eikon search). We have an example of how to programmatically get geographical segment level data in our Codebook App (type CODEBK into Eikon/WS search bar) and navigate to the following example: Examples/05. Equity Research/Segment_Data.ipynb - there you will find all the python code required - you just need to run it.

I hope this can help.