Sector average data for a specific stock

luyu

How to get sector average data for specific stock, e.g., find average P/E ratio for the sector that AAPL.O is in? Is there an example?

Zhenya Kovalyov

Yes, with the use of screening functions (for sector) or peer service (for peers). The following code gives you an average historic p/e for all companies in Apple Inc. sector, headquartered in US with market cap > $1B:

import eikon as tr

tr.set_app_id('your_app_id')
expression = 'SCREEN(U(IN(Equity(active,public,primary))), \
                IN(TR.GICSSectorCode,45), IN(TR.HQCountryCode,US), \
                TR.CompanyMarketCap>=1000000000, CURN=USD)'

df, e = tr.get_data([exp], ['TR.CompanyName','TR.HistPE'])
df.dropna()
df['Historic P/E'].mean()