1、GZ全年（股价估值）：
n1:=IF(finance(37)<37 and finance(37)>36,5.65,0);
n2:=IF(finance(37)<36 and finance(37)>35,5.5,0);
n3:=IF(finance(37)<35 and finance(37)>34,5.34,0);
n4:=IF(finance(37)<34 and finance(37)>33,5.18,0);
n5:=IF(finance(37)<33 and finance(37)>32,5.02,0);
n6:=IF(finance(37)<32 and finance(37)>31,4.87,0);
n7:=IF(finance(37)<31 and finance(37)>30,4.71,0);
n8:=IF(finance(37)<30 and finance(37)>29,4.55,0);
n9:=IF(finance(37)<29 and finance(37)>28,4.4,0);
n10:=IF(finance(37)<28 and finance(37)>27,4.24,0);
n11:=IF(finance(37)<27 and finance(37)>26,4.09,0);
n12:=IF(finance(37)<26 and finance(37)>25,3.92,0);
n13:=IF(finance(37)<25 and finance(37)>24,3.77,0);
n14:=IF(finance(37)<24 and finance(37)>23,3.61,0);
n15:=IF(finance(37)<23 and finance(37)>22,3.45,0);
n16:=IF(finance(37)<22 and finance(37)>21,3.3,0);
n17:=IF(finance(37)<21 and finance(37)>20,3.14,0);
n18:=IF(finance(37)<20 and finance(37)>19,2.98,0);
n19:=IF(finance(37)<19 and finance(37)>18,2.83,0);
n20:=IF(finance(37)<18 and finance(37)>17,2.67,0);
n21:=IF(finance(37)<17 and finance(37)>16,2.51,0);
n22:=IF(finance(37)<16 and finance(37)>15,2.35,0);
n23:=IF(finance(37)<15 and finance(37)>14,2.2,0);
n24:=IF(finance(37)<14 and finance(37)>13,2.04,0);
n25:=IF(finance(37)<13 and finance(37)>12,1.89,0);
n26:=IF(finance(37)<12 and finance(37)>11,1.73,0);
n27:=IF(finance(37)<11 and finance(37)>10,1.57,0);
n28:=IF(finance(37)<10 and finance(37)>9,1.41,0);
n29:=IF(finance(37)<9 and finance(37)>8,1.26,0);
n30:=IF(finance(37)<8 and finance(37)>7,1.1,0);
n31:=IF(finance(37)<7 and finance(37)>6,0.94,0);
n32:=IF(finance(37)<6 and finance(37)>5,0.74,0);
n33:=IF(finance(37)<5 and finance(37)>4,0.62,0);
n34:=IF(finance(37)<4 and finance(37)>3,0.47,0);
n35:=IF(finance(37)<3 and finance(37)>2,0.31,0);
n36:=IF(finance(37)>37,6,0);
m1:=IF(finance(7)>10,0,0);
m2:=IF(finance(7)<10 and finance(7)>9,0.1,0);
m3:=IF(finance(7)<9 and finance(7)>8,0.2,0);
m4:=IF(finance(7)<8 and finance(7)>7,0.3,0);
m5:=IF(finance(7)<7 and finance(7)>6,0.4,0);
m6:=IF(finance(7)<6 and finance(7)>5,0.5,0);
m7:=IF(finance(7)<5 and finance(7)>4,0.6,0);
m8:=IF(finance(7)<4 and finance(7)>3,0.7,0);
m9:=IF(finance(7)<3 and finance(7)>2,0.8,0);
m10:=IF(finance(7)<2 and finance(7)>1,0.9,0);
m11:=IF(1>finance(7)>0,1,0);
GZ:finance(34)*(n1+n2+n3+n4+n5+n6+n7+n8+n9+n10+n11+n12+n13+n14+n15+n16+n17+n18+n19+n20+n21+n22+n23+n24+n25+n26+n27+n28+n29+n30+n31+n32+n33+n34+n35+n36+m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11);
2、GZ半年（股价估值）：
n1:=IF(finance(37)*2<37 and finance(37)*2>36,5.65,0);
n2:=IF(finance(37)*2<36 and finance(37)*2>35,5.5,0);
n3:=IF(finance(37)*2<35 and finance(37)*2>34,5.34,0);
n4:=IF(finance(37)*2<34 and finance(37)*2>33,5.18,0);
n5:=IF(finance(37)*2<33 and finance(37)*2>32,5.02,0);
n6:=IF(finance(37)*2<32 and finance(37)*2>31,4.87,0);
n7:=IF(finance(37)*2<31 and finance(37)*2>30,4.71,0);
n8:=IF(finance(37)*2<30 and finance(37)*2>29,4.55,0);
n9:=IF(finance(37)*2<29 and finance(37)*2>28,4.4,0);
n10:=IF(finance(37)*2<28 and finance(37)*2>27,4.24,0);
n11:=IF(finance(37)*2<27 and finance(37)*2>26,4.09,0);
n12:=IF(finance(37)*2<26 and finance(37)*2>25,3.92,0);
n13:=IF(finance(37)*2<25 and finance(37)*2>24,3.77,0);
n14:=IF(finance(37)*2<24 and finance(37)*2>23,3.61,0);
n15:=IF(finance(37)*2<23 and finance(37)*2>22,3.45,0);
n16:=IF(finance(37)*2<22 and finance(37)*2>21,3.3,0);
n17:=IF(finance(37)*2<21 and finance(37)*2>20,3.14,0);
n18:=IF(finance(37)*2<20 and finance(37)*2>19,2.98,0);
n19:=IF(finance(37)*2<19 and finance(37)*2>18,2.83,0);
n20:=IF(finance(37)*2<18 and finance(37)*2>17,2.67,0);
n21:=IF(finance(37)*2<17 and finance(37)*2>16,2.51,0);
n22:=IF(finance(37)*2<16 and finance(37)*2>15,2.35,0);
n23:=IF(finance(37)*2<15 and finance(37)*2>14,2.2,0);
n24:=IF(finance(37)*2<14 and finance(37)*2>13,2.04,0);
n25:=IF(finance(37)*2<13 and finance(37)*2>12,1.89,0);
n26:=IF(finance(37)*2<12 and finance(37)*2>11,1.73,0);
n27:=IF(finance(37)*2<11 and finance(37)*2>10,1.57,0);
n28:=IF(finance(37)*2<10 and finance(37)*2>9,1.41,0);
n29:=IF(finance(37)*2<9 and finance(37)*2>8,1.26,0);
n30:=IF(finance(37)*2<8 and finance(37)*2>7,1.1,0);
n31:=IF(finance(37)*2<7 and finance(37)*2>6,0.94,0);
n32:=IF(finance(37)*2<6 and finance(37)*2>5,0.74,0);
n33:=IF(finance(37)*2<5 and finance(37)*2>4,0.62,0);
n34:=IF(finance(37)*2<4 and finance(37)*2>3,0.47,0);
n35:=IF(finance(37)*2<3 and finance(37)*2>2,0.31,0);
n36:=IF(finance(37)*2>37,6,0);
m1:=IF(finance(7)>10,0,0);
m2:=IF(finance(7)<10 and finance(7)>9,0.1,0);
m3:=IF(finance(7)<9 and finance(7)>8,0.2,0);
m4:=IF(finance(7)<8 and finance(7)>7,0.3,0);
m5:=IF(finance(7)<7 and finance(7)>6,0.4,0);
m6:=IF(finance(7)<6 and finance(7)>5,0.5,0);
m7:=IF(finance(7)<5 and finance(7)>4,0.6,0);
m8:=IF(finance(7)<4 and finance(7)>3,0.7,0);
m9:=IF(finance(7)<3 and finance(7)>2,0.8,0);
m10:=IF(finance(7)<2 and finance(7)>1,0.9,0);
m11:=IF(1>finance(7)>0,1,0);
GZ:finance(34)*(n1+n2+n3+n4+n5+n6+n7+n8+n9+n10+n11+n12+n13+n14+n15+n16+n17+n18+n19+n20+n21+n22+n23+n24+n25+n26+n27+n28+n29+n30+n31+n32+n33+n34+n35+n36+m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11);
GZ比全：（估值比＝股价估值/股价）
n1:=IF(finance(37)<37 and finance(37)>36,5.65,0);
n2:=IF(finance(37)<36 and finance(37)>35,5.5,0);
n3:=IF(finance(37)<35 and finance(37)>34,5.34,0);
n4:=IF(finance(37)<34 and finance(37)>33,5.18,0);
n5:=IF(finance(37)<33 and finance(37)>32,5.02,0);
n6:=IF(finance(37)<32 and finance(37)>31,4.87,0);
n7:=IF(finance(37)<31 and finance(37)>30,4.71,0);
n8:=IF(finance(37)<30 and finance(37)>29,4.55,0);
n9:=IF(finance(37)<29 and finance(37)>28,4.4,0);
n10:=IF(finance(37)<28 and finance(37)>27,4.24,0);
n11:=IF(finance(37)<27 and finance(37)>26,4.09,0);
n12:=IF(finance(37)<26 and finance(37)>25,3.92,0);
n13:=IF(finance(37)<25 and finance(37)>24,3.77,0);
n14:=IF(finance(37)<24 and finance(37)>23,3.61,0);
n15:=IF(finance(37)<23 and finance(37)>22,3.45,0);
n16:=IF(finance(37)<22 and finance(37)>21,3.3,0);
n17:=IF(finance(37)<21 and finance(37)>20,3.14,0);
n18:=IF(finance(37)<20 and finance(37)>19,2.98,0);
n19:=IF(finance(37)<19 and finance(37)>18,2.83,0);
n20:=IF(finance(37)<18 and finance(37)>17,2.67,0);
n21:=IF(finance(37)<17 and finance(37)>16,2.51,0);
n22:=IF(finance(37)<16 and finance(37)>15,2.35,0);
n23:=IF(finance(37)<15 and finance(37)>14,2.2,0);
n24:=IF(finance(37)<14 and finance(37)>13,2.04,0);
n25:=IF(finance(37)<13 and finance(37)>12,1.89,0);
n26:=IF(finance(37)<12 and finance(37)>11,1.73,0);
n27:=IF(finance(37)<11 and finance(37)>10,1.57,0);
n28:=IF(finance(37)<10 and finance(37)>9,1.41,0);
n29:=IF(finance(37)<9 and finance(37)>8,1.26,0);
n30:=IF(finance(37)<8 and finance(37)>7,1.1,0);
n31:=IF(finance(37)<7 and finance(37)>6,0.94,0);
n32:=IF(finance(37)<6 and finance(37)>5,0.74,0);
n33:=IF(finance(37)<5 and finance(37)>4,0.62,0);
n34:=IF(finance(37)<4 and finance(37)>3,0.47,0);
n35:=IF(finance(37)<3 and finance(37)>2,0.31,0);
n36:=IF(finance(37)>37,6,0);
m1:=IF(finance(7)>10,0,0);
m2:=IF(finance(7)<10 and finance(7)>9,0.1,0);
m3:=IF(finance(7)<9 and finance(7)>8,0.2,0);
m4:=IF(finance(7)<8 and finance(7)>7,0.3,0);
m5:=IF(finance(7)<7 and finance(7)>6,0.4,0);
m6:=IF(finance(7)<6 and finance(7)>5,0.5,0);
m7:=IF(finance(7)<5 and finance(7)>4,0.6,0);
m8:=IF(finance(7)<4 and finance(7)>3,0.7,0);
m9:=IF(finance(7)<3 and finance(7)>2,0.8,0);
m10:=IF(finance(7)<2 and finance(7)>1,0.9,0);
m11:=IF(1>finance(7)>0,1,0);
GZ:=finance(34)*(n1+n2+n3+n4+n5+n6+n7+n8+n9+n10+n11+n12+n13+n14+n15+n16+n17+n18+n19+n20+n21+n22+n23+n24+n25+n26+n27+n28+n29+n30+n31+n32+n33+n34+n35+n36+m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11);
GZB:GZ/ close;
GZ比半：（估值比＝股价估值/股价）
n1:=IF(finance(37)*2<37 and finance(37)*2>36,5.65,0);
n2:=IF(finance(37)*2<36 and finance(37)*2>35,5.5,0);
n3:=IF(finance(37)*2<35 and finance(37)*2>34,5.34,0);
n4:=IF(finance(37)*2<34 and finance(37)*2>33,5.18,0);
n5:=IF(finance(37)*2<33 and finance(37)*2>32,5.02,0);
n6:=IF(finance(37)*2<32 and finance(37)*2>31,4.87,0);
n7:=IF(finance(37)*2<31 and finance(37)*2>30,4.71,0);
n8:=IF(finance(37)*2<30 and finance(37)*2>29,4.55,0);
n9:=IF(finance(37)*2<29 and finance(37)*2>28,4.4,0);
n10:=IF(finance(37)*2<28 and finance(37)*2>27,4.24,0);
n11:=IF(finance(37)*2<27 and finance(37)*2>26,4.09,0);
n12:=IF(finance(37)*2<26 and finance(37)*2>25,3.92,0);
n13:=IF(finance(37)*2<25 and finance(37)*2>24,3.77,0);
n14:=IF(finance(37)*2<24 and finance(37)*2>23,3.61,0);
n15:=IF(finance(37)*2<23 and finance(37)*2>22,3.45,0);
n16:=IF(finance(37)*2<22 and finance(37)*2>21,3.3,0);
n17:=IF(finance(37)*2<21 and finance(37)*2>20,3.14,0);
n18:=IF(finance(37)*2<20 and finance(37)*2>19,2.98,0);
n19:=IF(finance(37)*2<19 and finance(37)*2>18,2.83,0);
n20:=IF(finance(37)*2<18 and finance(37)*2>17,2.67,0);
n21:=IF(finance(37)*2<17 and finance(37)*2>16,2.51,0);
n22:=IF(finance(37)*2<16 and finance(37)*2>15,2.35,0);
n23:=IF(finance(37)*2<15 and finance(37)*2>14,2.2,0);
n24:=IF(finance(37)*2<14 and finance(37)*2>13,2.04,0);
n25:=IF(finance(37)*2<13 and finance(37)*2>12,1.89,0);
n26:=IF(finance(37)*2<12 and finance(37)*2>11,1.73,0);
n27:=IF(finance(37)*2<11 and finance(37)*2>10,1.57,0);
n28:=IF(finance(37)*2<10 and finance(37)*2>9,1.41,0);
n29:=IF(finance(37)*2<9 and finance(37)*2>8,1.26,0);
n30:=IF(finance(37)*2<8 and finance(37)*2>7,1.1,0);
n31:=IF(finance(37)*2<7 and finance(37)*2>6,0.94,0);
n32:=IF(finance(37)*2<6 and finance(37)*2>5,0.74,0);
n33:=IF(finance(37)*2<5 and finance(37)*2>4,0.62,0);
n34:=IF(finance(37)*2<4 and finance(37)*2>3,0.47,0);
n35:=IF(finance(37)*2<3 and finance(37)*2>2,0.31,0);
n36:=IF(finance(37)*2>37,6,0);
m1:=IF(finance(7)>10,0,0);
m2:=IF(finance(7)<10 and finance(7)>9,0.1,0);
m3:=IF(finance(7)<9 and finance(7)>8,0.2,0);
m4:=IF(finance(7)<8 and finance(7)>7,0.3,0);
m5:=IF(finance(7)<7 and finance(7)>6,0.4,0);
m6:=IF(finance(7)<6 and finance(7)>5,0.5,0);
m7:=IF(finance(7)<5 and finance(7)>4,0.6,0);
m8:=IF(finance(7)<4 and finance(7)>3,0.7,0);
m9:=IF(finance(7)<3 and finance(7)>2,0.8,0);
m10:=IF(finance(7)<2 and finance(7)>1,0.9,0);
m11:=IF(1>finance(7)>0,1,0);
GZ:=finance(34)*(n1+n2+n3+n4+n5+n6+n7+n8+n9+n10+n11+n12+n13+n14+n15+n16+n17+n18+n19+n20+n21+n22+n23+n24+n25+n26+n27+n28+n29+n30+n31+n32+n33+n34+n35+n36+m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11);
GZB:GZ/close;
附件里有上面的4个公式提供下载 |
