股票-财务分析(大智慧专业财务数据)指标源码.docx
财务分析(大智慧专业财务数据)指标源码需要大智慧专业财务数据支持。财务分析(大智慧专业财务数据)指标源码财务分析(大智慧专业财务数据)报告日期:=FINANCE2(1);DRAWGBKLAST(报告日期),ColorFFffbb;DRAWTEXTABS(20,2,'财务报告日期:'+NUMTOSTRN(报告日期,0)+'日'),Colorbb00bb;流通盘:CAPITAL/1000000,LINETHICK0;每股收益:=FINANCE2(3);每股净资:=FINANCE2(4);净资收益:=FINANCE2(5);市盈率:DYNAINFO(39),LINETHICK0;市净率:DYNAINFO(58),LINETHICK0;AA1:=NUMTOSTR(报告日期);AA2:=STRMID(AA1,6,1);AA3:=IF(STRCMP(AA2,NUMTOSTR(3)=0,4,IF(STRCMP(AA2,NUMTOSTR(6)=0,2,IF(STRCMP(AA2,NUMTOSTR(9)=0,1.3333,1);市销率:10000*FINANCE2(35)*CLOSE/(PFFIN(1251,0)*AA3),LINETHICK0,Color0066FF;股票市值/销售收入的比率-越小越好每股公积金:=FINANCE2(7);每股未分配:=FINANCE2(8);换手率:=VOL/CAPITAL*100;十换:=SUM(换手率,10);DRAWTEXTABS(180,2,STKLABEL+''+STKNAME),Color0066FF;DRAWTEXTABS(280,2,'流通盘:'+NUMTOSTRN(流通盘,2)+'亿'),Color336600;DRAWTEXTABS(380,2,'每股收益:'+NUMTOSTRN(每股收益,2)+'元'),Color0066FF;DRAWTEXTABS(480,2,'每股净资产:'+NUMTOSTRN(每股净资,2)+'元'),Color336600;DRAWTEXTABS(590,2,'净资产收益:'+NUMTOSTRN(净资收益,2)+'%'),Color336600;DRAWTEXTABS(700,2,'市盈率:'+NUMTOSTRN(市盈率,0),Color0066FF;DRAWTEXTABS(770,2,'市净率:'+NUMTOSTRN(市净率,0),Color336600;DRAWTEXTABS(830,2,'市销率:'+NUMTOSTRN(市销率,4),Color0066FF;DRAWTEXTABS(920,2,'每股公积金:'+NUMTOSTRN(每股公积金,2)+'元'),Color336600;DRAWTEXTABS(1040,2,'每股未分配利润:'+NUMTOSTRN(每股未分配,2)+'元'),Color0066FF;DRAWTEXTABS(1180,2,'换手率:'+NUMTOSTRN(换手率,2)+'%'),Color336600;DRAWTEXTABS(1270,2,'十日换手率:'+NUMTOSTRN(十换,2)+'%'),Color0066FF;DRAWTEXTABS(20,18,'板块:'+BKNAME),coloraa0055;SETPFFIN(01111);一、获利才能分析DRAWTEXTABS(120,34,'一、获利能力分析'),Color0000FF;总资产净利润率:PFFIN(1652,0),LINETHICK0;总资净利同比:=PFFIN(1652,0)-PFFIN(1652,4);总资净利环比:=PFFIN(1652,0)-PFFIN(1652,1);DRAWTEXTABS(20,50,'总资产净利润率:'+NUMTOSTRN(总资产净利润率,2)+'%同比:'+NUMTOSTRN(总资净利同比,2)+'百分点环比:'+NUMTOSTRN(总资净利环比,2)+'百分点'),Color0066FF;固定资产利润率:PFFIN(1659,0)*PFFIN(1459,0),LINETHICK0;固资利率同比:=PFFIN(1659,0)*PFFIN(1459,0)-PFFIN(1659,4)*PFFIN(1459,4);固资利率环比:=PFFIN(1659,0)*PFFIN(1459,0)-PFFIN(1659,1)*PFFIN(1459,1);DRAWTEXTABS(20,66,'固定资产净值利润率:'+NUMTOSTRN(固定资产利润率,2)+'%同比:'+NUMTOSTRN(固资利率同比,2)+'百分点环比:'+NUMTOSTRN(固资利率环比,2)+'百分点'),Color0066FF;营业本钱比率:100*PFFIN(1252,0)/PFFIN(1251,0),LINETHICK0;营业本钱比同比:=100*(PFFIN(1252,0)/PFFIN(1251,0)-PFFIN(1252,4)/PFFIN(1251,4);营业本钱比环比:=100*(PFFIN(1252,0)/PFFIN(1251,0)-PFFIN(1252,1)/PFFIN(1251,1);DRAWTEXTABS(20,82,'营业本钱比率:'+NUMTOSTRN(营业本钱比率,2)+'%同比:'+NUMTOSTRN(营业本钱比同比,2)+'百分点环比:'+NUMTOSTRN(营业本钱比环比,2)+'百分点'),Color0066FF;销售净利率:PFFIN(1657,0),LINETHICK0;净利率同比:=PFFIN(1657,0)-PFFIN(1657,4);净利率环比:=PFFIN(1657,0)-PFFIN(1657,1);DRAWTEXTABS(20,98,'销售净利率:'+NUMTOSTRN(销售净利率,2)+'%同比:'+NUMTOSTRN(净利率同比,2)+'百分点环比:'+NUMTOSTRN(净利率环比,2)+'百分点'),Color0066FF;销售毛利率:PFFIN(1659,0),LINETHICK0;毛利率同比:=PFFIN(1659,0)-PFFIN(1659,4);毛利率环比:=PFFIN(1659,0)-PFFIN(1659,1);DRAWTEXTABS(20,114,'销售毛利率:'+NUMTOSTRN(销售毛利率,2)+'%同比:'+NUMTOSTRN(毛利率同比,2)+'百分点环比:'+NUMTOSTRN(毛利率环比,2)+'百分点'),Color0066FF;营业利润率:PFFIN(1655,0),LINETHICK0;营业利润率同比:=PFFIN(1655,0)-PFFIN(1655,4);营业利润率环比:=PFFIN(1655,0)-PFFIN(1655,1);DRAWTEXTABS(20,130,'营业利润率:'+NUMTOSTRN(营业利润率,2)+'%同比:'+NUMTOSTRN(营业利润率同比,2)+'百分点环比:'+NUMTOSTRN(营业利润率环比,2)+'百分点'),Color0066FF;二、经营效率分析DRAWTEXTABS(630,34,'二、经营效率分析'),Color0000FF;应收帐款周转率:PFFIN(1457,0),LINETHICK0;应收周转率同比:=100*(PFFIN(1457,0)-PFFIN(1457,4)/PFFIN(1457,4);应收周转率环比:=100*(PFFIN(1457,0)-PFFIN(1457,1)/PFFIN(1457,1);DRAWTEXTABS(530,50,'应收帐款周转率:'+NUMTOSTRN(应收帐款周转率,2)+'同比:'+NUMTOSTRN(应收周转率同比,2)+'%环比:'+NUMTOSTRN(应收周转率环比,2)+'%'),Color336600;存货周转率:PFFIN(1456,0),LINETHICK0;存货周转率同比:=100*(PFFIN(1456,0)-PFFIN(1456,4)/PFFIN(1456,4);存货周转率环比:=100*(PFFIN(1456,0)-PFFIN(1456,1)/PFFIN(1456,1);DRAWTEXTABS(530,66,'存货周转率:'+NUMTOSTRN(存货周转率,2)+'同比:'+NUMTOSTRN(存货周转率同比,2)+'%环比:'+NUMTOSTRN(存货周转率环比,2)+'%'),Color336600;固定资产周转率:PFFIN(1459,0),LINETHICK0;固资周转率同比:=100*(PFFIN(1459,0)-PFFIN(1459,4)/PFFIN(1459,4);固资周转率环比:=100*(PFFIN(1459,0)-PFFIN(1459,1)/PFFIN(1459,1);DRAWTEXTABS(530,82,'固定资产周转率:'+NUMTOSTRN(固定资产周转率,2)+'同比:'+NUMTOSTRN(固资周转率同比,2)+'%环比:'+NUMTOSTRN(固资周转率环比,2)+'%'),Color336600;总资产周转率:PFFIN(1460,0),LINETHICK0;总周转率同比:=100*(PFFIN(1460,0)-PFFIN(1460,4)/PFFIN(1460,4);总周转率环比:=100*(PFFIN(1460,0)-PFFIN(1460,1)/PFFIN(1460,1);DRAWTEXTABS(530,98,'总资产周转率:'+NUMTOSTRN(总资产周转率,2)+'同比:'+NUMTOSTRN(总周转率同比,2)+'%环比:'+NUMTOSTRN(总周转率环比,2)+'%'),Color336600;三、偿债才能分析DRAWTEXTABS(1050,34,'三、偿债能力分析'),Color0000FF;流动比率:PFFIN(1401,0),LINETHICK0;流动比率同比:=100*(PFFIN(1401,0)-PFFIN(1401,4)/PFFIN(1401,4);流动比率环比:=100*(PFFIN(1401,0)-PFFIN(1401,1)/PFFIN(1401,1);DRAWTEXTABS(950,50,'流动比率:'+NUMTOSTRN(流动比率,2)+'同比:'+NUMTOSTRN(流动比率同比,2)+'%环比:'+NUMTOSTRN(流动比率环比,2)+'%'),Color993399;速动比率:PFFIN(1402,0),LINETHICK0;速动比率同比:=100*(PFFIN(1402,0)-PFFIN(1402,4)/PFFIN(1402,4);速动比率环比:=100*(PFFIN(1402,0)-PFFIN(1402,1)/PFFIN(1402,1);DRAWTEXTABS(950,66,'速动比率:'+NUMTOSTRN(速动比率,2)+'同比:'+NUMTOSTRN(速动比率同比,2)+'%环比:'+NUMTOSTRN(速动比率环比,2)+'%'),Color993399;现金比率:PFFIN(1403,0),LINETHICK0;现金比率同比:=100*(PFFIN(1403,0)-PFFIN(1403,4)/PFFIN(1403,4);现金比率环比:=100*(PFFIN(1403,0)-PFFIN(1403,1)/PFFIN(1403,1);DRAWTEXTABS(950,82,'现金比率:'+NUMTOSTRN(现金比率,2)+'同比:'+NUMTOSTRN(现金比率同比,2)+'%环比:'+NUMTOSTRN(现金比率环比,2)+'%'),Color993399;股东权益比率:PFFIN(1405,0),LINETHICK0;股权比率同比:=PFFIN(1405,0)-PFFIN(1405,4);股权比率环比:=PFFIN(1405,0)-PFFIN(1405,1);DRAWTEXTABS(950,98,'股东权益比率:'+NUMTOSTRN(股东权益比率,2)+'%同比:'+NUMTOSTRN(股权比率同比,2)+'百分点环比:'+NUMTOSTRN(股权比率环比,2)+'百分点'),Color993399;负债权益比率:PFFIN(1404,0),LINETHICK0;债权比率同比:=PFFIN(1404,0)-PFFIN(1404,4);债权比率环比:=PFFIN(1404,0)-PFFIN(1404,1);DRAWTEXTABS(950,114,'负债权益比率:'+NUMTOSTRN(负债权益比率,2)+'%同比:'+NUMTOSTRN(债权比率同比,2)+'百分点环比:'+NUMTOSTRN(债权比率环比,2)+'百分点'),Color993399;资本化比率:PFFIN(1707,0),LINETHICK0;资本化比率同比:=PFFIN(1707,0)-PFFIN(1707,4);资本化比率环比:=PFFIN(1707,0)-PFFIN(1707,1);DRAWTEXTABS(950,130,'资本化比率:'+NUMTOSTRN(资本化比率,2)+'%同比:'+NUMTOSTRN(资本化比率同比,2)+'百分点环比:'+NUMTOSTRN(资本化比率环比,2)+'百分点'),Color993399;现金负债比率:PFFIN(1754,0),LINETHICK0;现金负债同比:=PFFIN(1754,0)-PFFIN(1754,4);现金负债环比:=PFFIN(1754,0)-PFFIN(1754,1);DRAWTEXTABS(950,146,'经营现金净流量对负债比率:'+NUMTOSTRN(现金负债比率,2)+'%同比:'+NUMTOSTRN(现金负债同比,2)+'百分点环比:'+NUMTOSTRN(现金负债环比,2)+'百分点'),Color993399;权益乘数:PFFIN(1407,0),LINETHICK0;权益乘数同比:=100*(PFFIN(1407,0)-PFFIN(1407,4)/PFFIN(1407,4);权益乘数环比:=100*(PFFIN(1407,0)-PFFIN(1407,1)/PFFIN(1407,1);DRAWTEXTABS(950,162,'权益乘数:'+NUMTOSTRN(权益乘数,2)+'同比:'+NUMTOSTRN(权益乘数同比,2)+'%环比:'+NUMTOSTRN(权益乘数环比,2)+'%'),Color993399;财务杠杆效果:PFFIN(1002,0)/PFFIN(1658,0),LINETHICK0;杠杆效果同比:=100*(PFFIN(1002,0)/PFFIN(1658,0)-PFFIN(1002,4)/PFFIN(1658,4)/(PFFIN(1002,4)/PFFIN(1658,4);杠杆效果环比:=100*(PFFIN(1002,0)/PFFIN(1658,0)-PFFIN(1002,1)/PFFIN(1658,1)/(PFFIN(1002,1)/PFFIN(1658,1);DRAWTEXTABS(950,178,'财务杠杆效果:'+NUMTOSTRN(财务杠杆效果,2)+'同比:'+NUMTOSTRN(杠杆效果同比,2)+'%环比:'+NUMTOSTRN(杠杆效果环比,2)+'%'),Color993399;股权固资比率:PFFIN(1411,0),LINETHICK0;股权固资同比:=PFFIN(1411,0)-PFFIN(1411,4);股权固资环比:=PFFIN(1411,0)-PFFIN(1411,1);DRAWTEXTABS(950,194,'股东权益与固定资产比率:'+NUMTOSTRN(股权固资比率,2)+'%同比:'+NUMTOSTRN(股权固资同比,2)+'百分点环比:'+NUMTOSTRN(股权固资环比,2)+'百分点'),Color993399;四、开展才能分析DRAWTEXTABS(630,114,'四、发展能力分析'),Color0000FF;总资产增长率:PFFIN(1608,0),LINETHICK0;总资增长同比:=PFFIN(1608,0)-PFFIN(1608,4);总资增长环比:=PFFIN(1608,0)-PFFIN(1608,1);DRAWTEXTABS(530,130,'总资产增长率:'+NUMTOSTRN(总资产增长率,2)+'%同比:'+NUMTOSTRN(总资增长同比,2)+'百分点环比:'+NUMTOSTRN(总资增长环比,2)+'百分点'),ColorFF6633;净资产增长率:PFFIN(1605,0),LINETHICK0;净资增长同比:=PFFIN(1605,0)-PFFIN(1605,4);净资增长环比:=PFFIN(1605,0)-PFFIN(1605,1);DRAWTEXTABS(530,146,'净资产增长率:'+NUMTOSTRN(净资产增长率,2)+'%同比:'+NUMTOSTRN(净资增长同比,2)+'百分点环比:'+NUMTOSTRN(净资增长环比,2)+'百分点'),ColorFF6633;营业收入增长率:PFFIN(1601,0),LINETHICK0;营收增长同比:=PFFIN(1601,0)-PFFIN(1601,4);营收增长环比:=PFFIN(1601,0)-PFFIN(1601,1);DRAWTEXTABS(530,162,'营业收入增长率:'+NUMTOSTRN(营业收入增长率,2)+'%同比:'+NUMTOSTRN(营收增长同比,2)+'百分点环比:'+NUMTOSTRN(营收增长环比,2)+'百分点'),ColorFF6633;营业利润增长率:PFFIN(1602,0),LINETHICK0;营利增长同比:=PFFIN(1602,0)-PFFIN(1602,4);营利增长环比:=PFFIN(1602,0)-PFFIN(1602,1);DRAWTEXTABS(530,178,'营业利润增长率:'+NUMTOSTRN(营业利润增长率,2)+'%同比:'+NUMTOSTRN(营利增长同比,2)+'百分点环比:'+NUMTOSTRN(营利增长环比,2)+'百分点'),ColorFF6633;净利润增长率:PFFIN(1604,0),LINETHICK0;净利增长同比:=PFFIN(1604,0)-PFFIN(1604,4);净利增长环比:=PFFIN(1604,0)-PFFIN(1604,1);DRAWTEXTABS(530,194,'净利润增长率:'+NUMTOSTRN(净利润增长率,2)+'%同比:'+NUMTOSTRN(净利增长同比,2)+'百分点环比:'+NUMTOSTRN(净利增长环比,2)+'百分点'),ColorFF6633;五、现金保障才能分析DRAWTEXTABS(120,146,'五、现金保障能力分析'),Color0000FF;现金流收入比率:PFFIN(1751,0),LINETHICK0;现金流收入同比:=PFFIN(1751,0)-PFFIN(1751,4);现金流收入环比:=PFFIN(1751,0)-PFFIN(1751,1);DRAWTEXTABS(20,162,'经营现金净流量对销售收入比率:'+NUMTOSTRN(现金流收入比率,2)+'%同比:'+NUMTOSTRN(现金流收入同比,2)+'百分点环比:'+NUMTOSTRN(现金流收入环比,2)+'百分点'),Color0000BB;现金流量回报率:PFFIN(1752,0),LINETHICK0;现金流回报同比:=PFFIN(1752,0)-PFFIN(1752,4);现金流回报环比:=PFFIN(1752,0)-PFFIN(1752,1);DRAWTEXTABS(20,178,'资产的经营现金流量回报率:'+NUMTOSTRN(现金流量回报率,2)+'%同比:'+NUMTOSTRN(现金流回报同比,2)+'百分点环比:'+NUMTOSTRN(现金流回报环比,2)+'百分点'),Color0000BB;现金流净利比率:PFFIN(1753,0),LINETHICK0;现金流净利同比:=PFFIN(1753,0)-PFFIN(1753,4);现金流净利环比:=PFFIN(1753,0)-PFFIN(1753,1);DRAWTEXTABS(20,194,'经营现金净流量与净利润比率:'+NUMTOSTRN(现金流净利比率,2)+'%同比:'+NUMTOSTRN(现金流净利同比,2)+'百分点环比:'+NUMTOSTRN(现金流净利环比,2)+'百分点'),Color0000BB;