#1.不加权
df['past_average'] = df.iloc[:,0] + df.iloc[:,1] + df.iloc[:,2] + df.iloc[:,3]
df['now_average'] = df.iloc[:,1] + df.iloc[:,2] + df.iloc[:,3] + df.iloc[:,4]
df['delta_average'] = df['now_average'] - df['past_average']
#2.加权,距离当前时间越近的报告期roe权重越大
df['past_average'] = 0.1*df.iloc[:,0] + 0.2*df.iloc[:,1] + 0.3*df.iloc[:,2] + 0.4*df.iloc[:,3]
df['now_average'] = 0.1*df.iloc[:,1] + 0.2*df.iloc[:,2] + 0.3*df.iloc[:,3] + 0.4*df.iloc[:,4]
df['delta_average'] = df['now_average'] - df['past_average']
上述代码跟你称的财报越近ROE加权系数越大,刚好相反了
应该是
df['past_average'] = 0.4*df.iloc[:,0] + 0.3*df.iloc[:,1] + 0.2*df.iloc[:,2] + 0.1*df.iloc[:,3]
其次你的past_average跟now_average也反了
加V,fly2858037656, 商讨,对策略思路有兴趣
2022-10-13