average/mean factor per sector/industry

Research
1

How can I find the average or mean value of a particular factor (D/E, ROE, current ratio, etc…) for each sector/industry.

Thanks
Tony

2

Hi Tony,
If you want a list of all the industries and the average value of a factor, then use the rules below in the screener:
FOrder(“MktCap”,#Industry,#desc) = 1
Showvar(@IndAvg, Aggregate(“ROE%TTM”, #Industry, #Avg))

You can do the same thing using #Sector in those formulas. Take a look at the help file for the Aggregate function if you are not familiar with it because you might want to override some default settings. For example, by default it trims 16.5% from each end and excludes ADRs.

3

Perfect! Thanks