分享

财务数据之现金流量指标公式

 新用户84784301 2020-06-16

该指标在一些地方是要VAP才能看到的,现在在这里你可以按装到自己的看盘软件上直接就可以看到了,怎么样,好不好

公式副图效果

参数设置                                                                                                     

                                           

公式源码:                                                                                                     

利润:=FINVALUE(309)*10000;

扣非收益TTM:利润/FINANCE(1),NODRAW;

经营现金流:=FINVALUE(107)/100000000;

投资现金流:=FINVALUE(119)/100000000;

自由现金流亿:经营现金流+投资现金流,COLORYELLOW,NODRAW;

DRAWTEXT_FIX(1,0.0+0,0.05,0,'年度'),COLORWHITE;

DRAWTEXT_FIX(1,0.0+0,0.25,0,'报告期'),COLORFF00FF;

DRAWTEXT_FIX(1,0.0+0,0.42,0,'2019'),COLORYELLOW;

DRAWTEXT_FIX(1,0.0+0,0.59,0,'2018'),COLORYELLOW;

DRAWTEXT_FIX(1,0.0+0,0.76,0,'2017'),COLORYELLOW;

DRAWTEXT_FIX(1,0.03+0.05,0.05,0,'扣非每股收益:'),COLORWHITE;

DRAWNUMBER_FIX(1,0.05+0.09,0.25,1,FINONE(2,K,0)),COLORFF00FF;

DRAWNUMBER_FIX(1,0.05+0.09,0.42,1,FINONE(2,M,1231)),COLORYELLOW;

DRAWNUMBER_FIX(1,0.05+0.09,0.59,1,FINONE(2,N,1231)),COLORYELLOW;

DRAWNUMBER_FIX(1,0.05+0.09,0.76,1,FINONE(2,P,1231)),COLORYELLOW;

DRAWTEXT_FIX(1,0.05+0.12,0.05,0,'经营现金流亿:'),COLORWHITE;

DRAWNUMBER_FIX(1,0.05+0.145,0.25,0,FINONE(107,K,0)/100000000),COLORFF00FF;

DRAWNUMBER_FIX(1,0.05+0.145,0.42,0,FINONE(107,M,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.05+0.145,0.59,0,FINONE(107,N,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.05+0.145,0.76,0,FINONE(107,P,1231)/100000000),COLORYELLOW;

DRAWTEXT_FIX(1,-0.04+0.31,0.05,0,'投资现金流亿:'),COLORWHITE;

DRAWNUMBER_FIX(1,-0.04+0.33,0.25,0,FINONE(119,K,0)/100000000),COLORFF00FF;

DRAWNUMBER_FIX(1,-0.04+0.33,0.42,0,FINONE(119,M,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,-0.04+0.33,0.59,0,FINONE(119,N,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,-0.04+0.33,0.76,0,FINONE(119,P,1231)/100000000),COLORYELLOW;

DRAWTEXT_FIX(1,-0.04+0.41,0.05,0,'筹资现金流亿:'),COLORWHITE;

DRAWNUMBER_FIX(1,-0.04+0.41,0.25,0,FINONE(128,K,0)/100000000),COLORFF00FF;

DRAWNUMBER_FIX(1,-0.04+0.41,0.42,0,FINONE(128,M,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,-0.04+0.41,0.59,0,FINONE(128,N,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,-0.04+0.41,0.76,0,FINONE(128,P,1231)/100000000),COLORYELLOW;

DRAWTEXT_FIX(1,0.52,0.05,0,'收现比:'),COLORWHITE;

DRAWNUMBER_FIX(1,0.56,0.25,1,FINONE(222,K,0)),COLORFF00FF;

DRAWNUMBER_FIX(1,0.56,0.42,1,FINONE(222,M,1231)),COLORYELLOW;

DRAWNUMBER_FIX(1,0.56,0.59,1,FINONE(222,N,1231)),COLORYELLOW;

DRAWNUMBER_FIX(1,0.56,0.76,1,FINONE(222,P,1231)),COLORYELLOW;

DRAWTEXT_FIX(1,0.62,0.05,0,'净现比:'),COLORWHITE;

DRAWNUMBER_FIX(1,0.66,0.25,1,FINONE(228,K,0)),COLORFF00FF;

DRAWNUMBER_FIX(1,0.66,0.42,1,FINONE(228,M,1231)),COLORYELLOW;

DRAWNUMBER_FIX(1,0.66,0.59,1,FINONE(228,N,1231)),COLORYELLOW;

DRAWNUMBER_FIX(1,0.66,0.76,1,FINONE(228,P,1231)),COLORYELLOW;

DRAWTEXT_FIX(1,0.70,0.05,0,'销售劳务现金亿:'),COLORWHITE;

DRAWNUMBER_FIX(1,0.76,0.25,1,FINONE(98,K,0)/100000000),COLORFF00FF;

DRAWNUMBER_FIX(1,0.76,0.42,1,FINONE(98,M,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.76,0.59,1,FINONE(98,N,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.76,0.76,1,FINONE(98,P,1231)/100000000),COLORYELLOW;

DRAWTEXT_FIX(1,0.82,0.05,0,'预收款项亿:'),COLORWHITE;

DRAWNUMBER_FIX(1,0.86,0.25,1,FINONE(45,K,0)/100000000),COLORFF00FF;

DRAWNUMBER_FIX(1,0.86,0.42,1,FINONE(45,M,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.86,0.59,1,FINONE(45,N,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.86,0.76,1,FINONE(45,P,1231)/100000000),COLORYELLOW;

DRAWTEXT_FIX(1,0.92,0.05,0,'应付帐款亿:'),COLORWHITE;

DRAWNUMBER_FIX(1,0.96,0.25,1,FINONE(44,K,0)/100000000),COLORFF00FF;

DRAWNUMBER_FIX(1,0.96,0.42,1,FINONE(44,M,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.96,0.59,1,FINONE(44,N,1231)/100000000),COLORYELLOW;

DRAWNUMBER_FIX(1,0.96,0.76,1,FINONE(44,P,1231)/100000000),COLORYELLOW;

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约