財(cái)務(wù)報(bào)表分析指標(biāo)化(通達(dá)信)
2019/12/12 17:55:49
市盈率:=DYNAINFO(39);
市凈率:=FINANCE(34)/C;
每股收益:=FINANCE(33);
資產(chǎn)報(bào)酬率:=FINANCE(29)/FINANCE(10)*100;
股本報(bào)酬率:=FINANCE(29)/FINANCE(1)*100;
凈值報(bào)酬率:=FINANCE(29)/FINANCE(19)*100;
營(yíng)業(yè)純益率:=FINANCE(29)/FINANCE(20)*100;
主營(yíng)業(yè)務(wù)利潤(rùn)率:=FINANCE(21)/FINANCE(20)*100;
負(fù)債比率:=(FINANCE(15)+FINANCE(16))/FINANCE(10)*100;
存貨周轉(zhuǎn)率:=(FINANCE(20)-FINANCE(23))/FINANCE(27);
固定資產(chǎn)周轉(zhuǎn)率:=FINANCE(20)/FINANCE(12);
市盈率評(píng)分:=IF(市盈率<20 AND 市盈率>0,10,IF(市盈率<40 AND 市盈率>20,9,
IF(市盈率<60 AND 市盈率>40,8,IF(市盈率<80 AND 市盈率>60,7,
IF(市盈率<100 AND 市盈率>80,6,IF(市盈率<130 AND 市盈率>100,5,
IF(市盈率<160 AND 市盈率>130,4,IF(市盈率<190 AND 市盈率>160,3,
IF(市盈率<220 AND 市盈率>190,2,IF(市盈率<250 AND 市盈率>220,1,0))))))))));
市凈率評(píng)分:=IF(市凈率>1,10,IF(市凈率<1 AND 市凈率>0.9,9,
IF(市凈率<0.9 AND 市凈率>0.8,8,IF(市凈率<0.8 AND 市凈率>0.7,7,
IF(市凈率<0.7 AND 市凈率>0.6,6,IF(市凈率<0.6 AND 市凈率>0.5,5,
IF(市凈率<0.5 AND 市凈率>0.4,4,IF(市凈率<0.4 AND 市凈率>0.3,3,
IF(市凈率<0.3 AND 市凈率>0.2,2,IF(市凈率<0.2 AND 市凈率>0,1,0))))))))));
每股收益評(píng)分:=IF(每股收益>2.7,10,IF(每股收益<2.7 AND 每股收益>2.4,9,
IF(每股收益<2.4 AND 每股收益>2.1,8,IF(每股收益<2.1 AND 每股收益>1.8,7,
IF(每股收益<1.8 AND 每股收益>1.5,6,IF(每股收益<1.5 AND 每股收益>1.2,5,
IF(每股收益<1.2 AND 每股收益>0.9,4,IF(每股收益<0.9 AND 每股收益>0.6,3,
IF(每股收益<0.6 AND 每股收益>0.3,2,IF(每股收益<0.3 AND 每股收益>0,1,0))))))))));
資產(chǎn)報(bào)酬率評(píng)分:=IF(資產(chǎn)報(bào)酬率>27,10,IF(資產(chǎn)報(bào)酬率<27 AND 資產(chǎn)報(bào)酬率>24,9,
IF(資產(chǎn)報(bào)酬率<24 AND 資產(chǎn)報(bào)酬率>21,8,IF(資產(chǎn)報(bào)酬率<21 AND 資產(chǎn)報(bào)酬率>18,7,
IF(資產(chǎn)報(bào)酬率<18 AND 資產(chǎn)報(bào)酬率>15,6,IF(資產(chǎn)報(bào)酬率<15 AND 資產(chǎn)報(bào)酬率>12,5,
IF(資產(chǎn)報(bào)酬率<12 AND 資產(chǎn)報(bào)酬率>9,4,IF(資產(chǎn)報(bào)酬率<9 AND 資產(chǎn)報(bào)酬率>6,3,
IF(資產(chǎn)報(bào)酬率<6 AND 資產(chǎn)報(bào)酬率>3,2,IF(資產(chǎn)報(bào)酬率<3 AND 資產(chǎn)報(bào)酬率>0,1,0))))))))));
股本報(bào)酬率評(píng)分:=IF(股本報(bào)酬率>135,10,IF(股本報(bào)酬率<135 AND 股本報(bào)酬率>120,9,
IF(股本報(bào)酬率<120 AND 股本報(bào)酬率>105,8,IF(股本報(bào)酬率<105 AND 股本報(bào)酬率>90,7,
IF(股本報(bào)酬率<90 AND 股本報(bào)酬率>75,6,IF(股本報(bào)酬率<75 AND 股本報(bào)酬率>60,5,
IF(股本報(bào)酬率<60 AND 股本報(bào)酬率>45,4,IF(股本報(bào)酬率<45 AND 股本報(bào)酬率>30,3,
IF(股本報(bào)酬率<30 AND 股本報(bào)酬率>15,2,IF(股本報(bào)酬率<15 AND 股本報(bào)酬率>0,1,0))))))))));
凈值報(bào)酬率評(píng)分:=IF(凈值報(bào)酬率>100,10,IF(凈值報(bào)酬率<100 AND 凈值報(bào)酬率>80,9,
IF(凈值報(bào)酬率<80 AND 凈值報(bào)酬率>70,8,IF(凈值報(bào)酬率<70 AND 凈值報(bào)酬率>60,7,
IF(凈值報(bào)酬率<60 AND 凈值報(bào)酬率>50,6,IF(凈值報(bào)酬率<50 AND 凈值報(bào)酬率>40,5,
IF(凈值報(bào)酬率<40 AND 凈值報(bào)酬率>30,4,IF(凈值報(bào)酬率<30 AND 凈值報(bào)酬率>20,3,
IF(凈值報(bào)酬率<20 AND 凈值報(bào)酬率>10,2,IF(凈值報(bào)酬率<10 AND 凈值報(bào)酬率>0,1,0))))))))));
營(yíng)業(yè)純益率評(píng)分:=IF(營(yíng)業(yè)純益率>60,10,IF(營(yíng)業(yè)純益率<60 AND 營(yíng)業(yè)純益率>50,9,
IF(營(yíng)業(yè)純益率<50 AND 營(yíng)業(yè)純益率>40,8,IF(營(yíng)業(yè)純益率<40 AND 營(yíng)業(yè)純益率>30,7,
IF(營(yíng)業(yè)純益率<30 AND 營(yíng)業(yè)純益率>20,6,IF(營(yíng)業(yè)純益率<20 AND 營(yíng)業(yè)純益率>15,5,
IF(營(yíng)業(yè)純益率<15 AND 營(yíng)業(yè)純益率>10,4,IF(營(yíng)業(yè)純益率<10 AND 營(yíng)業(yè)純益率>5,3,
IF(營(yíng)業(yè)純益率<5 AND 營(yíng)業(yè)純益率>3,2,IF(營(yíng)業(yè)純益率<3 AND 營(yíng)業(yè)純益率>0,1,0))))))))));
主營(yíng)利潤(rùn)率評(píng)分:=IF(主營(yíng)業(yè)務(wù)利潤(rùn)率>60,10,IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<60 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>50,9,
IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<50 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>45,8,IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<45 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>40,7,
IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<40 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>35,6,IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<35 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>30,5,
IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<30 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>25,4,IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<25 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>20,3,
IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<20 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>10,2,IF(主營(yíng)業(yè)務(wù)利潤(rùn)率<10 AND 主營(yíng)業(yè)務(wù)利潤(rùn)率>0,1,0))))))))));
負(fù)債比率評(píng)分:=IF(負(fù)債比率<0,10,IF(負(fù)債比率>0 AND 負(fù)債比率<10,9,
IF(負(fù)債比率>10 AND 負(fù)債比率<20,8,IF(負(fù)債比率>20 AND 負(fù)債比率<30,7,
IF(負(fù)債比率>30 AND 負(fù)債比率<40,6,IF(負(fù)債比率>40 AND 負(fù)債比率<50,5,
IF(負(fù)債比率>50 AND 負(fù)債比率<60,4,IF(負(fù)債比率>60 AND 負(fù)債比率<70,3,
IF(負(fù)債比率>70 AND 負(fù)債比率<80,2,IF(負(fù)債比率>80 AND 負(fù)債比率<100,1,0))))))))));
存貨周轉(zhuǎn)率評(píng)分:=IF(存貨周轉(zhuǎn)率>80,5,IF(存貨周轉(zhuǎn)率<80 AND 存貨周轉(zhuǎn)率>60,4,
IF(存貨周轉(zhuǎn)率<60 AND 存貨周轉(zhuǎn)率>40,3,IF(存貨周轉(zhuǎn)率<40 AND 存貨周轉(zhuǎn)率>20,2,
IF(存貨周轉(zhuǎn)率<20 AND 存貨周轉(zhuǎn)率>0,1,0)))));
資產(chǎn)周轉(zhuǎn)率評(píng)分:=IF(固定資產(chǎn)周轉(zhuǎn)率>20,5,IF(固定資產(chǎn)周轉(zhuǎn)率<20 AND 固定資產(chǎn)周轉(zhuǎn)率>15,4,
IF(固定資產(chǎn)周轉(zhuǎn)率<15 AND 固定資產(chǎn)周轉(zhuǎn)率>10,3,IF(固定資產(chǎn)周轉(zhuǎn)率<10 AND 固定資產(chǎn)周轉(zhuǎn)率>5,2,
IF(固定資產(chǎn)周轉(zhuǎn)率<5 AND 固定資產(chǎn)周轉(zhuǎn)率>0,1,0)))));
財(cái)務(wù)優(yōu)勢(shì):(市盈率評(píng)分+市凈率評(píng)分+每股收益評(píng)分)+(資產(chǎn)報(bào)酬率評(píng)分+股本報(bào)酬率評(píng)分+
凈值報(bào)酬率評(píng)分+營(yíng)業(yè)純益率評(píng)分+主營(yíng)利潤(rùn)率評(píng)分)+負(fù)債比率評(píng)分+存貨周轉(zhuǎn)率評(píng)分+
資產(chǎn)周轉(zhuǎn)率評(píng)分;
看股吧 公式 www.kanguba. com
其它股票公式列表
