大智慧基本面大全指标公式

[复制链接]
查看146 | 回复0 | 2021-8-21 13:48:41 | 显示全部楼层 |阅读模式

报告日期:=FINANCE2(1);
DRAWGBKLAST(报告日期),ColorFFffbb;
DRAWTEXTABS(20,2,'■报告日期:'+NUMTOSTRN(报告日期,0)+'日'),Colorbb00bb;
流通盘:CAPITAL/1000000,LINETHICK0,PRECIS2;
每股收益:=FINANCE2(3);
每股净资:=FINANCE2(4);
净资收益:=FINANCE2(5);
市盈率:DYNAINFO(39),LINETHICK0,PRECIS0;
市净率:DYNAINFO(58),LINETHICK0,PRECIS0;
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,PRECIS0;{股票市值/销售收入的比率--越小越好}
每股公积金:=FINANCE2(7);
每股未分配:=FINANCE2(8);
DRAWTEXTABS(160,2,'流通:'+NUMTOSTRN(流通盘,2)+'亿'),Color336600;
DRAWTEXTABS(250,2,'每股收益:'+NUMTOSTRN(每股收益,2)+'元'),Color0066FF;
DRAWTEXTABS(350,2,'每股净资产:'+NUMTOSTRN(每股净资,2)+'元'),Color336600;
DRAWTEXTABS(470,2,'净资收益:'+NUMTOSTRN(净资收益,2)+'%'),Color336600;
DRAWTEXTABS(570,2,'市盈率:'+NUMTOSTRN(市盈率,0)),Color0066FF;
DRAWTEXTABS(640,2,'市净率:'+NUMTOSTRN(市净率,0)),Color336600;
DRAWTEXTABS(700,2,'市销率:'+NUMTOSTRN(市销率,4)),Color0066FF;
DRAWTEXTABS(790,2,'每股公积金:'+NUMTOSTRN(每股公积金,2)+'元'),Color336600;
DRAWTEXTABS(905,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(530,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(440,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(440,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(440,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(440,98,'■总资产周转率:'+NUMTOSTRN(总资产周转率,2)+' ◆同比:'+NUMTOSTRN(总周转率同比,2)+'% ◆环比:'+NUMTOSTRN(总周转率环比,2)+'%'),Color336600;
{三、偿债能力分析}
DRAWTEXTABS(900,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(800,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(800,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(800,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(800,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(800,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(800,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(800,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(800,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(800,178,'■财务杠杆效果:'+NUMTOSTRN(财务杠杆效果,2)+' ◆同比:'+NUMTOSTRN(杠杆效果同比,2)+'% ◆环比:'+NUMTOSTRN(杠杆效果环比,2)+'%'),Color993399;
股权固资比率:PFFIN(1411,0),LINETHICK0;
股权固资同比:=PFFIN(1411,0)-PFFIN(1411,4);
股权固资环比:=PFFIN(1411,0)-PFFIN(1411,1);
{www.gUPaNg.com 股旁网_最新股票指标公式}
DRAWTEXTABS(800,194,'■股东权益与固定资产比:'+NUMTOSTRN(股权固资比率,2)+'% ◆同比:'+NUMTOSTRN(股权固资同比,2)+'% ◆环比:'+NUMTOSTRN(股权固资环比,2)+'%'),Color993399;
{四、发展能力分析}
DRAWTEXTABS(530,114,'四、发 展 能 力 分 析'),Color0000FF;
总资产增长率:PFFIN(1608,0),LINETHICK0;
总资增长同比:=PFFIN(1608,0)-PFFIN(1608,4);
总资增长环比:=PFFIN(1608,0)-PFFIN(1608,1);
DRAWTEXTABS(440,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(440,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(440,162,'■营业收入增长率:'+NUMTOSTRN(营业收入增长率,2)+'% ◆同比:'+NUMTOSTRN(营收增长同比,2)+'% ◆环比:'+NUMTOSTRN(营收增长环比,2)+'%'),ColorFF6633,PRECIS0;
营业利润增长率:PFFIN(1602,0),LINETHICK0;
营利增长同比:=PFFIN(1602,0)-PFFIN(1602,4);
营利增长环比:=PFFIN(1602,0)-PFFIN(1602,1);
DRAWTEXTABS(440,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(440,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;
DRAWTEXTABS(20,210,''),Color0066FF;
上期合计持股:=PFFIN(4251,1)/10000;
DRAWTEXTABS(20,226,'■上季前十流通股东合计持股:'+NUMTOSTRN(上期合计持股,2)+'万股'),Color0066FF;
当前合计持股:=PFFIN(4251,0)/10000;
DRAWTEXTABS(20,242,'■当季前十流通股东合计持股:'+NUMTOSTRN(当前合计持股,2)+'万股'),Color0066FF;
前十持股增减%:(当前合计持股-上期合计持股)/上期合计持股*100,LINETHICK0,Color0000FF;
DRAWTEXTABS(20,258,'★前十流通股东合计持股变化率:'+NUMTOSTRN(前十持股增减%,1)+'%'),Color0000FF;
DRAWTEXTABS(280,212,''),Color0066FF;
上期持股比例:=PFFIN(4252,1);
DRAWTEXTABS(280,228,'■上季前十流通股东占流通盘比例:'+NUMTOSTRN(上期持股比例,2)+'%'),Color336600;
当前持股比例:=PFFIN(4252,0);
DRAWTEXTABS(280,244,'■当季前十流通股东占流通盘比例:'+NUMTOSTRN(当前持股比例,2)+'%'),Color336600;
上期股东人数:=PFFIN(4253,1);
DRAWTEXTABS(280,260,'■上季股东人数:'+NUMTOSTRN(上期股东人数,0)+'户'),Color0066FF;
{www.gUPaNg.com 股旁网_最新股票指标公式}
DRAWTEXTABS(530,212,''),Color0066FF;
当季股东人数:PFFIN(4253,0),LINETHICK0,ColorFF00FF;
DRAWTEXTABS(530,228,'■当季股东人数:'+NUMTOSTRN(当季股东人数,0)+'户'),Color0066FF;
静态股东增减%:(当季股东人数-上期股东人数)/上期股东人数*100,LINETHICK0,ColorFF00FF;
DRAWTEXTABS(530,244,'★静态股东人数变化率:'+NUMTOSTRN(静态股东增减%,1)+'%'),Color0000FF;
上季人均持股:=PFFIN(4254,1);
DRAWTEXTABS(530,260,'■上季人均持流通股数:'+NUMTOSTRN(上季人均持股,1)+'股'),Color336600;
DRAWTEXTABS(750,212,''),Color0066FF;
当季人均持股:PFFIN(4254,0),LINETHICK0,Color00FFFF;
DRAWTEXTABS(750,228,'■当季人均持流通股数:'+NUMTOSTRN(当季人均持股,1)+'股'),Color336600;
人均持股增减%:(当季人均持股-上季人均持股)/上季人均持股*100,LINETHICK0,Color00FFFF;
DRAWTEXTABS(750,244,'★静态人均持流通股变化率:'+NUMTOSTRN(人均持股增减%,1)+'%'),Color0000FF;
人均占流通盘:100*当季人均持股/CAPITAL,LINETHICK0,ColorFFFF00;
DRAWTEXTABS(750,260,'★当季人均持股占流通盘:'+NUMTOSTRN(人均占流通盘,3)+'%'),Color0000FF;

202108211236.jpg

202108211236.jpg

 

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则