|
实用基本面财务指标 现金收入比= 销售商品、提供劳务收到的现金 / 营业收入 净资产收益率 （函数得出） 总资产周转率 = 营业收入 / 资产总计 营业收入增长率 （函数得出） 商誉净资产比 = 商誉 / （资产总计 – 负债合计） 毛利率 （函数得出） 研发收入比 = 研发支出 / 营业收入 下面挑几个讲讲，其他一目了然的东西，我就不说了，大家自己查查。 1.现金收入比在这几个指标中是最重要的，一般越大越好。我们看他的计算公式中相关变量就是销售商品、提供劳务收到的现金与营业收入，一个公司营业收入很高只能说明产品卖得好，但是现金收入也高就说明别人不敢欠你的钱，如果收到的现金很低，也只能说明你在行业中不是很有话语权。 2.总资产周转率与公司的变现能力相关，越高表示变现能力越强。比如你花1000元买下一个池塘，准备养鱼虾，一年下来，卖鱼虾得到500元的营业收入，那么你的总资产周转率就是500/1000=50%，所以总资产周转率越高，变现能力越强，赚的钱也就越多。但这里有两个变量，总资产与营业收入，我们希望由营业收入的增高带来了周转率的提升而不希望是由于总资产的下降带来的周转率提升，所以在指标中我标出了总资产的值。 3.商誉是公司对外兼并收购的时候产生的，是一项无形资产。比如你经营了一家公司，现在想要扩张自己的产业，见到一家技术能力不错的小公司，你要把他买下来。小公司经过计算大概值100块，但是小公司老板看准了你想买下这个公司，出价200块，你经过思考，一拍脑袋就买了，那多出来的100块就是商誉了。如果小公司经营的很好，那么大家你好我也好，如果小公司经营不善，亏钱了，这个时候原来的100块商誉金额下调成30块或者其他数目，这个动作称之为商誉减值，这个会造成投资者实打实的亏损。所以，商誉越小越好。商誉对应净资产的比值也越小越好。 4.研发收入比，由于通达信专业财务函数FINONE没有提供研发收入的ID，所以我用开发支出代替了，这个数据可能不是特别准，大家使用的时候注意甄别。 代码及展示 写这个代码也费了一点时间，我知道只要公布出来就会立马被别人抄过去，不过也没办法，国情如此。代码总体上来说也不是特别难，如果有遇到不懂得，欢迎后台留言交流。1. 当19年一季报全部出完了，请大家把代码中的 YEAR_NOW = 2018 改成 YEAR_NOW = 2019，这样的话就能显示2019年一季报的财务数据。 2. 在使用代码之前请下载专业财务数据。3.由于通达信最大输出是100，所以近三年的“开发支出”、“商誉”、“总资产”和“现金收入”我打印出来了，后两年的数据我就没有打印了。4.建议直接复制我的代码，后续改编你自己动手。5.公众号改版了，我都不好意思点赞了，如果你也是这样我也理解，我开打赏是不要求打赏的，以后不好意思点赞的给我打赏个0.01元吧，我不在乎打赏金额，只是看看能不能得到一点认同。 效果图： 代码： DRAWRECTREL(0,0,990,990,RGB(20,18,12)); YEAR_NOW:=2018; 现金收入1:=FINONE(98,0,0)/100000000;现金收入比1:=(FINONE(98,0,0)/FINONE(74,0,0)) * 100; 净资产收益率1:=FINONE(6,0,0); {人均创收;} 总资产周转率1:=(FINONE(74,0,0)*100/FINONE(40,0,0));总资产1:=FINONE(40,0,0)/100000000; 营业收入增长率1:=FINONE(183,0,0); 商誉净资产比1:=(FINONE(35,0,0)/(FINONE(40,0,0)-FINONE(63,0,0))) * 100;商誉1:=FINONE(35,0,0)/100000000; 毛利率1:=FINONE(202,0,0); 研发支出1:=FINONE(34,0,0)/100000000; 研发收入比1:=(FINONE(34,0,0)/FINONE(74,0,0)) * 100; DRAWNUMBER_FIX(1,0.19,0.03,0,YEAR_NOW),COLORBLUE; DRAWNUMBER_FIX(1,0.33,0.03,0,YEAR_NOW-1),COLORBLUE; DRAWNUMBER_FIX(1,0.47,0.03,0,YEAR_NOW-2),COLORBLUE; DRAWNUMBER_FIX(1,0.61,0.03,0,YEAR_NOW-3),COLORBLUE; DRAWNUMBER_FIX(1,0.75,0.03,0,YEAR_NOW-4),COLORBLUE; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.05,0.15,0,'■ 现金收入比：'),COLORYELLOW; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.05,0.22,0,'■ 净资产收益率：'),COLORYELLOW; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.05,0.29,0,'■ 总资产周转率：'),COLORYELLOW; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.05,0.36,0,'■ 营业收入增长率：'),COLORYELLOW; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.05,0.43,0,'■ 商誉净资产比：'),COLORYELLOW; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.05,0.50,0,'■ 毛利率：'),COLORYELLOW; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.05,0.57,0,'■ 研发收入比：'),COLORYELLOW; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.17,0.15,0,现金收入比1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.23,0.15,0,现金收入1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.17,0.22,0,净资产收益率1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.17,0.29,0,总资产周转率1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.23,0.29,0,总资产1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.17,0.36,0,营业收入增长率1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.17,0.43,0,商誉净资产比1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.23,0.43,0,商誉1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.17,0.50,0,毛利率1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.17,0.57,0,研发收入比1),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.23,0.57,0,研发支出1),COLORRED; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.21,0.15,0,' ％'),COLORFFCC99;{现收} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.21,0.22,0,' ％'),COLORFFCC99;{净资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.21,0.29,0,' ％'),COLORFFCC99;{总资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.21,0.36,0,' ％'),COLORFFCC99;{营增} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.21,0.43,0,' ％'),COLORFFCC99;{商誉} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.21,0.50,0,' ％'),COLORFFCC99;{毛利} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.21,0.57,0,' ％'),COLORFFCC99;{研发}; {YEAR_NOW-1} 现金收入2:=FINONE(98,YEAR_NOW-1,1231)/100000000;现金收入比2:=(FINONE(98,YEAR_NOW-1,1231)/FINONE(74,YEAR_NOW-1,1231)) * 100; 净资产收益率2:=FINONE(6,YEAR_NOW-1,1231); {人均创收;} 总资产周转率2:=(FINONE(74,YEAR_NOW-1,1231)*100/FINONE(40,YEAR_NOW-1,1231));总资产2:=FINONE(40,YEAR_NOW-1,1231)/100000000; 营业收入增长率2:=FINONE(183,YEAR_NOW-1,1231); 商誉净资产比2:=(FINONE(35,YEAR_NOW-1,1231)/(FINONE(40,YEAR_NOW-1,1231)-FINONE(63,YEAR_NOW-1,1231))) * 100;商誉2:=FINONE(35,YEAR_NOW-1,1231)/100000000; 毛利率2:=FINONE(202,YEAR_NOW-1,1231); 研发支出2:=FINONE(34,YEAR_NOW-1,1231)/100000000; 研发收入比2:=(FINONE(34,YEAR_NOW-1,1231)/FINONE(74,YEAR_NOW-1,1231)) * 100; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.31,0.15,0,现金收入比2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.37,0.15,0,现金收入2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.31,0.22,0,净资产收益率2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.31,0.29,0,总资产周转率2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.37,0.29,0,总资产2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.31,0.36,0,营业收入增长率2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.31,0.43,0,商誉净资产比2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.37,0.43,0,商誉2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.31,0.50,0,毛利率2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.31,0.57,0,研发收入比2),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.37,0.57,0,研发支出2),COLORRED; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.35,0.15,0,' ％'),COLORFFCC99;{现收} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.35,0.22,0,' ％'),COLORFFCC99;{净资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.35,0.29,0,' ％'),COLORFFCC99;{总资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.35,0.36,0,' ％'),COLORFFCC99;{营增} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.35,0.43,0,' ％'),COLORFFCC99;{商誉} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.35,0.50,0,' ％'),COLORFFCC99;{毛利} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.35,0.57,0,' ％'),COLORFFCC99;{研发} {YEAR_NOW-2} 现金收入3:=FINONE(98,YEAR_NOW-2,1231)/100000000;现金收入比3:=(FINONE(98,YEAR_NOW-2,1231)/FINONE(74,YEAR_NOW-2,1231)) * 100; 净资产收益率3:=FINONE(6,YEAR_NOW-2,1231); {人均创收;} 总资产周转率3:=(FINONE(74,YEAR_NOW-2,1231)*100/FINONE(40,YEAR_NOW-2,1231));总资产3:=FINONE(40,YEAR_NOW-2,1231)/100000000; 营业收入增长率3:=FINONE(183,YEAR_NOW-2,1231); 商誉净资产比3:=(FINONE(35,YEAR_NOW-2,1231)/(FINONE(40,YEAR_NOW-2,1231)-FINONE(63,YEAR_NOW-2,1231))) * 100;商誉3:=FINONE(35,YEAR_NOW-2,1231)/100000000; 毛利率3:=FINONE(202,YEAR_NOW-2,1231); 研发支出3:=FINONE(34,YEAR_NOW-2,1231)/100000000; 研发收入比3:=(FINONE(34,YEAR_NOW-2,1231)/FINONE(74,YEAR_NOW-2,1231)) * 100; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.45,0.15,0,现金收入比3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.51,0.15,0,现金收入3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.45,0.22,0,净资产收益率3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.45,0.29,0,总资产周转率3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.51,0.29,0,总资产3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.45,0.36,0,营业收入增长率3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.45,0.43,0,商誉净资产比3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.51,0.43,0,商誉3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.45,0.50,0,毛利率3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.45,0.57,0,研发收入比3),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.51,0.57,0,研发支出3),COLORRED; DRAWTEXT_FIX(CURRBARSCOUNT=1,0.49,0.15,0,' ％'),COLORFFCC99;{现收} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.49,0.22,0,' ％'),COLORFFCC99;{净资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.49,0.29,0,' ％'),COLORFFCC99;{总资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.49,0.36,0,' ％'),COLORFFCC99;{营增} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.49,0.43,0,' ％'),COLORFFCC99;{商誉} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.49,0.50,0,' ％'),COLORFFCC99;{毛利} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.49,0.57,0,' ％'),COLORFFCC99;{研发}; {YEAR_NOW-3} 现金收入4:=FINONE(98,YEAR_NOW-3,1231)/100000000;现金收入比4:=(FINONE(98,YEAR_NOW-3,1231)/FINONE(74,YEAR_NOW-3,1231)) * 100; 净资产收益率4:=FINONE(6,YEAR_NOW-3,1231); {人均创收;} 总资产周转率4:=(FINONE(74,YEAR_NOW-3,1231)*100/FINONE(40,YEAR_NOW-3,1231));总资产4:=FINONE(40,YEAR_NOW-3,1231)/100000000; 营业收入增长率4:=FINONE(183,YEAR_NOW-3,1231); 商誉净资产比4:=(FINONE(35,YEAR_NOW-3,1231)/(FINONE(40,YEAR_NOW-3,1231)-FINONE(63,YEAR_NOW-3,1231))) * 100;商誉4:=FINONE(35,YEAR_NOW-3,1231)/100000000; 毛利率4:=FINONE(202,YEAR_NOW-3,1231); 研发支出4:=FINONE(34,YEAR_NOW-3,1231)/100000000; 研发收入比4:=(FINONE(34,YEAR_NOW-3,1231)/FINONE(74,YEAR_NOW-3,1231)) * 100; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.59,0.15,0,现金收入比4),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.65,0.15,0,现金收入4),COLORRED;} DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.59,0.22,0,净资产收益率4),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.59,0.29,0,总资产周转率4),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.65,0.29,0,总资产4),COLORRED;} DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.59,0.36,0,营业收入增长率4),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.59,0.43,0,商誉净资产比4),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.65,0.43,0,商誉4),COLORRED;} DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.59,0.50,0,毛利率4),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.59,0.57,0,研发收入比4),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.65,0.57,0,研发支出4),COLORRED;} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.63,0.15,0,' ％'),COLORFFCC99;{现收} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.63,0.22,0,' ％'),COLORFFCC99;{净资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.63,0.29,0,' ％'),COLORFFCC99;{总资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.63,0.36,0,' ％'),COLORFFCC99;{营增} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.63,0.43,0,' ％'),COLORFFCC99;{商誉} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.63,0.50,0,' ％'),COLORFFCC99;{毛利} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.63,0.57,0,' ％'),COLORFFCC99;{研发} {YEAR_NOW-4} 现金收入5:=FINONE(98,YEAR_NOW-4,1231)/100000000;现金收入比5:=(FINONE(98,YEAR_NOW-4,1231)/FINONE(74,YEAR_NOW-4,1231)) * 100; 净资产收益率5:=FINONE(6,YEAR_NOW-4,1231); {人均创收;} 总资产周转率5:=(FINONE(74,YEAR_NOW-4,1231)*100/FINONE(40,YEAR_NOW-4,1231));总资产5:=FINONE(40,YEAR_NOW-4,1231)/100000000; 营业收入增长率5:=FINONE(183,YEAR_NOW-4,1231); 商誉净资产比5:=(FINONE(35,YEAR_NOW-4,1231)/(FINONE(40,YEAR_NOW-4,1231)-FINONE(63,YEAR_NOW-4,1231))) * 100;商誉5:=FINONE(35,YEAR_NOW-4,1231)/100000000; 毛利率5:=FINONE(202,YEAR_NOW-4,1231); 研发支出5:=FINONE(34,YEAR_NOW-4,1231)/100000000; 研发收入比5:=(FINONE(34,YEAR_NOW-4,1231)/FINONE(74,YEAR_NOW-4,1231)) * 100; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.73,0.15,0,现金收入比5),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.79,0.15,0,现金收入5),COLORRED;} DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.73,0.22,0,净资产收益率5),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.73,0.29,0,总资产周转率5),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.79,0.29,0,总资产5),COLORRED;} DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.73,0.36,0,营业收入增长率5),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.73,0.43,0,商誉净资产比5),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.79,0.43,0,商誉5),COLORRED;} DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.73,0.50,0,毛利率5),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.73,0.57,0,研发收入比5),COLORRED; {DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.79,0.57,0,研发支出5),COLORRED;} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.77,0.15,0,' ％'),COLORFFCC99;{现收} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.77,0.22,0,' ％'),COLORFFCC99;{净资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.77,0.29,0,' ％'),COLORFFCC99;{总资} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.77,0.36,0,' ％'),COLORFFCC99;{营增} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.77,0.43,0,' ％'),COLORFFCC99;{商誉} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.77,0.50,0,' ％'),COLORFFCC99;{毛利} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.77,0.57,0,' ％'),COLORFFCC99;{研发} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.79,0.90,0,'财务数据日期截止: '),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.89,0.90,0,YEAR_NOW),COLORRED; {DRAWTEXT_FIX(CURRBARSCOUNT=1,0.92,0.90,0,'年'),COLORRED;} DRAWTEXT_FIX(CURRBARSCOUNT=1,0.95,0.90,0,' 季度 ■ '),COLORRED; DRAWNUMBER_FIX(CURRBARSCOUNT=1,0.93,0.90,0,FINANCE(37)),COLORRED; 祝A股长红！祝大家账户长红！ |
|
|
