软件名称:[B]专业财务数据公式(F10)[/B]
软件类型:国产软件
运行环境:Win9X/Win2000/WinXP/Win2003/Win7/
软件语言:简体中文
授权方式:免费版
软件大小:2.00 KB
官方主页:Home Page
更新时间:2016-10-16 10:16:21
软件简介:
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;
fei用:=FINVALUE(77)+FINVALUE(78)+FINVALUE(80);
fei用1:=fei用/FINANCE(10);
DRAWTEXT_FIX(ISLASTBAR,0.93,0.5,0,CON2STR(fei用1,3));
DRAWTEXT_FIX(ISLASTBAR,0.85,0.5,0,'5-fei用'),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;
[url=http://www.70822.com/soft/sort013/sort05/down-103740.html]专业财务数据公式(F10)[/url]