Dear Sir or Madam, I have a question about firms' segment information. Specifically, I am looking for historical data on the revenue of each segment for firms, or the fraction of each segment’s revenue. Which instrument provides the information? Is Instrument: TR.F.BUSSegRevPct appropriate to use for this purpose? Could you please clarify the meaning of each value provided by this instrument? For example, the instrument returns multiple values, but it is not clear what the first, second, third, fourth this instrument provides the following results. It is not clear what is the first/second/third…seventh values represent. It also seems that the order of items varies across firms. Instrument Date Segment Revenue - % - Business Segment 1 1332.T 2002/3/31 100 2 1332.T 2002/3/31 46.2397 3 1332.T 2002/3/31 2.60481 4 1332.T 2002/3/31 3.77573 5 1332.T 2002/3/31 1.0705 6 1332.T 2002/3/31 46.30865 7 1332.T 2002/3/31 -16.8528 10 1377.T 2002/5/31 100 11 1377.T 2002/5/31 27.00127 12 1377.T 2002/5/31 62.22323 13 1377.T 2002/5/31 10.7755 14 1377.T 2002/5/31 -1.33885 21 1515.T 2002/3/31 -1.26335 22 1515.T 2002/3/31 82.06603 23 1515.T 2002/3/31 2.14206 24 1515.T 2002/3/31 100 25 1515.T 2002/3/31 14.04013 26 1515.T 2002/3/31 -1.26335 27 1515.T 2002/3/31 1.75065 I also use Instrument "TR.SegmentRevenueActValue". But it seems that the instrument provides historical data. Instrument Date Segment Revenue - Actual 0 7203.T 2020/3/31 1.93E+13 1 7203.T 2020/3/31 2.19E+13 2 7203.T 2020/3/31 6.31E+12 3 7203.T 2020/3/31 8.99E+12 4 7203.T 2020/3/31 4.52E+12 5 7203.T 2020/3/31 -1.1E+12 6 7203.T 2020/3/31 -1.3E+13 7 7203.T 2020/3/31 4.48E+12 8 7203.T 2020/3/31 4.32E+13 9 7203.T 2020/3/31 1.45E+12 10 7203.T 2021/3/31 11 7203.T 2021/3/31 12 7203.T 2021/3/31 13 7203.T 2021/3/31 14 7203.T 2021/3/31 15 7203.T 2021/3/31 16 7203.T 2021/3/31 17 7203.T 2021/3/31 18 7203.T 2021/3/31 19 7203.T 2021/3/31 20 7203.T 2022/3/31 21 7203.T 2022/3/31 22 7203.T 2022/3/31 23 7203.T 2022/3/31 24 7203.T 2022/3/31 25 7203.T 2022/3/31 26 7203.T 2022/3/31 27 7203.T 2022/3/31 28 7203.T 2022/3/31 29 7203.T 2022/3/31 30 7203.T 2023/3/31 31 7203.T 2023/3/31 32 7203.T 2023/3/31 33 7203.T 2023/3/31 34 7203.T 2023/3/31 35 7203.T 2023/3/31 36 7203.T 2023/3/31 37 7203.T 2023/3/31 38 7203.T 2023/3/31 39 7203.T 2023/3/31 40 7203.T 2024/3/31 41 7203.T 2024/3/31 42 7203.T 2024/3/31 43 7203.T 2024/3/31 44 7203.T 2024/3/31 45 7203.T 2024/3/31 46 7203.T 2024/3/31 47 7203.T 2024/3/31 48 7203.T 2024/3/31 49 7203.T 2024/3/31 50 7203.T 2025/3/31 51 7203.T 2025/3/31 52 7203.T 2025/3/31 53 7203.T 2025/3/31 54 7203.T 2025/3/31 55 7203.T 2025/3/31 56 7203.T 2025/3/31 57 7203.T 2025/3/31 58 7203.T 2025/3/31 59 7203.T 2025/3/31 60 6758.T 2020/3/31 1.51E+12 61 6758.T 2020/3/31 9.63E+10 62 6758.T 2020/3/31 2.41E+12 63 6758.T 2020/3/31 1.8E+12 64 6758.T 2020/3/31 9.31E+11 65 6758.T 2020/3/31 -3E+11 66 6758.T 2020/3/31 1.84E+12 67 6758.T 2020/3/31 4.67E+12 68 6758.T 2021/3/31 69 6758.T 2021/3/31 70 6758.T 2021/3/31 71 6758.T 2021/3/31 72 6758.T 2021/3/31 73 6758.T 2021/3/31 74 6758.T 2021/3/31 75 6758.T 2021/3/31 76 6758.T 2022/3/31 77 6758.T 2022/3/31 78 6758.T 2022/3/31 79 6758.T 2022/3/31 80 6758.T 2022/3/31 81 6758.T 2022/3/31 82 6758.T 2022/3/31 83 6758.T 2022/3/31 84 6758.T 2023/3/31 85 6758.T 2023/3/31 86 6758.T 2023/3/31 87 6758.T 2023/3/31 88 6758.T 2023/3/31 89 6758.T 2023/3/31 90 6758.T 2023/3/31 91 6758.T 2023/3/31 92 6758.T 2024/3/31 93 6758.T 2024/3/31 94 6758.T 2024/3/31 95 6758.T 2024/3/31 96 6758.T 2024/3/31 97 6758.T 2024/3/31 98 6758.T 2024/3/31 99 6758.T 2024/3/31 100 6758.T 2025/3/31 101 6758.T 2025/3/31 102 6758.T 2025/3/31 103 6758.T 2025/3/31 104 6758.T 2025/3/31 105 6758.T 2025/3/31 106 6758.T 2025/3/31 107 6758.T 2025/3/31

Segment information

Dear Sir or Madam,

I have a question about firms' segment information.

Specifically, I am looking for historical data on the revenue of each segment for firms, or the fraction of each segment’s revenue.

Which instrument provides the information?

Is Instrument: TR.F.BUSSegRevPct appropriate to use for this purpose?

Could you please clarify the meaning of each value provided by this instrument?

For example, the instrument returns multiple values, but it is not clear what the first, second, third, fourth this instrument provides the following results. It is not clear what is the first/second/third…seventh values represent.

It also seems that the order of items varies across firms.

	Instrument	Date	Segment Revenue - % - Business Segment
1	1332.T	2002/3/31	100
2	1332.T	2002/3/31	46.2397
3	1332.T	2002/3/31	2.60481
4	1332.T	2002/3/31	3.77573
5	1332.T	2002/3/31	1.0705
6	1332.T	2002/3/31	46.30865
7	1332.T	2002/3/31	-16.8528
10	1377.T	2002/5/31	100
11	1377.T	2002/5/31	27.00127
12	1377.T	2002/5/31	62.22323
13	1377.T	2002/5/31	10.7755
14	1377.T	2002/5/31	-1.33885
21	1515.T	2002/3/31	-1.26335
22	1515.T	2002/3/31	82.06603
23	1515.T	2002/3/31	2.14206
24	1515.T	2002/3/31	100
25	1515.T	2002/3/31	14.04013
26	1515.T	2002/3/31	-1.26335
27	1515.T	2002/3/31	1.75065

I also use Instrument "TR.SegmentRevenueActValue". But it seems that the instrument provides historical data.

	Instrument	Date	Segment Revenue - Actual
0	7203.T	2020/3/31	1.93E+13
1	7203.T	2020/3/31	2.19E+13
2	7203.T	2020/3/31	6.31E+12
3	7203.T	2020/3/31	8.99E+12
4	7203.T	2020/3/31	4.52E+12
5	7203.T	2020/3/31	-1.1E+12
6	7203.T	2020/3/31	-1.3E+13
7	7203.T	2020/3/31	4.48E+12
8	7203.T	2020/3/31	4.32E+13
9	7203.T	2020/3/31	1.45E+12
10	7203.T	2021/3/31
11	7203.T	2021/3/31
12	7203.T	2021/3/31
13	7203.T	2021/3/31
14	7203.T	2021/3/31
15	7203.T	2021/3/31
16	7203.T	2021/3/31
17	7203.T	2021/3/31
18	7203.T	2021/3/31
19	7203.T	2021/3/31
20	7203.T	2022/3/31
21	7203.T	2022/3/31
22	7203.T	2022/3/31
23	7203.T	2022/3/31
24	7203.T	2022/3/31
25	7203.T	2022/3/31
26	7203.T	2022/3/31
27	7203.T	2022/3/31
28	7203.T	2022/3/31
29	7203.T	2022/3/31
30	7203.T	2023/3/31
31	7203.T	2023/3/31
32	7203.T	2023/3/31
33	7203.T	2023/3/31
34	7203.T	2023/3/31
35	7203.T	2023/3/31
36	7203.T	2023/3/31
37	7203.T	2023/3/31
38	7203.T	2023/3/31
39	7203.T	2023/3/31
40	7203.T	2024/3/31
41	7203.T	2024/3/31
42	7203.T	2024/3/31
43	7203.T	2024/3/31
44	7203.T	2024/3/31
45	7203.T	2024/3/31
46	7203.T	2024/3/31
47	7203.T	2024/3/31
48	7203.T	2024/3/31
49	7203.T	2024/3/31
50	7203.T	2025/3/31
51	7203.T	2025/3/31
52	7203.T	2025/3/31
53	7203.T	2025/3/31
54	7203.T	2025/3/31
55	7203.T	2025/3/31
56	7203.T	2025/3/31
57	7203.T	2025/3/31
58	7203.T	2025/3/31
59	7203.T	2025/3/31
60	6758.T	2020/3/31	1.51E+12
61	6758.T	2020/3/31	9.63E+10
62	6758.T	2020/3/31	2.41E+12
63	6758.T	2020/3/31	1.8E+12
64	6758.T	2020/3/31	9.31E+11
65	6758.T	2020/3/31	-3E+11
66	6758.T	2020/3/31	1.84E+12
67	6758.T	2020/3/31	4.67E+12
68	6758.T	2021/3/31
69	6758.T	2021/3/31
70	6758.T	2021/3/31
71	6758.T	2021/3/31
72	6758.T	2021/3/31
73	6758.T	2021/3/31
74	6758.T	2021/3/31
75	6758.T	2021/3/31
76	6758.T	2022/3/31
77	6758.T	2022/3/31
78	6758.T	2022/3/31
79	6758.T	2022/3/31
80	6758.T	2022/3/31
81	6758.T	2022/3/31
82	6758.T	2022/3/31
83	6758.T	2022/3/31
84	6758.T	2023/3/31
85	6758.T	2023/3/31
86	6758.T	2023/3/31
87	6758.T	2023/3/31
88	6758.T	2023/3/31
89	6758.T	2023/3/31
90	6758.T	2023/3/31
91	6758.T	2023/3/31
92	6758.T	2024/3/31
93	6758.T	2024/3/31
94	6758.T	2024/3/31
95	6758.T	2024/3/31
96	6758.T	2024/3/31
97	6758.T	2024/3/31
98	6758.T	2024/3/31
99	6758.T	2024/3/31
100	6758.T	2025/3/31
101	6758.T	2025/3/31
102	6758.T	2025/3/31
103	6758.T	2025/3/31
104	6758.T	2025/3/31
105	6758.T	2025/3/31
106	6758.T	2025/3/31
107	6758.T	2025/3/31

Find more posts tagged with

variable

Accepted answers

All comments

Jirapongse

@saku

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

Otherwise, you can use the Data Item Browser tool to search for fields including their parameters and descriptions.

Please include the URL of this discussion in your raised question to prevent it from being redirected back to this Q&A forum.

saku

Dear Jirapongse,

Thank you for your reply.

I am not able to find where I can ask a question. AI responds to my question, but it does not address my question.

But there is a question like this.

I wonder if you could advise me how to get segment revenue information. Thank you so much for your help.

セグメント情報に関する質問１.png

I also find a line like this.

https://developers.lseg.com/en/article-catalog/article/get-fundamentals-company-geographic-sales-breakdown-workspace

raksina.samasiri

Hi @saku ,

Thank you for participating in this forum. As mentioned by my colleague that the kind of content-related question like this one, you should ordinarily open a ticket at Home | LSEG Support. However as you appear to be an Academic user I believe you need to get the Workspace admin team at your institution to raise a query on your behalf.

I hope this could help and please let me know in case you have any further questions.

JasonRamchandani01

@saku Thanks for your question - so here is how you can retrieve segment information:

revSegments = ld.get_data(universe=['RTX'],

fields=['TR.F.BUSTotRevBizActiv.fperiod','TR.F.BUSTotRevBizActiv.segmentName','TR.F.BUSTotRevBizActiv'],

parameters ={'Period': 'FY0', 'SDate': 'FY0', 'EDate':'FY-2'}

)

revSegments

In the output above you can see the Segment Names are listed in descending size order for each year - with a blank segment listed as the last entry for each year - this is the Sum (Total) of all the segments. The business segment taxonomy also includes some more accounting related entries - which you may want to remove and can do so as follows (including or excluding any entries you may want) - I have included the ones I found across a large universe of companies.

exclSegments = ['General Corporate Expenses','','Eliminations and Other','Unallocated','Eliminations','Elimination','Consolidated Total','Segment Total','-','Intersegment','Consolidation','Intersegment Transfer','Intersegment Transfers','Intersegment Eliminations','Intersegment Elimination','Eliminations/Discontinued Operations','Unallocated and Other','All Other','Unallocated Amounts','Unallocated','Other Consolidated Adjustments','Reconcilliations and Eliminations','Eliminations/Other','Reconcilliation and Elimination','Reconciling Amounts','Special Items','Other Financial Services','Other','Reconciliations','All Other Segments','Elimination and Coporate Items','Corporate','Unallocated & Other Items','Others','Unallocated Items','Consolidation Elimination','Corporate & Eliminations','FAS/CAS Adjustment']

revSegments = revSegments[revSegments.columns[2]].values

rev_seg_list = list(set(revSegments) - set(exclSegments))

rev_seg_list = sorted(rev_seg_list, key=str.lower)

rev_seg_list

So you have a clean list of the segments available. Note: you probably want to filter segments for each year as some businesses get add or disposed of and therefore may not be available in some years.

I hope this can help. Let us know how you get on.

saku

Thank you very much for your explanation.

EXPLORE OUR SITES