- 金币:
-
- 奖励:
-
- 热心:
-
- 注册时间:
- 2011-10-28
|
|
回复 #1 网有战事 的帖子
根据 一股价与净资产,净资产收益率的倍数关系编写的公式(我新手)发现个问题就是净资产收益率是负的也按照4%以下加1.5元壳子钱么
每股净资产:=FINANCE(34);
净资产收益率:=ROUND(FINANCE(30)/FINANCE(19)*100);
GZ1:=IF(净资产收益率=36,FINANCE(34)*5.65,DRAWNULL);
GZ2:=IF(净资产收益率=35,FINANCE(34)*5.5,GZ1);
GZ3:=IF(净资产收益率=34,FINANCE(34)*5.34,GZ2);
GZ4:=IF(净资产收益率=33,FINANCE(34)*5.18,GZ3);
GZ5:=IF(净资产收益率=32,FINANCE(34)*5.02,GZ4);
GZ6:=IF(净资产收益率=31,FINANCE(34)*4.87,GZ5);
GZ7:=IF(净资产收益率=30,FINANCE(34)*4.71,GZ6);
GZ8:=IF(净资产收益率=29,FINANCE(34)*4.55,GZ7);
GZ9:=IF(净资产收益率=28,FINANCE(34)*4.40,GZ8);
GZ10:=IF(净资产收益率=27,FINANCE(34)*4.24,GZ9);
GZ11:=IF(净资产收益率=26,FINANCE(34)*4.09,GZ10);
GZ12:=IF(净资产收益率=25,FINANCE(34)*3.92,GZ11);
GZ13:=IF(净资产收益率=24,FINANCE(34)*3.77,GZ12);
GZ14:=IF(净资产收益率=23,FINANCE(34)*3.61,GZ13);
GZ15:=IF(净资产收益率=22,FINANCE(34)*3.45,GZ14);
GZ16:=IF(净资产收益率=21,FINANCE(34)*3.30,GZ15);
GZ17:=IF(净资产收益率=20,FINANCE(34)*3.14,GZ16);
GZ18:=IF(净资产收益率=19,FINANCE(34)*2.98,GZ17);
GZ19:=IF(净资产收益率=18,FINANCE(34)*2.83,GZ18);
GZ20:=IF(净资产收益率=17,FINANCE(34)*2.67,GZ19);
GZ21:=IF(净资产收益率=16,FINANCE(34)*2.51,GZ20);
GZ22:=IF(净资产收益率=15,FINANCE(34)*2.35,GZ21);
GZ23:=IF(净资产收益率=14,FINANCE(34)*2.2,GZ22);
GZ24:=IF(净资产收益率=13,FINANCE(34)*2.04,GZ23);
GZ25:=IF(净资产收益率=12,FINANCE(34)*1.89,GZ24);
GZ26:=IF(净资产收益率=11,FINANCE(34)*1.73,GZ25);
GZ27:=IF(净资产收益率=10,FINANCE(34)*1.57,GZ26);
GZ28:=IF(净资产收益率=9,FINANCE(34)*1.41,GZ27);
GZ29:=IF(净资产收益率=8,FINANCE(34)*1.26,GZ28);
GZ30:=IF(净资产收益率=7,FINANCE(34)*1.1+1,GZ29);
GZ31:=IF(净资产收益率=6,FINANCE(34)*0.94+1,GZ30);
GZ32:=IF(净资产收益率=5,FINANCE(34)*0.74+1,GZ31);
GZ33:=IF(净资产收益率=4,FINANCE(34)*0.62+1.5,GZ32);
GZ34:=IF(净资产收益率=3,FINANCE(34)*0.47+1.5,GZ33);
GZ35:=IF(净资产收益率<2,FINANCE(34)+1.5,GZ34);
合理估值:IF(净资产收益率<2,FINANCE(34)+1.5,GZ34); |
|
|