未来函数检测结果如下:
该公式包含未来函数:FINANCE
M:=1;
NF:=2;
{扫雷宝变色}
安全分:=SAFESCORE;
扫雷宝:=STRCAT(STRCAT('【扫雷宝:',VAR2STR(安全分,0)),'分】');
DRAWTEXT_FIX(安全分>=80,0.23,0.60,1,扫雷宝),COLOR5DAF15;
DRAWTEXT_FIX(安全分<80 AND 安全分>60,0.23,0.60,1,扫雷宝),COLORYELLOW;
DRAWTEXT_FIX(安全分<=60,0.23,0.60,1,扫雷宝),COLORRED;
净资产:=FINONE(72,2023,1231)/100000000;
DRAWTEXT_FIX(1,0.2,0.0,1,' 净资产:'),COLORYELLOW;
DRAWNUMBER_FIX(1,0.25,0.0,1,净资产),COLORWHITE;
净利润:=FINONE(95,2023,1231)/100000000;
DRAWTEXT_FIX(1,0.35,0.0,1,' 净利润:'),COLORYELLOW;
DRAWNUMBER_FIX(1,0.4,0.0,1,净利润),COLORWHITE;
总市值:=FINANCE(39)/100000000;
DRAWTEXT_FIX(1,0.2,0.15,1,' 总市值:'),COLORYELLOW;
DRAWNUMBER_FIX(1,0.25,0.15,1,总市值),COLORWHITE;
营业收入:=FINONE(74,2023,1231)/100000000;
DRAWTEXT_FIX(1,0.2,0.30,1,'营业收入:'),COLORYELLOW;
DRAWNUMBER_FIX(1,0.25,0.30,1,营业收入),COLORWHITE;
扣非净利润:=FINONE(206,2023,1231)/100000000;
DRAWTEXT_FIX(1,0.35,0.3,1,'扣非净利润:'),COLORYELLOW;
DRAWNUMBER_FIX(1,0.4,0.3,1,扣非净利润),COLORWHITE;
利润总额:=FINONE(92,2023,1231)/100000000;
DRAWTEXT_FIX(1,0.35,0.15,1,'利润总额:'),COLORYELLOW;
DRAWNUMBER_FIX(1,0.4,0.15,1,利润总额),COLORWHITE;
未分配利润:=FINONE(68,2023,1231)/100000000;
DRAWTEXT_FIX(1,0.35,0.45,1,'未分配利润:'),COLORYELLOW;
DRAWNUMBER_FIX(1,0.4,0.45,1,未分配利润),COLORWHITE;
DRAWTEXT_FIX(1,0.42,0.0,0,' 温馨提示:要下载专业财务数据,要设置1、(参数M最小0最大2缺省1),2、(参数NF最小1最大20缺省2)'),COLORGRAY;
DRAWTEXT_FIX(1,0.42,0.15,0,'市值不合格:主板<5亿,创业板<3亿(连续20个交易日)'),COLORGRAY;
DRAWTEXT_FIX(1,0.42,0.30,0,'营收不合格:主板<3亿,创业板<1亿(利润总额、净利润、扣非净利润为负)或者(期末净资产为负)'),COLORGRAY;
DRAWTEXT_FIX(1,0.42,0.45,0,'分红不合格:主板<5000万,创业板<3000万(近三年累计分红<年均净利润30%)(净利润、未分配利润为正)'),COLORGRAY;
DRAWTEXT_FIX(1,0.42,0.60,0,' 豁免条件:(回购注销金额)(近三年累计研发投入金额>3亿,占累计营业收入>15%)'),COLORGRAY;
{------------------使用本公式请先下载专业财务数据--------------}
ZB:=CODELIKE('60');
ZB2:=CODELIKE('00');
CYB:=CODELIKE('30');
KCB:=CODELIKE('68');
YYMMDD:=FINVALUE(0);
YY:=INTPART(YYMMDD/10000);
YYYY:=YY+2000;
MMDD:=YYMMDD-YY*10000;
YYYYMMDD:=YYMMDD+20000000;
YY0:=IF(MMDD=1231,YY,YY-1);
BGQ:=FINVALUE(0)+20000000;
ZJNF:=IF(MMDD=1231,YYYY,YYYY-1);
YEAR_A:=YEAR;
YEAR0:=IF(MMDD<=1231,YYYY,YYYY-1);
YEAR1:=YEAR0-1;
YEAR2:=YEAR0-2;
YEAR3:=YEAR0-3;
YEAR4:=YEAR0-4;
YEAR5:=YEAR0-5;
YEAR6:=YEAR0-6;
YEAR7:=YEAR0-7;
YEAR8:=YEAR0-8;
YEAR9:=YEAR0-9;
YEAR10:=YEAR0-10;
DQ1YYMMDD:=MACHINEDATE;{1240423}
DQ1YY:=INTPART(DQ1YYMMDD/10000);{124}
DQYY:=INTPART(DQ1YY-100);
DQYYYY:=INTPART((DQ1YYMMDD+19000000)/10000);{2024}
N:=IF(M=1,DQYYYY-1,DQYYYY);
D1CN:=N;
D2CN:=N-1;
D3CN:=N-2;
ZBSZ:=FINANCE(41)/100000000;
SCSZ:=FINANCE(41)/100000000;
ZBSZ1:=REF(C,0)<500000000/FINANCE(1) AND REF(C,1)<500000000/FINANCE(1) AND REF(C,2)<500000000/FINANCE(1)
AND REF(C,3)<500000000/FINANCE(1) AND REF(C,4)<500000000/FINANCE(1) AND REF(C,5)<500000000/FINANCE(1)
AND REF(C,6)<500000000/FINANCE(1) AND REF(C,7)<500000000/FINANCE(1) AND REF(C,8)<500000000/FINANCE(1)
AND REF(C,9)<500000000/FINANCE(1) AND REF(C,10)<500000000/FINANCE(1) AND REF(C,11)<500000000/FINANCE(1)
AND REF(C,12)<500000000/FINANCE(1) AND REF(C,13)<500000000/FINANCE(1) AND REF(C,14)<500000000/FINANCE(1)
AND REF(C,15)<500000000/FINANCE(1) AND REF(C,16)<500000000/FINANCE(1) AND REF(C,17)<500000000/FINANCE(1)
AND REF(C,18)<500000000/FINANCE(1) AND REF(C,19)<500000000/FINANCE(1) ;
SCSZ1:=REF(C,0)<300000000/FINANCE(1) AND REF(C,1)<300000000/FINANCE(1) AND REF(C,2)<300000000/FINANCE(1)
AND REF(C,3)<300000000/FINANCE(1) AND REF(C,4)<300000000/FINANCE(1) AND REF(C,5)<300000000/FINANCE(1)
AND REF(C,6)<300000000/FINANCE(1) AND REF(C,7)<300000000/FINANCE(1) AND REF(C,8)<300000000/FINANCE(1)
AND REF(C,9)<300000000/FINANCE(1) AND REF(C,10)<300000000/FINANCE(1) AND REF(C,11)<300000000/FINANCE(1)
AND REF(C,12)<300000000/FINANCE(1) AND REF(C,13)<300000000/FINANCE(1) AND REF(C,14)<300000000/FINANCE(1)
AND REF(C,15)<300000000/FINANCE(1) AND REF(C,16)<300000000/FINANCE(1) AND REF(C,17)<300000000/FINANCE(1)
AND REF(C,18)<300000000/FINANCE(1) AND REF(C,19)<300000000/FINANCE(1) ;
KHSZ:=IF(ZB OR ZB2,ZBSZ1,IF(CYB OR KCB,SCSZ1,DRAWNULL));
MDYS1:=IF(YYYY<DQYYYY AND MMDD<1231,MMDD,1231);
MDYS11:=IF(YYYY=DQYYYY AND MMDD<1231,MMDD,1231);
ZJYS1:=FINONE(74,D1CN,MDYS1)*0.00000001;
ZJYS2:=FINONE(74,D2CN,1231)*0.00000001;
ZJYS3:=FINONE(74,D3CN,1231)*0.00000001;
ZJYSZE1:=ZJYS1+ZJYS2+ZJYS3;
ZJYS11:=FINONE(74,D1CN,MDYS11)*0.00000001;
ZJYS22:=FINONE(74,D2CN,1231)*0.00000001;
ZJYS33:=FINONE(74,D3CN,1231)*0.00000001;
ZJYSZE11:=ZJYS11+ZJYS22+ZJYS33;
YSDX:=IF(ZB OR ZB2,3,IF(CYB OR KCB,1,DRAWNULL));
KHYS1:=ZJYS1<YSDX;
KHYS11:=ZJYS11<YSDX;
KHYSZB:=IF(M=1,ZJYS1<3,ZJYS11<3);
KHYSSC:=IF(M=1,ZJYS1<1,ZJYS11<1);
ZJLRZE1:=FINONE(92,D1CN,MDYS1)*0.00000001;
ZJJLR1:=FINONE(96,D1CN,MDYS1)*0.00000001;
ZJJLR2:=FINONE(96,D2CN,1231)*0.00000001;
ZJJLR3:=FINONE(96,D3CN,1231)*0.00000001;
ZJJLRZE:=ZJJLR1+ZJJLR2+ZJJLR3;
ZJKFJLR1:=FINONE(206,D1CN,MDYS1)*0.00000001;
ZJLRZE11:=FINONE(92,D1CN,MDYS11)*0.00000001;
ZJJLR11:=FINONE(96,D1CN,MDYS11)*0.00000001;
ZJJLR22:=FINONE(96,D2CN,1231)*0.00000001;
ZJJLR33:=FINONE(96,D3CN,1231)*0.00000001;
ZJKFJLR11:=FINONE(206,D1CN,MDYS11)*0.00000001;
KUISUN1:=IF(ZJLRZE1<0 OR ZJJLR1<0 OR ZJKFJLR1<0,1,0);
KUISUN11:=IF(ZJLRZE11<0 OR ZJJLR11<0 OR ZJKFJLR11<0,1,0);
KUISUN:=IF(M=1,KUISUN1,KUISUN11);
ZJJZC1:=FINONE(72,D1CN,MDYS1)*0.00000001;
ZJJZC11:=FINONE(72,D1CN,MDYS11)*0.00000001;
KHJZC1:=ZJJZC1<0;
KHJZC11:=ZJJZC11<0;
KHJZC:=IF(M=1,KHJZC1,KHJZC11);
ZJYFF1:=FINONE(304,D1CN,MDYS1)*0.00000001;
ZJYFF2:=FINONE(304,D2CN,1231)*0.00000001;
ZJYFF3:=FINONE(304,D3CN,1231)*0.00000001;
ZJYFFZE1:=ZJYFF1+ZJYFF2+ZJYFF3;
ZJYFF11:=FINONE(304,D1CN,MDYS11)*0.00000001;
ZJYFF22:=FINONE(304,D2CN,1231)*0.00000001;
ZJYFF33:=FINONE(304,D3CN,1231)*0.00000001;
ZJYFFZE11:=ZJYFF11+ZJYFF22+ZJYFF33;
FHTIME:=DQYY*10000+1000101;
FHTIME1:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME)+1;
FHTIME2:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME-10000)+1;
FHTIME3:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME-20000)+1;
FHTIME4:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME+800-30000)+1;
FHFWZQ1:=BARSSINCE(DATE+19000000>=((DQYYYY-3)*10000+901))+1;
FHCISHU1:=COUNT(SPLITBARS(0,1)=0,FHFWZQ1) ;
FHTIME11:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME)+1;
FHTIME22:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME-10000)+1;
FHFWZQ11:=BARSSINCE(DATE+19000000>=((DQYYYY-2)*10000+901))+1;
FHCISHU11:=COUNT(SPLITBARS(0,1)=0,FHFWZQ11) ;
ZJFH1:=SPLIT(0,1);
ZJFH2:=SPLIT(1,1);
ZJFH3:=SPLIT(2,1);
ZJFH4:=SPLIT(3,1);
ZJFH5:=SPLIT(4,1);
ZJFH6:=SPLIT(5,1);
ZJFH7:=SPLIT(6,1);
ZJFH8:=SPLIT(7,1);
ZJFH9:=SPLIT(8,1);
ZJFHTS1:=SPLITBARS(0,1);
ZJFHTS2:=BARSLASTS(SPLITBARS(0,1)=0,2);
ZJFHTS3:=BARSLASTS(SPLITBARS(0,1)=0,3);
ZJFHTS4:=BARSLASTS(SPLITBARS(0,1)=0,4);
ZJFHTS5:=BARSLASTS(SPLITBARS(0,1)=0,5);
ZJFHTS6:=BARSLASTS(SPLITBARS(0,1)=0,6);
ZJFHTS7:=BARSLASTS(SPLITBARS(0,1)=0,7);
ZJFHTS8:=BARSLASTS(SPLITBARS(0,1)=0,8);
ZJFHTS9:=BARSLASTS(SPLITBARS(0,1)=0,9);
ZJFSZG1:=REF(SPLITBARS(0,0)=0,ZJFHTS1);
ZJFSZG2:=REF(SPLITBARS(0,0)=0,ZJFHTS2);
ZJFSZG3:=REF(SPLITBARS(0,0)=0,ZJFHTS3);
YYYYMMDD1:=REF(DATE+19000000,ZJFHTS1);
YYYYMMDD2:=REF(DATE+19000000,ZJFHTS2);
YYYYMMDD3:=REF(DATE+19000000,ZJFHTS3);
YYYYMMDD4:=REF(DATE+19000000,ZJFHTS4);
YYYYMMDD5:=REF(DATE+19000000,ZJFHTS5);
YYYYMMDD6:=REF(DATE+19000000,ZJFHTS6);
YYYYMMDD7:=REF(DATE+19000000,ZJFHTS7);
YYYYMMDD8:=REF(DATE+19000000,ZJFHTS8);
YYYYMMDD9:=REF(DATE+19000000,ZJFHTS9);
YYYY1:=INTPART(YYYYMMDD1/10000);
YYYY2:=INTPART(YYYYMMDD2/10000);
YYYY3:=INTPART(YYYYMMDD3/10000);
YYYY4:=INTPART(YYYYMMDD4/10000);
YYYY5:=INTPART(YYYYMMDD5/10000);
YYYY6:=INTPART(YYYYMMDD6/10000);
YYYY7:=INTPART(YYYYMMDD7/10000);
YYYY8:=INTPART(YYYYMMDD8/10000);
YYYY9:=INTPART(YYYYMMDD9/10000);
YYYYCN1:=YYYY1-1;
YYYYCN2:=YYYY2-1;
YYYYCN3:=YYYY3-1;
YYYYCN4:=YYYY4-1;
YYYYCN5:=YYYY5-1;
YYYYCN6:=YYYY6-1;
YYYYCN7:=YYYY7-1;
YYYYCN8:=YYYY8-1;
YYYYCN9:=YYYY9-1;
YY1:=INTPART(YYYY1-2000);
YY2:=INTPART(YYYY2-2000);
YY3:=INTPART(YYYY3-2000);
YY4:=INTPART(YYYY4-2000);
YY5:=INTPART(YYYY5-2000);
YY6:=INTPART(YYYY6-2000);
YY7:=INTPART(YYYY7-2000);
YY8:=INTPART(YYYY8-2000);
YY9:=INTPART(YYYY9-2000);
MMDD1:=YYYYMMDD1-YYYY1*10000;
MMDD2:=YYYYMMDD2-YYYY2*10000;
MMDD3:=YYYYMMDD3-YYYY3*10000;
MMDD4:=YYYYMMDD4-YYYY4*10000;
MMDD5:=YYYYMMDD5-YYYY5*10000;
MMDD6:=YYYYMMDD6-YYYY6*10000;
MMDD7:=YYYYMMDD7-YYYY7*10000;
MMDD8:=YYYYMMDD8-YYYY8*10000;
MMDD9:=YYYYMMDD9-YYYY9*10000;
GBMMDD1:=IF(MMDD1<=401,930,IF(401<MMDD1 AND MMDD1<901,1231,IF(901<=MMDD1 AND MMDD1<=1231,630,630)));
GBYYYY1:=IF(MMDD1<=401,YYYY1-1,IF(401<MMDD1 AND MMDD1<901,YYYY1-1,IF(901<=MMDD1 AND MMDD1<=1231,YYYY1,YYYY1)));
ZJGB1:=FINONE(238,GBYYYY1,GBMMDD1);
GBMMDD2:=IF(101<= MMDD2 AND MMDD2<=401,930,IF(401<MMDD2 AND MMDD2<901,1231,IF(901<=MMDD2 AND MMDD2<=1231,630,630)));
GBYYYY2:=IF(101<=MMDD2 AND MMDD2<=401,YYYY2-1,IF(401<MMDD2 AND MMDD2<901,YYYY1-1,IF(901<=MMDD2 AND MMDD2<=1231,YYYY2,YYYY2)));
ZJGB2:=FINONE(238,GBYYYY2,GBMMDD2);
GBMMDD3:=IF(101<=MMDD3 AND MMDD3<=401,930,IF(401<MMDD3 AND MMDD3<901,1231,IF(901<=MMDD3 AND MMDD3<=1231,630,630)));
GBYYYY3:=IF(101<=MMDD3 AND MMDD3<=401,YYYY3-1,IF(401<MMDD3 AND MMDD3<901,YYYY3-1,IF(901<=MMDD3 AND MMDD3<=1231,YYYY3,YYYY3)));
ZJGB3:=FINONE(238,GBYYYY3,GBMMDD3);
GBMMDD4:=IF(101<=MMDD4 AND MMDD4<=401,930,IF(401<MMDD4 AND MMDD4<901,1231,IF(901<=MMDD4 AND MMDD4<=1231,630,630)));
GBYYYY4:=IF(101<=MMDD4 AND MMDD4<=401,YYYY4-1,IF(401<MMDD4 AND MMDD4<901,YYYY4-1,IF(901<=MMDD4 AND MMDD4<=1231,YYYY4,YYYY4)));
ZJGB4:=FINONE(238,GBYYYY4,GBMMDD4);
GBMMDD5:=IF(101<=MMDD5 AND MMDD5<=401,930,IF(401<MMDD5 AND MMDD5<901,1231,IF(901<=MMDD5 AND MMDD5<=1231,630,630)));
GBYYYY5:=IF(101<=MMDD5 AND MMDD5<=401,YYYY5-1,IF(401<MMDD5 AND MMDD5<901,YYYY5-1,IF(901<=MMDD5 AND MMDD5<=1231,YYYY5,YYYY5)));
ZJGB5:=FINONE(238,GBYYYY5,GBMMDD5);
GBMMDD6:=IF(101<=MMDD6 AND MMDD6<=401,930,IF(401<MMDD6 AND MMDD6<901,1231,IF(901<=MMDD6 AND MMDD6<=1231,630,630)));
GBYYYY6:=IF(101<=MMDD6 AND MMDD6<=401,YYYY6-1,IF(401<MMDD6 AND MMDD6<901,YYYY6-1,IF(901<=MMDD6 AND MMDD6<=1231,YYYY6,YYYY6)));
ZJGB6:=FINONE(238,GBYYYY6,GBMMDD6);
GBMMDD7:=IF(101<=MMDD7 AND MMDD7<=401,930,IF(401<MMDD7 AND MMDD7<901,1231,IF(901<=MMDD7 AND MMDD7<=1231,630,630)));
GBYYYY7:=IF(101<=MMDD7 AND MMDD7<=401,YYYY7-1,IF(401<MMDD7 AND MMDD7<901,YYYY7-1,IF(901<=MMDD7 AND MMDD7<=1231,YYYY7,YYYY7)));
ZJGB7:=FINONE(238,GBYYYY7,GBMMDD7);
GBMMDD8:=IF(101<=MMDD8 AND MMDD8<=401,930,IF(401<MMDD8 AND MMDD8<901,1231,IF(901<=MMDD8 AND MMDD8<=1231,630,630)));
GBYYYY8:=IF(101<=MMDD8 AND MMDD8<=401,YYYY8-1,IF(401<MMDD8 AND MMDD8<901,YYYY8-1,IF(901<=MMDD8 AND MMDD8<=1231,YYYY8,YYYY8)));
ZJGB8:=FINONE(238,GBYYYY8,GBMMDD8);
GBMMDD9:=IF(101<=MMDD9 AND MMDD9<=401,930,IF(401<MMDD9 AND MMDD9<901,1231,IF(901<=MMDD9 AND MMDD9<=1231,630,630)));
GBYYYY9:=IF(101<=MMDD9 AND MMDD9<=401,YYYY9-1,IF(401<MMDD9 AND MMDD9<901,YYYY9-1,IF(901<=MMDD9 AND MMDD9<=1231,YYYY9,YYYY9)));
ZJGB9:=FINONE(238,GBYYYY9,GBMMDD9);
CISHU1:=ZJGB1*ZJFH1*0.00000001;
CISHU2:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001;
CISHU3:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001;
CISHU4:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001;
CISHU5:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001;
CISHU6:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001;
CISHU7:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001+ZJGB7*ZJFH7*0.00000001;
CISHU8:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001+ZJGB7*ZJFH7*0.00000001+ZJGB8*ZJFH8*0.00000001;
CISHU9:=ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001+ZJGB7*ZJFH7*0.00000001+ZJGB8*ZJFH8*0.00000001+ZJGB9*ZJFH9*0.00000001;
FHZE1:=IF(FHCISHU1=1,CISHU1,IF(FHCISHU1=2,CISHU2,IF(FHCISHU1=3,CISHU3,IF(FHCISHU1=4,CISHU4,IF(FHCISHU1=5,CISHU5,IF(FHCISHU1=6,CISHU6,IF(FHCISHU1=7,CISHU7,IF(FHCISHU1=8,CISHU8,IF(FHCISHU1=9,CISHU9,0)))))))));
FHZE11:=IF(FHCISHU1=1,CISHU1,IF(FHCISHU11=2,CISHU2,IF(FHCISHU11=3,CISHU3,IF(FHCISHU11=4,CISHU4,IF(FHCISHU11=5,CISHU5,IF(FHCISHU11=6,CISHU6,IF(FHCISHU11=7,CISHU7,IF(FHCISHU11=8,CISHU8,IF(FHCISHU11=9,CISHU9,0)))))))));
SHANGSHI:=DATETODAY(DQ1YYMMDD)-FINANCE(42);
SHANGSHIRI:=DAYTODATE(SHANGSHI)+1+19000000;
GGBYYYY:=IF(YYYYCN1<CON2STR(SHANGSHIRI/10000,0),0,YYYYCN1);
GGBMMDD:=IF(YYYYCN1<CON2STR(SHANGSHIRI/10000,0),0,1231);
GB1:=FINONE(238,GGBYYYY,GGBMMDD);
GB2:=FINONE(238,YYYYCN2,1231);
GB3:=FINONE(238,YYYYCN3,1231);
ZJWYIJLR1:=FINONE(68,D1CN,MDYS1)*0.00000001;
ZJWYIJLR2:=FINONE(68,D2CN,MDYS1)*0.00000001;
ZJWYIJLR3:=FINONE(68,D3CN,MDYS1)*0.00000001;
ZJJLRZE1:=(ZJJLR1+ZJJLR2+ZJJLR3)/3;
ZJWYIJLR11:=FINONE(68,D1CN,MDYS11)*0.00000001;
ZJWYIJLR22:=FINONE(68,D2CN,MDYS11)*0.00000001;
ZJWYIJLR33:=FINONE(68,D3CN,MDYS11)*0.00000001;
ZJJLRZE11:=(ZJJLR11+ZJJLR22+ZJJLR33)/3;
KHWFP:=IF(M=1,ZJWYIJLR1,ZJWYIJLR11) ;
KHZJJLZ:=IF(M=1,ZJJLR1,ZJJLR11) ;
KHFHZE:=IF(M=1,FHZE1/ZJJLRZE1,FHZE11/ZJJLRZE11) ;
KHFHDX:=IF(M=1, FHZE1,FHZE11 ) ;
KHYFFDX:=IF(M=1,ZJYFFZE1,ZJYFFZE11 ) ;
KHYFFBL:=IF(M=1,ZJYFFZE1/ZJYSZE1,ZJYFFZE11/ZJYSZE11) ;
JNGLTS:=DATETODAY(DATE)-DATETODAY((YEAR-1900)*10000+101)+1;
GLNF:= ( FINANCE(42)-JNGLTS) >NF*365;
SZBIK:=IF(ZB OR ZB2,ZBSZ1,IF(CYB OR KCB,SCSZ1,DRAWNULL));
YJZBBK:= (KUISUN=1 AND KHYSZB=1) OR KHJZC=1 ;
YJSCBK:=(KUISUN=1 AND KHYSSC=1 )OR KHJZC=1 ;
YJBIK:=IF(ZB OR ZB2,YJZBBK,IF(CYB OR KCB,YJSCBK,DRAWNULL));
FHZBBK:= GLNF=1 AND KHWFP>0 AND KHZJJLZ>0 AND KHFHZE<0.3 AND KHFHDX<0.5 ;
FHSCBK:= GLNF=1 AND KHWFP>0 AND KHZJJLZ>0 AND KHFHZE<0.3 AND KHFHDX<0.3 AND KHYFFDX<3 AND KHYFFBL<0.15 ;
FHBIK:=IF(ZB OR ZB2,FHZBBK,IF( CYB OR KCB,FHSCBK,DRAWNULL));
SSTINME:=(FINANCE(42)-JNGLTS)/365>=NF;
DRAWTEXT_FIX(C>1,0.08,0.01,1,STRCAT('【利润考核】:',IF(KUISUN=1,'',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.1,0.01,1,STRCAT('',IF(KUISUN=1,'亏损',''))),COLORRED;
DRAWTEXT_FIX(C>1,0.1,0.01,1,STRCAT('',IF(KUISUN=0,'合格',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.08,0.15,1,STRCAT('【市值考核】:',IF(SZBIK=1,'',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.1,0.15,1,STRCAT('',IF(SZBIK=1,'不合格',''))),COLORRED;
DRAWTEXT_FIX(C>1,0.1,0.15,1,STRCAT('',IF(SZBIK=0,'合格',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.08,0.30,1,STRCAT('【营收考核】:',IF(YJBIK=1,'',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.11,0.30,1,STRCAT('',IF(YJBIK=1,'不合格',''))),COLORRED;
DRAWTEXT_FIX(C>1,0.1,0.30,1,STRCAT('',IF(YJBIK=0,'合格',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.08,0.45,1,STRCAT('【分红考核】:',IF(FHBIK=1,'',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.11,0.45,1,STRCAT('',IF(FHBIK=1,'不合格',''))),COLORRED;
DRAWTEXT_FIX(C>1,0.11,0.45,1,STRCAT('',IF(FHBIK=0 AND SSTINME=0,'不考核',''))),COLORCYAN;
DRAWTEXT_FIX(C>1,0.11,0.45,1,STRCAT('',IF(FHBIK=0 AND SSTINME=1 AND KHZJJLZ<0 AND KHWFP>0,'不考核',''))),COLORLIRED;
DRAWTEXT_FIX(C>1,0.11,0.45,1,STRCAT('',IF(FHBIK=0 AND SSTINME=1 AND KHZJJLZ>0 AND KHWFP<0,'不考核',''))),COLORLIRED;
DRAWTEXT_FIX(C>1,0.11,0.45,1,STRCAT('',IF(FHBIK=0 AND SSTINME=1 AND KHZJJLZ<0 AND KHWFP<0,'不考核',''))),COLORLIRED;
DRAWTEXT_FIX(C>1,0.1,0.45,1,STRCAT('',IF(FHBIK=0 AND SSTINME=1 AND KHZJJLZ>0 AND KHWFP>0,'合格',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.08,0.60,1,STRCAT('【年份考核】:',IF(SSTINME=1,'',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.1,0.60,1,STRCAT('',IF(SSTINME=1,'合格',''))),COLORGRAY;
DRAWTEXT_FIX(C>1,0.11,0.60,1,STRCAT('',STRCAT(STRCAT(IF(SSTINME=0,'未满',''),IF(SSTINME=0,CON2STR(NF,0),'')),IF(SSTINME=0,'年','')))),COLORCYAN;
原理解析:
M赋值:1
NF赋值:2
{扫雷宝变色}
安全分赋值:SAFESCORE
扫雷宝赋值:STRCAT(STRCAT('【扫雷宝:',VAR2STR(安全分,0)),'分】')
当满足条件安全分>=80时,在横轴0.23纵轴0.60位置书写文字
当满足条件安全分<80 AND 安全分>60时,在横轴0.23纵轴0.60位置书写文字
当满足条件安全分<=60时,在横轴0.23纵轴0.60位置书写文字
净资产赋值:FINONE(72,2023,1231)/100000000
当满足条件1时,在横轴0.2纵轴0.0位置书写文字
当满足条件1时,在横轴0.25纵轴0.0位置书写数字
净利润赋值:FINONE(95,2023,1231)/100000000
当满足条件1时,在横轴0.35纵轴0.0位置书写文字
当满足条件1时,在横轴0.4纵轴0.0位置书写数字
总市值赋值:FINANCE(39)/100000000
当满足条件1时,在横轴0.2纵轴0.15位置书写文字
当满足条件1时,在横轴0.25纵轴0.15位置书写数字
营业收入赋值:FINONE(74,2023,1231)/100000000
当满足条件1时,在横轴0.2纵轴0.30位置书写文字
当满足条件1时,在横轴0.25纵轴0.30位置书写数字
扣非净利润赋值:FINONE(206,2023,1231)/100000000
当满足条件1时,在横轴0.35纵轴0.3位置书写文字
当满足条件1时,在横轴0.4纵轴0.3位置书写数字
利润总额赋值:FINONE(92,2023,1231)/100000000
当满足条件1时,在横轴0.35纵轴0.15位置书写文字
当满足条件1时,在横轴0.4纵轴0.15位置书写数字
未分配利润赋值:FINONE(68,2023,1231)/100000000
当满足条件1时,在横轴0.35纵轴0.45位置书写文字
当满足条件1时,在横轴0.4纵轴0.45位置书写数字
当满足条件1时,在横轴0.42纵轴0.0位置书写文字
当满足条件1时,在横轴0.42纵轴0.15位置书写文字
当满足条件1时,在横轴0.42纵轴0.30位置书写文字
当满足条件1时,在横轴0.42纵轴0.45位置书写文字
当满足条件1时,在横轴0.42纵轴0.60位置书写文字
{------------------使用本公式请先下载专业财务数据--------------}
ZB赋值:CODELIKE('60')
ZB2赋值:CODELIKE('00')
CYB赋值:CODELIKE('30')
KCB赋值:CODELIKE('68')
YYMMDD:=FINVALUE(0)
YY赋值:INTPART(YYMMDD/10000)
YYYY赋值:YY+2000
MMDD:=YYMMDD-YY*10000
YYYYMMDD:=YYMMDD+20000000
如果MMDD=1231返回YY否则返回YY-1
BGQ赋值:FINVALUE(0)+20000000
如果MMDD=1231返回YYYY否则返回YYYY-1
YEAR_A赋值:YEAR
如果MMDD<=1231返回YYYY否则返回YYYY-1
YEAR1赋值:YEAR0-1
YEAR2赋值:YEAR0-2
YEAR3赋值:YEAR0-3
YEAR4赋值:YEAR0-4
YEAR5赋值:YEAR0-5
YEAR6赋值:YEAR0-6
YEAR7赋值:YEAR0-7
YEAR8赋值:YEAR0-8
YEAR9赋值:YEAR0-9
YEAR10:=YEAR0-10
DQ1YYMMDD:=MACHINEDATE
{1240423}
DQ1YY赋值:INTPART(DQ1YYMMDD/10000)
{124}
DQYY赋值:INTPART(DQ1YY-100)
DQYYYY赋值:INTPART((DQ1YYMMDD+19000000)/10000)
如果M=1返回DQYYYY-1否则返回DQYYYY
D1CN赋值:N
D2CN赋值:N-1
D3CN赋值:N-2
ZBSZ赋值:FINANCE(41)/100000000
SCSZ赋值:FINANCE(41)/100000000
ZBSZ1:=0日前的C<500000000/FINANCE(1) AND 1日前的C<500000000/FINANCE(1) AND 2日前的C<500000000/FINANCE(1)
AND 3日前的C<500000000/FINANCE(1) AND 4日前的C<500000000/FINANCE(1) AND 5日前的C<500000000/FINANCE(1)
AND 6日前的C<500000000/FINANCE(1) AND 7日前的C<500000000/FINANCE(1) AND 8日前的C<500000000/FINANCE(1)
AND 9日前的C<500000000/FINANCE(1) AND 10日前的C<500000000/FINANCE(1) AND 11日前的C<500000000/FINANCE(1)
AND 12日前的C<500000000/FINANCE(1) AND 13日前的C<500000000/FINANCE(1) AND 14日前的C<500000000/FINANCE(1)
AND 15日前的C<500000000/FINANCE(1) AND 16日前的C<500000000/FINANCE(1) AND 17日前的C<500000000/FINANCE(1)
AND 18日前的C<500000000/FINANCE(1) AND 19日前的C<500000000/FINANCE(1)
SCSZ1:=0日前的C<300000000/FINANCE(1) AND 1日前的C<300000000/FINANCE(1) AND 2日前的C<300000000/FINANCE(1)
AND 3日前的C<300000000/FINANCE(1) AND 4日前的C<300000000/FINANCE(1) AND 5日前的C<300000000/FINANCE(1)
AND 6日前的C<300000000/FINANCE(1) AND 7日前的C<300000000/FINANCE(1) AND 8日前的C<300000000/FINANCE(1)
AND 9日前的C<300000000/FINANCE(1) AND 10日前的C<300000000/FINANCE(1) AND 11日前的C<300000000/FINANCE(1)
AND 12日前的C<300000000/FINANCE(1) AND 13日前的C<300000000/FINANCE(1) AND 14日前的C<300000000/FINANCE(1)
AND 15日前的C<300000000/FINANCE(1) AND 16日前的C<300000000/FINANCE(1) AND 17日前的C<300000000/FINANCE(1)
AND 18日前的C<300000000/FINANCE(1) AND 19日前的C<300000000/FINANCE(1)
KHSZ赋值:IF(ZB OR ZB2,ZBSZ1,IF(CYB OR KCB,SCSZ1,DRAWNULL))
如果YYYY
ZJYS1赋值:FINONE(74,D1CN,MDYS1)*0.00000001
ZJYS2赋值:FINONE(74,D2CN,1231)*0.00000001
ZJYS3赋值:FINONE(74,D3CN,1231)*0.00000001
ZJYSZE1赋值:ZJYS1+ZJYS2+ZJYS3
ZJYS11:=FINONE(74,D1CN,MDYS11)*0.00000001
ZJYS22:=FINONE(74,D2CN,1231)*0.00000001
ZJYS33:=FINONE(74,D3CN,1231)*0.00000001
ZJYSZE11:=ZJYS11+ZJYS22+ZJYS33
YSDX赋值:IF(ZB OR ZB2,3,IF(CYB OR KCB,1,DRAWNULL))
KHYS1赋值:ZJYS1
如果M=1返回ZJYS1<1否则返回ZJYS11<1
ZJLRZE1赋值:FINONE(92,D1CN,MDYS1)*0.00000001
ZJJLR1赋值:FINONE(96,D1CN,MDYS1)*0.00000001
ZJJLR2赋值:FINONE(96,D2CN,1231)*0.00000001
ZJJLR3赋值:FINONE(96,D3CN,1231)*0.00000001
ZJJLRZE赋值:ZJJLR1+ZJJLR2+ZJJLR3
ZJKFJLR1赋值:FINONE(206,D1CN,MDYS1)*0.00000001
ZJLRZE11:=FINONE(92,D1CN,MDYS11)*0.00000001
ZJJLR11:=FINONE(96,D1CN,MDYS11)*0.00000001
ZJJLR22:=FINONE(96,D2CN,1231)*0.00000001
ZJJLR33:=FINONE(96,D3CN,1231)*0.00000001
ZJKFJLR11:=FINONE(206,D1CN,MDYS11)*0.00000001
如果ZJLRZE1<0 OR ZJJLR1<0 OR ZJKFJLR1<0返回1否则返回0
如果ZJLRZE11<0 OR ZJJLR11<0 OR ZJKFJLR11<0返回1否则返回0
如果M=1返回KUISUN1否则返回KUISUN11
ZJJZC1赋值:FINONE(72,D1CN,MDYS1)*0.00000001
ZJJZC11:=FINONE(72,D1CN,MDYS11)*0.00000001
KHJZC1赋值:ZJJZC1<0
KHJZC11:=ZJJZC11<0
如果M=1返回KHJZC1否则返回KHJZC11
ZJYFF1赋值:FINONE(304,D1CN,MDYS1)*0.00000001
ZJYFF2赋值:FINONE(304,D2CN,1231)*0.00000001
ZJYFF3赋值:FINONE(304,D3CN,1231)*0.00000001
ZJYFFZE1赋值:ZJYFF1+ZJYFF2+ZJYFF3
ZJYFF11:=FINONE(304,D1CN,MDYS11)*0.00000001
ZJYFF22:=FINONE(304,D2CN,1231)*0.00000001
ZJYFF33:=FINONE(304,D3CN,1231)*0.00000001
ZJYFFZE11:=ZJYFF11+ZJYFF22+ZJYFF33
FHTIME:=DQYY*10000+1000101
FHTIME1:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME)+1
FHTIME2:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME-10000)+1
FHTIME3:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME-20000)+1
FHTIME4:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME+800-30000)+1
FHFWZQ1赋值:BARSSINCE(DATE+19000000>=((DQYYYY-3)*10000+901))+1
FHCISHU1赋值:COUNT(SPLITBARS(0,1)=0,FHFWZQ1)
FHTIME11:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME)+1
FHTIME22:=DATETODAY(MACHINEDATE)-DATETODAY(FHTIME-10000)+1
FHFWZQ11:=BARSSINCE(DATE+19000000>=((DQYYYY-2)*10000+901))+1
FHCISHU11:=COUNT(SPLITBARS(0,1)=0,FHFWZQ11)
ZJFH1赋值:SPLIT(0,1)
ZJFH2赋值:SPLIT(1,1)
ZJFH3赋值:SPLIT(2,1)
ZJFH4赋值:SPLIT(3,1)
ZJFH5赋值:SPLIT(4,1)
ZJFH6赋值:SPLIT(5,1)
ZJFH7赋值:SPLIT(6,1)
ZJFH8赋值:SPLIT(7,1)
ZJFH9赋值:SPLIT(8,1)
ZJFHTS1赋值:SPLITBARS(0,1)
ZJFHTS2赋值:BARSLASTS(SPLITBARS(0,1)=0,2)
ZJFHTS3赋值:BARSLASTS(SPLITBARS(0,1)=0,3)
ZJFHTS4赋值:BARSLASTS(SPLITBARS(0,1)=0,4)
ZJFHTS5赋值:BARSLASTS(SPLITBARS(0,1)=0,5)
ZJFHTS6赋值:BARSLASTS(SPLITBARS(0,1)=0,6)
ZJFHTS7赋值:BARSLASTS(SPLITBARS(0,1)=0,7)
ZJFHTS8赋值:BARSLASTS(SPLITBARS(0,1)=0,8)
ZJFHTS9赋值:BARSLASTS(SPLITBARS(0,1)=0,9)
ZJFSZG1赋值:REF(SPLITBARS(0,0)=0,ZJFHTS1)
ZJFSZG2赋值:REF(SPLITBARS(0,0)=0,ZJFHTS2)
ZJFSZG3赋值:REF(SPLITBARS(0,0)=0,ZJFHTS3)
YYYYMMDD1:=ZJFHTS1日前的DATE+19000000
YYYYMMDD2:=ZJFHTS2日前的DATE+19000000
YYYYMMDD3:=ZJFHTS3日前的DATE+19000000
YYYYMMDD4:=ZJFHTS4日前的DATE+19000000
YYYYMMDD5:=ZJFHTS5日前的DATE+19000000
YYYYMMDD6:=ZJFHTS6日前的DATE+19000000
YYYYMMDD7:=ZJFHTS7日前的DATE+19000000
YYYYMMDD8:=ZJFHTS8日前的DATE+19000000
YYYYMMDD9:=ZJFHTS9日前的DATE+19000000
YYYY1:=INTPART(YYYYMMDD1/10000)
YYYY2:=INTPART(YYYYMMDD2/10000)
YYYY3:=INTPART(YYYYMMDD3/10000)
YYYY4:=INTPART(YYYYMMDD4/10000)
YYYY5:=INTPART(YYYYMMDD5/10000)
YYYY6:=INTPART(YYYYMMDD6/10000)
YYYY7:=INTPART(YYYYMMDD7/10000)
YYYY8:=INTPART(YYYYMMDD8/10000)
YYYY9:=INTPART(YYYYMMDD9/10000)
YYYYCN1:=YYYY1-1
YYYYCN2:=YYYY2-1
YYYYCN3:=YYYY3-1
YYYYCN4:=YYYY4-1
YYYYCN5:=YYYY5-1
YYYYCN6:=YYYY6-1
YYYYCN7:=YYYY7-1
YYYYCN8:=YYYY8-1
YYYYCN9:=YYYY9-1
YY1:=INTPART(YYYY1-2000)
YY2:=INTPART(YYYY2-2000)
YY3:=INTPART(YYYY3-2000)
YY4:=INTPART(YYYY4-2000)
YY5:=INTPART(YYYY5-2000)
YY6:=INTPART(YYYY6-2000)
YY7:=INTPART(YYYY7-2000)
YY8:=INTPART(YYYY8-2000)
YY9:=INTPART(YYYY9-2000)
MMDD1:=YYYYMMDD1-YYYY1*10000
MMDD2:=YYYYMMDD2-YYYY2*10000
MMDD3:=YYYYMMDD3-YYYY3*10000
MMDD4:=YYYYMMDD4-YYYY4*10000
MMDD5:=YYYYMMDD5-YYYY5*10000
MMDD6:=YYYYMMDD6-YYYY6*10000
MMDD7:=YYYYMMDD7-YYYY7*10000
MMDD8:=YYYYMMDD8-YYYY8*10000
MMDD9:=YYYYMMDD9-YYYY9*10000
GBMMDD1:=IF(MMDD1<=401,930,IF(401
GBMMDD2:=IF(101<= MMDD2 AND MMDD2<=401,930,IF(401
GBMMDD3:=IF(101<=MMDD3 AND MMDD3<=401,930,IF(401
GBMMDD4:=IF(101<=MMDD4 AND MMDD4<=401,930,IF(401
GBMMDD5:=IF(101<=MMDD5 AND MMDD5<=401,930,IF(401
GBMMDD6:=IF(101<=MMDD6 AND MMDD6<=401,930,IF(401
GBMMDD7:=IF(101<=MMDD7 AND MMDD7<=401,930,IF(401
GBMMDD8:=IF(101<=MMDD8 AND MMDD8<=401,930,IF(401
GBMMDD9:=IF(101<=MMDD9 AND MMDD9<=401,930,IF(401
CISHU1赋值:ZJGB1*ZJFH1*0.00000001
CISHU2赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001
CISHU3赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001
CISHU4赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001
CISHU5赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001
CISHU6赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001
CISHU7赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001+ZJGB7*ZJFH7*0.00000001
CISHU8赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001+ZJGB7*ZJFH7*0.00000001+ZJGB8*ZJFH8*0.00000001
CISHU9赋值:ZJGB1*ZJFH1*0.00000001+ZJGB2*ZJFH2*0.00000001+ZJGB3*ZJFH3*0.00000001+ZJGB4*ZJFH4*0.00000001+ZJGB5*ZJFH5*0.00000001+ZJGB6*ZJFH6*0.00000001+ZJGB7*ZJFH7*0.00000001+ZJGB8*ZJFH8*0.00000001+ZJGB9*ZJFH9*0.00000001
FHZE1赋值:IF(FHCISHU1=1,CISHU1,IF(FHCISHU1=2,CISHU2,IF(FHCISHU1=3,CISHU3,IF(FHCISHU1=4,CISHU4,IF(FHCISHU1=5,CISHU5,IF(FHCISHU1=6,CISHU6,IF(FHCISHU1=7,CISHU7,IF(FHCISHU1=8,CISHU8,IF(FHCISHU1=9,CISHU9,0)))))))))
FHZE11:=IF(FHCISHU1=1,CISHU1,IF(FHCISHU11=2,CISHU2,IF(FHCISHU11=3,CISHU3,IF(FHCISHU11=4,CISHU4,IF(FHCISHU11=5,CISHU5,IF(FHCISHU11=6,CISHU6,IF(FHCISHU11=7,CISHU7,IF(FHCISHU11=8,CISHU8,IF(FHCISHU11=9,CISHU9,0)))))))))
SHANGSHI赋值:DATETODAY(DQ1YYMMDD)-FINANCE(42)
SHANGSHIRI:=DAYTODATE(SHANGSHI)+1+19000000
GGBYYYY赋值:IF(YYYYCN1
GB2赋值:FINONE(238,YYYYCN2,1231)
GB3赋值:FINONE(238,YYYYCN3,1231)
ZJWYIJLR1赋值:FINONE(68,D1CN,MDYS1)*0.00000001
ZJWYIJLR2赋值:FINONE(68,D2CN,MDYS1)*0.00000001
ZJWYIJLR3赋值:FINONE(68,D3CN,MDYS1)*0.00000001
ZJJLRZE1:=(ZJJLR1+ZJJLR2+ZJJLR3)/3
ZJWYIJLR11:=FINONE(68,D1CN,MDYS11)*0.00000001
ZJWYIJLR22:=FINONE(68,D2CN,MDYS11)*0.00000001
ZJWYIJLR33:=FINONE(68,D3CN,MDYS11)*0.00000001
ZJJLRZE11:=(ZJJLR11+ZJJLR22+ZJJLR33)/3
如果M=1返回ZJWYIJLR1否则返回ZJWYIJLR11
如果M=1返回ZJJLR1否则返回ZJJLR11
如果M=1返回FHZE1/ZJJLRZE1否则返回FHZE11/ZJJLRZE11
如果M=1返回 FHZE1否则返回FHZE11
如果M=1返回ZJYFFZE1否则返回ZJYFFZE11
如果M=1返回ZJYFFZE1/ZJYSZE1否则返回ZJYFFZE11/ZJYSZE11
JNGLTS赋值:DATETODAY(DATE)-DATETODAY((YEAR-1900)*10000+101)+1
GLNF赋值: ( FINANCE(42)-JNGLTS) >NF*365
SZBIK赋值:IF(ZB OR ZB2,ZBSZ1,IF(CYB OR KCB,SCSZ1,DRAWNULL))
YJZBBK赋值: (KUISUN=1 AND KHYSZB=1) OR KHJZC=1
YJSCBK赋值:(KUISUN=1 AND KHYSSC=1 )OR KHJZC=1
YJBIK赋值:IF(ZB OR ZB2,YJZBBK,IF(CYB OR KCB,YJSCBK,DRAWNULL))
FHZBBK赋值: GLNF=1 AND KHWFP>0 AND KHZJJLZ>0 AND KHFHZE<0.3 AND KHFHDX<0.5
FHSCBK赋值: GLNF=1 AND KHWFP>0 AND KHZJJLZ>0 AND KHFHZE<0.3 AND KHFHDX<0.3 AND KHYFFDX<3 AND KHYFFBL<0.15
FHBIK赋值:IF(ZB OR ZB2,FHZBBK,IF( CYB OR KCB,FHSCBK,DRAWNULL))
SSTINME:=(FINANCE(42)-JNGLTS)/365>=NF
如果KUISUN=1返回''否则返回''
如果KUISUN=1返回'亏损'否则返回''
如果KUISUN=0返回'合格'否则返回''
如果SZBIK=1返回''否则返回''
如果SZBIK=1返回'不合格'否则返回''
如果SZBIK=0返回'合格'否则返回''
如果YJBIK=1返回''否则返回''
如果YJBIK=1返回'不合格'否则返回''
如果YJBIK=0返回'合格'否则返回''
如果FHBIK=1返回''否则返回''
如果FHBIK=1返回'不合格'否则返回''
如果FHBIK=0 AND SSTINME=0返回'不考核'否则返回''
如果FHBIK=0 AND SSTINME=1 AND KHZJJLZ<0 AND KHWFP>0返回'不考核'否则返回''
如果FHBIK=0 AND SSTINME=1 AND KHZJJLZ>0 AND KHWFP<0返回'不考核'否则返回''
如果FHBIK=0 AND SSTINME=1 AND KHZJJLZ<0 AND KHWFP<0返回'不考核'否则返回''
如果FHBIK=0 AND SSTINME=1 AND KHZJJLZ>0 AND KHWFP>0返回'合格'否则返回''
如果SSTINME=1返回''否则返回''
如果SSTINME=1返回'合格'否则返回''
如果SSTINME=0返回'未满'否则返回''