编写要求:
过去十年ROE大于等于15%的股票选股公式
www.gszx.com.cn网解答:
ROE10:=(FINONE(6,YEAR-1,1231)+FINONE(6,YEAR-2,1231)+FINONE(6,YEAR-3,1231)+FINONE(6,YEAR-4,1231)+FINONE(6,YEAR-5,1231)+FINONE(6,YEAR-6,1231)+FINONE(6,YEAR-7,1231)+FINONE(6,YEAR-8,1231)+FINONE(6,YEAR-9,1231)+FINONE(6,YEAR-10,1231))/10;
REF(ROE10,1)>=0.2;