过去十年ROE大于等于20%的股票选股公式

编写要求：

过去十年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;