未来函数检测结果如下:
该公式包含未来函数:FINANCE
指标源码:
原理解析:
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返回'未满'否则返回''