专业财务数据公式（源码 副图 通达信 贴图）

今天新弄的专业财务数据公式。

DRAWTEXT_FIX(ISLASTBAR,0.02,0,0,'★每股指标★'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.07,0.1,0,CON2STR(FINVALUE(1),3));
DRAWTEXT_FIX(ISLASTBAR,0,   0.1,0,'1-每股收益'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.07,0.2,0,CON2STR(FINVALUE(2),3)),COLORYELLOW;
DRAWTEXT_FIX(ISLASTBAR,0,   0.2,0,'2-扣非经常收益★'),COLORYELLOW;

DRAWTEXT_FIX(ISLASTBAR,0.07,0.3,0,CON2STR(FINVALUE(3),3));
DRAWTEXT_FIX(ISLASTBAR,0,   0.3,0,'3-未分配利润'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.07,0.4,0,CON2STR(FINVALUE(4),3));
DRAWTEXT_FIX(ISLASTBAR,0,   0.4,0,'4-每股净资产'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.07,0.5,0,CON2STR(FINVALUE(5),3));
DRAWTEXT_FIX(ISLASTBAR,0,   0.5,0,'5-每股公积金'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.07,0.6,0,CON2STR(FINVALUE(6),3)),COLORYELLOW;
DRAWTEXT_FIX(ISLASTBAR,0,   0.6,0,'6-净资产收益率★'),COLORYELLOW;

DRAWTEXT_FIX(ISLASTBAR,0.07,0.7,0,CON2STR(FINVALUE(7),3));
DRAWTEXT_FIX(ISLASTBAR,0,   0.7,0,'7-现金流量'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.19,0,0,'★资本结构★'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.23,0.1,0,CON2STR(FINVALUE(210),3)),COLORRED;
DRAWTEXT_FIX(ISLASTBAR,0.16,0.1,0,'1-资产负债率★');

DRAWTEXT_FIX(ISLASTBAR,0.23,0.2,0,CON2STR(FINVALUE(211),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.2,0,'2-流动资产比率'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.23,0.3,0,CON2STR(FINVALUE(212),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.3,0,'3-货币资金比率'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.23,0.4,0,CON2STR(FINVALUE(213),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.4,0,'4-存货比率'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.23,0.5,0,CON2STR(FINVALUE(214),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.5,0,'5-固定资产比率'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.23,0.6,0,CON2STR(FINVALUE(215),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.6,0,'6-负债结构比'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.23,0.7,0,CON2STR(FINVALUE(216),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.7,0,'7-归母/全投(%)'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.23,0.8,0,CON2STR(FINVALUE(217),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.8,0,'8-股东权益/债务(%)'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.235,0.9,0,CON2STR(FINVALUE(218),3));
DRAWTEXT_FIX(ISLASTBAR,0.16,0.9,0,'9-有形资产/净债务(%)'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.4,0,0,'★资产负债表(一)★'),COLORRED;

实收资本:=FINVALUE(64)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.1,0,CON2STR(实收资本,3)),COLORRED;
DRAWTEXT_FIX(ISLASTBAR,0.37,0.1,0,'1-实收资本');

资本公积:=FINVALUE(65)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.2,0,CON2STR(资本公积,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.2,0,'2-资本公积'),COLORRED;

盈余公积:=FINVALUE(66)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.3,0,CON2STR(盈余公积,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.3,0,'3-盈余公积'),COLORRED;

库存股:=FINVALUE(67)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.4,0,CON2STR(库存股,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.4,0,'4-库存股'),COLORRED;

未分配利润:=FINVALUE(68)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.5,0,CON2STR(未分配利润,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.5,0,'5-未分配利润'),COLORRED;

少数股东权益:=FINVALUE(69)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.6,0,CON2STR(少数股东权益,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.6,0,'6-少数股东权益'),COLORRED;

非正常收益调整:=FINVALUE(71)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.7,0,CON2STR(非正常收益调整,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.7,0,'7-非正常收益调整'),COLORRED;

股东权益合计:=FINVALUE(72)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.8,0,CON2STR(股东权益合计,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.8,0,'8-股东权益合计'),COLORRED;

负债股东合计:=FINVALUE(73)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.44,0.9,0,CON2STR(负债股东合计,3));
DRAWTEXT_FIX(ISLASTBAR,0.37,0.9,0,'9-负债股东合计'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.65,0,0,'★资产负债表(二)★'),COLORRED;

货币资金:=FINVALUE(8)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.1,0,CON2STR(货币资金,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.1,0,'1-货币资金'),COLORRED;

交易资产:=FINVALUE(9)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.2,0,CON2STR(交易资产,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.2,0,'2-交易资产'),COLORRED;

存货:=FINVALUE(17)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.3,0,CON2STR(存货,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.3,0,'3-存货'),COLORRED;

流动资产合计:=FINVALUE(21)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.4,0,CON2STR(流动资产合计,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.4,0,'4-流动资产合计'),COLORRED;

非流动资产合计:=FINVALUE(39)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.5,0,CON2STR(非流动资产合计,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.5,0,'5-非流动资产合计'),COLORRED;

资产总计:=FINVALUE(40)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.6,0,CON2STR(资产总计,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.6,0,'6-资产总计'),COLORRED;

流动负债合计:=FINVALUE(54)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.7,0,CON2STR(流动负债合计,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.7,0,'7-流动负债合计'),COLORRED;

非流动负债合计:=FINVALUE(62)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.8,0,CON2STR(非流动负债合计,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.8,0,'8-非流动负债合计'),COLORRED;

负债合计:=FINVALUE(63)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.70,0.9,0,CON2STR(负债合计,3));
DRAWTEXT_FIX(ISLASTBAR,0.624,0.9,0,'9-负债合计'),COLORRED;

DRAWTEXT_FIX(ISLASTBAR,0.89,0,0,'★利润表★'),COLORRED;

利润:=FINVALUE(74)-FINVALUE(75);
利润1:=利润/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.1,0,CON2STR(利润1,3)),COLORRED;
DRAWTEXT_FIX(ISLASTBAR,0.85,0.1,0,'1-收入-成本');

营业利润:=FINVALUE(86)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.2,0,CON2STR(营业利润,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.2,0,'2-营业利润'),COLORRED;

资产减值损失:=FINVALUE(81)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.3,0,CON2STR(资产减值损失,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.3,0,'3--资产减值损失'),COLORRED;

公允价值:=FINVALUE(82)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.4,0,CON2STR(公允价值,3)),COLORYELLOW;
DRAWTEXT_FIX(ISLASTBAR,0.85,0.4,0,'4-公允价值变动净收益'),COLORYELLOW;

费用:=FINVALUE(77)+FINVALUE(78)+FINVALUE(80);

费用1:=费用/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.5,0,CON2STR(费用1,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.5,0,'5-费用'),COLORRED;

主营外收入:=FINVALUE(83)+FINVALUE(84);
主营外1:=主营外收入/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.6,0,CON2STR(主营外1,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.6,0,'6-主营外收入'),COLORRED;

营业外利润:=FINVALUE(88)-FINVALUE(89);
营业外利润1:=FINVALUE(86)*100/FINANCE(10);

DRAWTEXT_FIX(ISLASTBAR,0.93,0.7,0,CON2STR(营业外利润1,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.7,0,'7-营业外利润'),COLORRED;

利润总额:=FINVALUE(92)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.8,0,CON2STR(利润总额,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.8,0,'8-利润总额'),COLORRED;

净利润:=FINVALUE(95)*100/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.9,0,CON2STR(净利润,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.9,0,'9-净利润'),COLORRED;

[ 本帖最后由 笑竹1 于 2016-10-16 13:31 编辑 ]

赞 (0)

相关推荐