股票9：通达信公式债务分析

公司债务分析：包括流动比率，该项目大于要大于1；速动比率是指流动资产扣除存货后除以流动负债。意思是因存货变现慢，迅速变现的能力；后面两个是短期和长期负债占总负债的比例；股东权益比，是股东权益债务的比例；经营现金流比债务，看短期赚现金与还钱的能力。资产负债率是指债务占总资产的比例。

操作：复制公式到通达信公式编辑器，，划线方式采用主图替换。

{流动比率}

流动比率:DRAWTEXT_FIX(ISLASTBAR,0,0.15,0,1 流动比率债（低于1不好，大于1好）),COLOR8000FF;

流动比率2016:=STRCAT(,CON2STR(FINONE(159,2016,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.15,0.15,0,流动比率2016),COLORYELLOW;

流动比率2017:=STRCAT(,CON2STR(FINONE(159,2017,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.2,0.15,0,流动比率2017),COLORYELLOW;

流动比率2018:=STRCAT(,CON2STR(FINONE(159,2018,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.25,0.15,0,流动比率2018),COLORYELLOW;

流动比率2019:=STRCAT(,CON2STR(FINONE(159,2019,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.3,0.15,0,流动比率2019),COLORYELLOW;

流动比率2020:=STRCAT(,CON2STR(FINONE(159,2020,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.35,0.15,0,流动比率2020),COLORYELLOW;

流动比率2103:=STRCAT(,CON2STR(FINONE(159,2021,0331),2));

DRAWTEXT_FIX(ISLASTBAR,0.4,0.15,0,流动比率2103),COLORYELLOW;

流动比率2106:=STRCAT(,CON2STR(FINONE(159,2021,0630),2));

DRAWTEXT_FIX(ISLASTBAR,0.45,0.15,0,流动比率2106),COLORYELLOW;

流动比率2109:=STRCAT(,CON2STR(FINONE(159,2021,0930),2));

DRAWTEXT_FIX(ISLASTBAR,0.5,0.15,0,流动比率2109),COLORYELLOW;

{速动比率：（流动资产-存货）/流动负债}

速动比率:DRAWTEXT_FIX(ISLASTBAR,0,0.2,0,1 速动比率（低于0.5不好，1左右好)),COLOR8000FF;

速动比率2016:=STRCAT(,CON2STR(FINONE(160,2016,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.15,0.2,0,速动比率2016),COLORYELLOW;

速动比率2017:=STRCAT(,CON2STR(FINONE(160,2017,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.2,0.2,0,速动比率2017),COLORYELLOW;

速动比率2018:=STRCAT(,CON2STR(FINONE(160,2018,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.25,0.2,0,速动比率2018),COLORYELLOW;

速动比率2019:=STRCAT(,CON2STR(FINONE(160,2019,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.3,0.2,0,速动比率2019),COLORYELLOW;

速动比率2020:=STRCAT(,CON2STR(FINONE(160,2020,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.35,0.2,0,速动比率2020),COLORYELLOW;

速动比率2103:=STRCAT(,CON2STR(FINONE(160,2021,0331),2));

DRAWTEXT_FIX(ISLASTBAR,0.4,0.2,0,速动比率2103),COLORYELLOW;

速动比率2106:=STRCAT(,CON2STR(FINONE(160,2021,0630),2));

DRAWTEXT_FIX(ISLASTBAR,0.45,0.2,0,速动比率2106),COLORYELLOW;

速动比率2109:=STRCAT(,CON2STR(FINONE(160,2021,0930),2));

DRAWTEXT_FIX(ISLASTBAR,0.5,0.2,0,速动比率2109),COLORYELLOW;

流债比率:DRAWTEXT_FIX(ISLASTBAR,0,0.25,0,流动负债比率（流动负债/总负债） ),COLOR8000FF;

流债比率2016:=STRCAT(,CON2STR(FINONE(164,2016,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.15,0.25,0,流债比率2016),COLORYELLOW;

流债比率2017:=STRCAT(,CON2STR(FINONE(164,2017,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.2,0.25,0,流债比率2017),COLORYELLOW;

流债比率2018:=STRCAT(,CON2STR(FINONE(164,2018,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.25,0.25,0,流债比率2018),COLORYELLOW;

流债比率2019:=STRCAT(,CON2STR(FINONE(164,2019,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.3,0.25,0,流债比率2019),COLORYELLOW;

流债比率2020:=STRCAT(,CON2STR(FINONE(164,2020,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.35,0.25,0,流债比率2020),COLORYELLOW;

流债比率2103:=STRCAT(,CON2STR(FINONE(164,2021,0331),2));

DRAWTEXT_FIX(ISLASTBAR,0.4,0.25,0,流债比率2103),COLORYELLOW;

流债比率2106:=STRCAT(,CON2STR(FINONE(164,2021,0630),2));

DRAWTEXT_FIX(ISLASTBAR,0.45,0.25,0,流债比率2106),COLORYELLOW;

流债比率2109:=STRCAT(,CON2STR(FINONE(164,2021,0930),2));

DRAWTEXT_FIX(ISLASTBAR,0.5,0.25,0,流债比率2109),COLORYELLOW;

非流债比率:DRAWTEXT_FIX(ISLASTBAR,0,0.3,0,非流动负债比率（非流动负债/总负债） ),COLOR8000FF;

非流债比率2016:=STRCAT(,CON2STR(FINONE(163,2016,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.15,0.3,0,非流债比率2016),COLORYELLOW;

非流债比率2017:=STRCAT(,CON2STR(FINONE(163,2017,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.2,0.3,0,非流债比率2017),COLORYELLOW;

非流债比率2018:=STRCAT(,CON2STR(FINONE(163,2018,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.25,0.3,0,非流债比率2018),COLORYELLOW;

非流债比率2019:=STRCAT(,CON2STR(FINONE(163,2019,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.3,0.3,0,非流债比率2019),COLORYELLOW;

非流债比率2020:=STRCAT(,CON2STR(FINONE(163,2020,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.35,0.3,0,非流债比率2020),COLORYELLOW;

非流债比率2103:=STRCAT(,CON2STR(FINONE(163,2021,0331),2));

DRAWTEXT_FIX(ISLASTBAR,0.4,0.3,0,非流债比率2103),COLORYELLOW;

非流债比率2106:=STRCAT(,CON2STR(FINONE(163,2021,0630),2));

DRAWTEXT_FIX(ISLASTBAR,0.45,0.3,0,非流债比率2106),COLORYELLOW;

非流债比率2109:=STRCAT(,CON2STR(FINONE(163,2021,0930),2));

DRAWTEXT_FIX(ISLASTBAR,0.5,0.3,0,非流债比率2109),COLORYELLOW;

股债比率:DRAWTEXT_FIX(ISLASTBAR,0,0.35,0,股东的权益/负债合计(不能低于40)),COLOR8000FF;

股债比率2016:=STRCAT(,CON2STR(FINONE(168,2016,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.15,0.35,0,股债比率2016),COLORYELLOW;

股债比率2017:=STRCAT(,CON2STR(FINONE(168,2017,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.2,0.35,0,股债比率2017),COLORYELLOW;

股债比率2018:=STRCAT(,CON2STR(FINONE(168,2018,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.25,0.35,0,股债比率2018),COLORYELLOW;

股债比率2019:=STRCAT(,CON2STR(FINONE(168,2019,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.3,0.35,0,股债比率2019),COLORYELLOW;

股债比率2020:=STRCAT(,CON2STR(FINONE(168,2020,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.35,0.35,0,股债比率2020),COLORYELLOW;

股债比率2103:=STRCAT(,CON2STR(FINONE(168,2021,0331),2));

DRAWTEXT_FIX(ISLASTBAR,0.4,0.35,0,股债比率2103),COLORYELLOW;

股债比率2106:=STRCAT(,CON2STR(FINONE(168,2021,0630),2));

DRAWTEXT_FIX(ISLASTBAR,0.45,0.35,0,股债比率2106),COLORYELLOW;

股债比率2109:=STRCAT(,CON2STR(FINONE(168,2021,0930),2));

DRAWTEXT_FIX(ISLASTBAR,0.5,0.35,0,股债比率2109),COLORYELLOW;

营金比债:DRAWTEXT_FIX(ISLASTBAR,0,0.4,0,经营现金流量/负债),COLOR8000FF;

营金比债2016:=STRCAT(,CON2STR(FINONE(170,2016,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.15,0.4,0,营金比债2016),COLORYELLOW;

营金比债2017:=STRCAT(,CON2STR(FINONE(170,2017,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.2,0.4,0,营金比债2017),COLORYELLOW;

营金比债2018:=STRCAT(,CON2STR(FINONE(170,2018,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.25,0.4,0,营金比债2018),COLORYELLOW;

营金比债2019:=STRCAT(,CON2STR(FINONE(170,2019,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.3,0.4,0,营金比债2019),COLORYELLOW;

营金比债2020:=STRCAT(,CON2STR(FINONE(170,2020,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.35,0.4,0,营金比债2020),COLORYELLOW;

营金比债2103:=STRCAT(,CON2STR(FINONE(170,2021,0331),2));

DRAWTEXT_FIX(ISLASTBAR,0.4,0.4,0,营金比债2103),COLORYELLOW;

营金比债2106:=STRCAT(,CON2STR(FINONE(170,2021,0630),2));

DRAWTEXT_FIX(ISLASTBAR,0.45,0.4,0,营金比债2106),COLORYELLOW;

营金比债2109:=STRCAT(,CON2STR(FINONE(170,2021,0930),2));

DRAWTEXT_FIX(ISLASTBAR,0.5,0.4,0,营金比债2109),COLORYELLOW;

{资产负债率}

资产负债率:DRAWTEXT_FIX(ISLASTBAR,0,0.45,0,1 资产负债率),COLOR8000FF;

资产负债率2016:=STRCAT(,CON2STR(FINONE(210,2016,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.15,0.45,0,资产负债率2016),COLORYELLOW;

资产负债率2017:=STRCAT(,CON2STR(FINONE(210,2017,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.2,0.45,0,资产负债率2017),COLORYELLOW;

资产负债率2018:=STRCAT(,CON2STR(FINONE(210,2018,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.25,0.45,0,资产负债率2018),COLORYELLOW;

资产负债率2019:=STRCAT(,CON2STR(FINONE(210,2019,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.3,0.45,0,资产负债率2019),COLORYELLOW;

资产负债率2020:=STRCAT(,CON2STR(FINONE(210,2020,1231),2));

DRAWTEXT_FIX(ISLASTBAR,0.35,0.45,0,资产负债率2020),COLORYELLOW;

资产负债率2103:=STRCAT(,CON2STR(FINONE(210,2021,0331),2));

DRAWTEXT_FIX(ISLASTBAR,0.4,0.45,0,资产负债率2103),COLORYELLOW;

资产负债率2106:=STRCAT(,CON2STR(FINONE(210,2021,0630),2));

DRAWTEXT_FIX(ISLASTBAR,0.45,0.45,0,资产负债率2106),COLORYELLOW;

资产负债率2109:=STRCAT(,CON2STR(FINONE(210,2021,0930),2));

DRAWTEXT_FIX(ISLASTBAR,0.5,0.45,0,资产负债率2109),COLORYELLOW;