#市场平均PE方法一
TDate=’20200624′
yiriduoyin=DataAPI.MktStockFactorsOneDayGet(tradeDate=TDate,secID=u””,ticker=u””,
field=u”ticker,tradeDate,PE,PB”,pandas=”1″)
table1=yiriduoyin[yiriduoyin.PE>0][yiriduoyin.PE<100]
table2=yiriduoyin[yiriduoyin.PB>0][yiriduoyin.PB<7]
d={‘APB+’:([np.mean(table2.PB)]),’APE(TTM)’:([np.mean(yiriduoyin.PE)]),’APE(TTM)+’:([np.mean(table1.PE)]),’MPE(TTM)+’:([np.median(table1.PE)])}
APE=pd.DataFrame(d)
#yiriduoyin=yiriduoyin.sort_values(by=[‘PE’], ascending=[False])
#table2
APE
| APB+ | APE(TTM) | APE(TTM)+ | MPE(TTM)+ | |
|---|---|---|---|---|
| 0 | 2.585836 | -20.981641 | 37.683996 | 32.2381 |