《股票-财务分析(大智慧专业财务数据)指标源码.docx》由会员分享,可在线阅读,更多相关《股票-财务分析(大智慧专业财务数据)指标源码.docx(16页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、财务分析(大智慧专业财务数据)指标源码需要大智慧专业财务数据支持。财务分析(大智慧专业财务数据)指标源码财务分析(大智慧专业财务数据)报告日期:=FINANCE2(1);DRAWGBKLAST(报告日期),ColorFFffbb;DRAWTEXTABS(20,2,财务报告日期:+NUMTOSTRN(报告日期,0)+日),Colorbb00bb;流通盘:CAPITAL/1000000,LINETHICK0;每股收益:=FINANCE2(3);每股净资:=FINANCE2(4);净资收益:=FINANCE2(5);市盈率:DYNAINFO(39),LINETHICK0;市净率:DYNAINFO(5
2、8),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/CAPITA
3、L*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;DR
4、AWTEXTABS(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,换手率:+N
5、UMTOSTRN(换手率,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);
6、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);DRAWTEXT
7、ABS(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)
8、;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)+百分点环比:+NUMTOS
9、TRN(净利率环比,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)-PFF
10、IN(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
11、);应收周转率环比:=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
12、)/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,固定资产周转率:+
13、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)+
14、%环比:+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)+%环比
15、:+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,
16、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);股
17、权比率环比:=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(负债权益比率,
18、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;现金负债比率
19、: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(14
20、07,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)/P
21、FFIN(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);股权固资环比:=P
22、FFIN(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,
23、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)+百分点
24、环比:+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;营利
25、增长同比:=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);DRAWTEX
26、TABS(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,经营现金净流量对销售
27、收入比率:+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;
限制150内