今天新弄的專業(yè)財務(wù)數(shù)據(jù)公式。
DRAWTEXT_FIX(ISLASTBAR,0.02,0,0,'★每股指標(biāo)★'),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-扣非經(jīng)常收益★'),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-每股凈資產(chǎn)'),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-凈資產(chǎn)收益率★'),COLORYELLOW; DRAWTEXT_FIX(ISLASTBAR,0.07,0.7,0,CON2STR(FINVALUE(7),3)); DRAWTEXT_FIX(ISLASTBAR,0, 0.7,0,'7-現(xiàn)金流量'),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.19,0,0,'★資本結(jié)構(gòu)★'),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.23,0.1,0,CON2STR(FINVALUE(210),3)),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.16,0.1,0,'1-資產(chǎn)負(fù)債率★'); DRAWTEXT_FIX(ISLASTBAR,0.23,0.2,0,CON2STR(FINVALUE(211),3)); DRAWTEXT_FIX(ISLASTBAR,0.16,0.2,0,'2-流動資產(chǎn)比率'),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-固定資產(chǎn)比率'),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.23,0.6,0,CON2STR(FINVALUE(215),3)); DRAWTEXT_FIX(ISLASTBAR,0.16,0.6,0,'6-負(fù)債結(jié)構(gòu)比'),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-股東權(quán)益/債務(wù)(%)'),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.235,0.9,0,CON2STR(FINVALUE(218),3)); DRAWTEXT_FIX(ISLASTBAR,0.16,0.9,0,'9-有形資產(chǎn)/凈債務(wù)(%)'),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.4,0,0,'★資產(chǎn)負(fù)債表(一)★'),COLORRED; 實(shí)收資本:=FINVALUE(64)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.44,0.1,0,CON2STR(實(shí)收資本,3)),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.37,0.1,0,'1-實(shí)收資本'); 資本公積:=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; 少數(shù)股東權(quán)益:=FINVALUE(69)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.44,0.6,0,CON2STR(少數(shù)股東權(quán)益,3)); DRAWTEXT_FIX(ISLASTBAR,0.37,0.6,0,'6-少數(shù)股東權(quán)益'),COLORRED; 非正常收益調(diào)整:=FINVALUE(71)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.44,0.7,0,CON2STR(非正常收益調(diào)整,3)); DRAWTEXT_FIX(ISLASTBAR,0.37,0.7,0,'7-非正常收益調(diào)整'),COLORRED; 股東權(quán)益合計(jì):=FINVALUE(72)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.44,0.8,0,CON2STR(股東權(quán)益合計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.37,0.8,0,'8-股東權(quán)益合計(jì)'),COLORRED; 負(fù)債股東合計(jì):=FINVALUE(73)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.44,0.9,0,CON2STR(負(fù)債股東合計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.37,0.9,0,'9-負(fù)債股東合計(jì)'),COLORRED; DRAWTEXT_FIX(ISLASTBAR,0.65,0,0,'★資產(chǎn)負(fù)債表(二)★'),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; 交易資產(chǎn):=FINVALUE(9)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.70,0.2,0,CON2STR(交易資產(chǎn),3)); DRAWTEXT_FIX(ISLASTBAR,0.624,0.2,0,'2-交易資產(chǎn)'),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; 流動資產(chǎn)合計(jì):=FINVALUE(21)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.70,0.4,0,CON2STR(流動資產(chǎn)合計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.624,0.4,0,'4-流動資產(chǎn)合計(jì)'),COLORRED; 非流動資產(chǎn)合計(jì):=FINVALUE(39)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.70,0.5,0,CON2STR(非流動資產(chǎn)合計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.624,0.5,0,'5-非流動資產(chǎn)合計(jì)'),COLORRED; 資產(chǎn)總計(jì):=FINVALUE(40)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.70,0.6,0,CON2STR(資產(chǎn)總計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.624,0.6,0,'6-資產(chǎn)總計(jì)'),COLORRED; 流動負(fù)債合計(jì):=FINVALUE(54)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.70,0.7,0,CON2STR(流動負(fù)債合計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.624,0.7,0,'7-流動負(fù)債合計(jì)'),COLORRED; 非流動負(fù)債合計(jì):=FINVALUE(62)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.70,0.8,0,CON2STR(非流動負(fù)債合計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.624,0.8,0,'8-非流動負(fù)債合計(jì)'),COLORRED; 負(fù)債合計(jì):=FINVALUE(63)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.70,0.9,0,CON2STR(負(fù)債合計(jì),3)); DRAWTEXT_FIX(ISLASTBAR,0.624,0.9,0,'9-負(fù)債合計(jì)'),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-收入-成本'); 營業(yè)利潤:=FINVALUE(86)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.93,0.2,0,CON2STR(營業(yè)利潤,3)); DRAWTEXT_FIX(ISLASTBAR,0.85,0.2,0,'2-營業(yè)利潤'),COLORRED; 資產(chǎn)減值損失:=FINVALUE(81)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.93,0.3,0,CON2STR(資產(chǎn)減值損失,3)); DRAWTEXT_FIX(ISLASTBAR,0.85,0.3,0,'3--資產(chǎn)減值損失'),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; 費(fèi)用:=FINVALUE(77) FINVALUE(78) FINVALUE(80); 費(fèi)用1:=費(fèi)用/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.93,0.5,0,CON2STR(費(fèi)用1,3)); DRAWTEXT_FIX(ISLASTBAR,0.85,0.5,0,'5-費(fèi)用'),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; 營業(yè)外利潤:=FINVALUE(88)-FINVALUE(89); 營業(yè)外利潤1:=FINVALUE(86)*100/FINANCE(10); DRAWTEXT_FIX(ISLASTBAR,0.93,0.7,0,CON2STR(營業(yè)外利潤1,3)); DRAWTEXT_FIX(ISLASTBAR,0.85,0.7,0,'7-營業(yè)外利潤'),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 編輯 ] |
|
|
